ServiceNow as a source

Select the ServiceNow endpoint when creating or editing a data pipeline.

Known limitations

ServiceNow has a maximum length for string and decimal types that can exceed the limitations of the target. AutoSync ignores the maximum length defined in ServiceNow for string and decimal types and instead uses the default precision of the target. MySQL has a default precision of 255, so values from ServiceNow with a precision of more than 255 will fail to load to a MySQL target.

Load types

Autosync can load tables from ServiceNow's global scope and from the private application scope. You can use the following load types:
  • 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:

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