Integrations > Third Party Integrations > ServiceNow Integration Using Enhanced Generic Adapter > Setting up ServiceNow for the UCMDB Integration > Create Transform Maps between Staging Tables and Target Tables

Create Transform Maps between Staging Tables and Target Tables

Transform maps assure the mapping between staging tables and target tables. They provide the chance to process and filter the data before committing it in the target table. The transform maps will also be used to prevent duplicate from being created in ServiceNow by choosing a coalesce field.

All tables extending cmdb_ci have a correlation_id field. This field is used to contain the global_id sent from UCMDB. The value is unique and will serve as coalesce field.

The ServiceNow enhanced generic adapter offers the capability to not use the Correlation ID as coalesce field in case this field is used by a different integration and cannot be overwritten by UCMDB. In order to spare the Correlation ID field, see Create a Custom coalesce Field instead of Using the Correlation ID Field.

The transform map for the relationship table is the only one different than every other class model. The coalesce field is the combination of three attributes: parent, child, and type.

ClosedTo create the Transform map for all class models extending cmdb_ci
  1. Click Transform Maps under System Import Sets > Administration, and then click New.
  2. Fill in the name field. For example, UCMDB - SNOW Integration TM Windows server.
  3. Make sure the source table points to the inbound service created.
  4. Make sure the target table field points to the table targeted by the inbound service. (If you keep the Create transform map check box enabled, the source table and target table are automatically populated)
  5. Click the Auto Map Matching Fields link.
  6. In the Fields Maps tab, locate the field correlation_id and set coalesce to true.
ClosedTo create the Transform map for the Relationship table
  1. Click Transform Maps under System Import Sets > Administration.
  2. Fill in the name field. For example, UCMDB - SNOW Integration TM CI Relationship.
  3. Make sure the source table points to the inbound service created.
  4. Make sure the target table field points cmdb_rel_ci. (If you keep the Create transform map check box enabled, the source table and target table are automatically populated.)
  5. Click the Auto Map Matching Fields link.
  6. In the Fields Maps tab, locate the parent, child, and type fields, and then set coalesce to true for the three attributes.
  7. Click Update to save and exit. You might be invited to Index the Coalesce Fields.