ServiceNow IntegratION

ServiceNow data can be integrated and synchronized codeless with various external systems, on premises or in the cloud, using the Layer2 Cloud Connector Enterprise Edition.
 
Learn on this page how the data integration of ServiceNow and SharePoint is working with the Layer2 Cloud Connector Enterprise Edition by using the step-by-step screenshot tutorial and reading our important advice and frequently asked questions. Make use of the benefits and features of this data integration tool by trying it out yourself: Free Trial Registration

ServiceNow step-by-step data integration via the Layer2 Cloud Connector

Use this step-by-step-introduction to get through the whole product and data integration configuration easily. Some steps require a copy-paste task of code snippets. Please follow the recommendations in this instruction closely.

Before you can proceed with the configuration, please be aware that you need to generate a ClientID and ClientSecret for your ServiceNow Application. Therefore, you have to go to your instance and note the name.

Specific connection settings for your ServiceNow integration

Please copy and paste this connection string and Select Statement into the designated field like described in Step 2.5 of the step-by-introduction above.

Instance=<INSTANCE_NAME>;OAuthClientID=<YOUR_CLIENT_ID>;OAuthClientSecret=<YOUR_CLIENT_SECRET>;Username=<INSTANCE_ADMIN_USERNAME>;InitiateOAuth=GETANDREFRESH;Other='BatchSize=1';

Please enter the following SQL query into the "Select Statement" as well and adjust the placeholder.

SELECT TOP 5 * FROM system_user  

Don't forget to set the password!

You can get all available tables with:  

SELECT * FROM sys_tables;

You can get all available views with:  

SELECT * FROM sys_views;

Known Issues and Workarounds with ServiceNow integration

• There are other providers that can connect to ServiceNow, but we have only tested the one noted above. If you run into issues with trying to use a different vendor's provider with the Layer2 Cloud Connector, please contact support@layer2solutions.com for troubleshooting assistance.

Ready to go next steps?