ServiceNow Setup Guide link

Updated November 16, 2023

Follow our setup guide to connect ServiceNow to Fivetran.

Prerequisiteslink

To connect ServiceNow to Fivetran, you need:

• A ServiceNow Service Account with access to the following tables
  • sys_db_object
  • sys_dictionary
  • sys_audit_delete
  • 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 admin and snc_read_only roles to your service account if you want to avoid setting up complex ServiceNow access control lists.

Setup instructionslink

Find your ServiceNow Instance IDlink

1. Log in to your ServiceNow account.

2. Look in the URL to find your Instance ID (for example, https://InstanceID.service-now.com).

   

3. Make a note of your Instance ID. You will need it to fill in your connector setup form.

Set up OAuthlink

1. In your ServiceNow account, select OAuth -> Application Registry in the left menu.

2. Click New.

   

3. Select Create an OAuth API endpoint for external clients.

   

4. Enter an application name (we suggest Fivetran) in the Name field.

   

5. Make a note of the Client ID. You will need it to fill in your connector setup form.

6. 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.

7. Leave Accessible from as the default value of All application scopes.

8. Make sure that the Active checkbox is selected.

9. Leave the default values for Refresh Token Lifespan and Access Token Lifespan.

10. Click Submit to register the application.

Finish Fivetran configurationlink

1. In the connector setup form, enter the Instance ID you found in Step 1.

2. Enter the Client ID and Client Secret that you found in Step 2.

3. Enter your Service Account username and password.

4. Click Save & Test. Fivetran will take it from here and sync your ServiceNow data.

Related articleslink

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home