ServiceNow Setup Guide
Follow our setup guide to connect ServiceNow to Fivetran.
Prerequisites
To connect ServiceNow to Fivetran, you need:
- A ServiceNow Service Account with access to the following tables:
sys_db_objectsys_dictionarysys_audit_deletesys_user- Any tables you want to sync
- To enable table auditing
- A ServiceNow account with access to the ServiceNow API without requiring Single Sign-On (SSO) authentication.
IMPORTANT: You don't have to include the tables listed above in the connector schema. Including these tables slows the sync due to their large size.
NOTE: You can grant
adminandsnc_read_onlyroles to your Service Account if you want to avoid setting up complex ServiceNow access control lists.
Setup instructions
Find your ServiceNow Instance ID
Log in to your ServiceNow account.
Look in the URL to find your Instance ID (for example,
https://InstanceID.service-now.com).
Make a note of your Instance ID. You will need it to fill in your connector setup form.
Set up OAuth
In your ServiceNow account, select OAuth -> Application Registry in the left menu.
Click New.
Select Create an OAuth API endpoint for external clients.
Enter an application name (we suggest
Fivetran) in the Name field.
Make a note of the Client ID. You will need it to fill in your connector setup form.
Specify Client Secret and make a note of it. You will need it to fill in your connector setup form in Fivetran. Alternatively, you can leave the Client Secret field blank to automatically generate the value when you save the OAuth application data. You can see the generated client secret by clicking the Unlock button.
Leave Accessible from as the default value of All application scopes.
Make sure that the Active checkbox is selected.
Click Submit to register the application.
Go to User Profile and ensure that the integration user's timezone is GMT.
Finish Fivetran configuration
In the connector setup form, enter the Destination schema name of your choice.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
Enter the Client ID and Client Secret you found in Step 2.
Enter the Instance ID you found in Step 1.
Enter your Service Account Username and Password.
Click Save & Test. Fivetran will take it from here and sync your ServiceNow data.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration