could you please explain how to create imports table ie load data,create transform map,runtransform

[preddy1]

could you please explain how to create imports table ie load data,create transform map,runtransform?

show me with images

[Rajesh Mushke · Accepted solution]

Hey Praveen,

Importing data using import sets:

An import set acts as a staging table to store raw data from an external source.

About this task

The import process uses a transform map to add or update data from the import set to an existing ServiceNow table such as incident or problem.

Importing data: data flow

Use import sets to:

Procedure

• Manually import data from a file on your local system
• Manually import data from a data source
• Periodically import data from a data source with a scheduled import
• Programmatically import data from a file with a script
• Programmatically import data from a web service

• Create a data source

  Create a data source record to define what data an import set should import.

• Create a transform map

  Every import operation to a production table requires at least one transform map associated with an import set.

• Run an import

  You can manually run an import to immediately import data.

• Cancel an import in progress

  You can stop an import that is taking too much time.

• Review the import set

  Even if no errors were reported by the progress indicator, review how your data was imported into the new import set.

• Schedule a data import

  Scheduled imports make it is possible to specify that certain import operations should occur at some regular interval.

• Post CSV or Excel files directly to an import set

  An administrator can post CSV or Excel files directly to instance.

• Completed import sets

  After an import set completes, you can review the completed import and clean up import set tables.

Please Refer:

Importing data using import sets

you can also watch below videos:

ServiceNow Import Set and Data Sources

ServiceNow Imports Transform Maps Tutorial

Let me know if you need more help.

Thanks,

Rajashekhar Mushke

Community Leader -18

[Nomava Ntaka]

Please help

I am trying to connect to my other PDI - but no luck - I get the error for JDBC connection

"Could not connect to dev64128.service-now.com:3306 : Connection refused (Connection refused)"

[Rajanmehta]

Hello RajaShekhar,

If we want to automate this process (Bring the import set and add/update existing records in servicenow using transform map), how can we do it? Please advise.

Thanks,

Rajan 

[Yaswanth9]

Thanks a lot Raj, Can you please help on steps to import images from an Oracle table into Service now? We have several working Data Sources to sync the instnace with our Database. Now looking to import images that we store in a separate oracle table and then transform them into SN tables.