ServiceNow Setup Guide link
Updated November 16, 2023
Follow our setup guide to connect ServiceNow to Fivetran.
To connect ServiceNow to Fivetran, you need:
- A ServiceNow Service Account with access to the following tables
- Any tables you want to sync
- To enable table auditing
NOTE: You don't have to include the tables listed above to the connector schema. Including these tables only slows up the sync due to the large size of these tables.
NOTE: You can simply grant
snc_read_onlyroles to your service account if you want to avoid setting up complex ServiceNow access control lists.
Find your ServiceNow Instance IDlink
Log in to your ServiceNow account.
Look in the URL to find your Instance ID (for example,
Make a note of your Instance ID. You will need it to fill in your connector setup form.
Set up OAuthlink
In your ServiceNow account, select OAuth -> Application Registry in the left menu.
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.
Leave the default values for Refresh Token Lifespan and Access Token Lifespan.
Click Submit to register the application.
Finish Fivetran configurationlink
Enter the Client ID and Client Secret that you found in Step 2.
Enter your Service Account username and password.
Click Save & Test. Fivetran will take it from here and sync your ServiceNow data.