Transform Map Basic Understanding

[SNOW User8]

Hi All,

I need to know how transform map is working in service now.

How the data send from the Source Table to Destination Table?

Is there any schedule job required to make a transform?

Is the data totally moved or copied from Source to Destination?

Could anyone help me with this?

Regards,

Anna.

[corina]

Hello Anna.

These articles should help you understand the process

Importing data using import sets

Run an import

Best Regards

Corina

[Justin Abbott]

1) The Transform Map uses a field mapping to take values from the source and place it on the target.

2) Scheduled jobs aren't required for Transform Maps. You can set a Scheduled Import if necessary, however.

3) The data is just copied from the source to the target. The source values remain in the form of Import Set Records.

Here's some documentation that may help your understanding: Transform maps.

[tahnalos]

Simply put, Transform maps massage the data from the source to the destination.   Because imported data may be in an order or format that may not be compatible with your target, transform maps are supposed to point to where the data needs to go.   Transform scripts are attached to transform maps, and further massage the data so it is in a format that your target table will be able to understand.

The below link should help.

http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps

[Venkateswarlu K · Accepted solution]

Hi Anna

How the data send from the Source Table to Destination Table?

For this initially from the source table we are exporting the data into JDBC/XML/EXCEL then we are creating the one staging table in the target instance for importing this data in target table after that we are using the transform map for mapping fields.

Is there any schedule job required to make a transform?

If u want to import the data from the data sources it is also possible using the schedule import set module

Is the data totally moved or copied from Source to Destination?

Just we are copying the data in the format of JDBC/XML/EXCEL from the source table to target

Can u pls go through the following link for more information

http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0

http://wiki.servicenow.com/index.php?title=Transform_Map_Scripts#gsc.tab=0

Create a transform map