Populate User Data from SAP

[chrisp83]

Hi,

We're configuring a new ServiceNow instance and looking at ways to populate the user table. We're currently looking through how consistent the data is in our AD and SAP environment, it's a possibility that the SAP environment is more up to date so we're exploring what would be involved with using SAP as our single source of truth.

Has anyone had experience setting this up and can provide some information on how we might go about this? Also has anyone got any tips or issues they've come across while trying to do this?

Thanks,

Chris

[jarodm]

I don't have any SAP integration experience, but I would encourage you to explore other 'Foundational Data' conversations at the same time you discuss user source.

E.g.

• Users
  • VIPs
  • Supervisor data
• Locations
• Cost Centers
• Business Units
• Divisions/Departments
• Other items specific to your organization

[sachin_namjoshi]

Hello,

You can pull below information from SAP for user records with JDBC data source..

- Cost Center

- Org Unit

- Manager Data

You may find below post useful.

Integration with SAP

Regards,

Sachin

[chrisp83]

Thanks for the help.

At the moment we're just looking at pulling user information and not integrating incident/change management etc.

I've been reading around the topic a bit and believe using WebServices might be the way I need to go, does this sound right?

Thanks,

[chrisp83]

Hi Sachin,

Thanks for the info, just to confirm, the best way to pull user records into ServiceNow from SAP would be to connect directly yo the SAP DB using a JDBC connection form the MID server with a query to pull what ever information we would like in?

Thanks,

Chris