Import data from SAP

[Evan2]

Hi All,

We have a requirement to import and update the users data from SAP table to ServiceNow table when a new record is inserted or any record is updated in SAP. Please let me know how to achieve this integration and what are the details required from the SAP side to perform the integration.

Regards,

Nandan

[Community Alums]

Hi Evan,

You can setup JDBC data source to retrieve user data from SAP.

You can configure scheduled jobs to retrieve this data.

Also, you can define transform maps, transform scripts to transform data according to your requirements.

You can see it in action here: Integration of SAP and ServiceNow - YouTube

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Tam_s Holics]

Dear Evan,

There is an out of the box product for transferring SAP data to ServiceNow in a license compliant way: https://sta-technologies.com/sap-data-sync-for-servicenow/

You can schedule an SAP job that sends user data to ServiceNow every day (or hour or minute...).

It is important to have a "push" architecture and not "pull" the data from SAP (initiated from ServiceNow) because of SAP licensing.

Cheers,

Tamás