ServiceNow as a source

In the data pipeline wizard or when editing a pipeline, select the ServiceNow endpoint to load data from ServiceNow to a cloud data warehouse.

Load types

Autosync can load tables from the global scope and from the private application scope. You can use the following load types for ServiceNow:
  • Full load
  • Incremental (insert new, update changed)
  • SCD2 (preserve change history) to Amazon Redshift or Snowflake CDWs

Supported account types

To provide connection information, you can enter credentials in AutoSync, Designer, or Classic Manager. Designer and Classic Manager offer multiple account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list includes only compatible account assets. AutoSync supports the following Designer and Classic Manager account types:

AutoSync supports the following IIP Account types:

  • ServiceNow
  • ServiceNow OAuth2 Account

Connection configuration

ServiceNow properties include the following:

  • Credential label: A unique, meaningful name such as ServiceNow-IT-Admin. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
  • Username: A username for an account with the correct permissions for AutoSync to load and synchronize data.
  • Password: The password for the account. Multiple retries with an invalid password can cause your account to be locked.
  • Instance: Enter the name of your ServiceNow instance. This is the URL without the protocol. For example, if https://snaplogic.service-now.com/ is the URL of your ServiceNow instance, snaplogic.service-now.com is the instance name.
  • Share: (Optional) Select a user group to share this configuration with. Org admins create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
  • Validate and Save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
  • Select tables to synchronize: After configuring a destination, choose which tables to synchronize. AutoSync populates the list with the first 2,000 tables from your ServiceNow account. Use search to find tables that don't display on the list.