Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync servicenow.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

The CloudQuery ServiceNow plugin pulls configuration out of ServiceNow resources and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).

Example Configuration #

kind: source
spec:
  name: servicenow
  path: cloudquery/servicenow
  version: "v1.5.7"
  tables:
    - "now_cmdb_ci_*"
    - "now_cmdb_rel_ci"
    - "now_change_request"
    - "now_incident"
    - "now_sys_user*"
  destinations: ["postgresql"]
  spec:
    # required
    instance: "${SERVICENOW_INSTANCE}"
    username: "${SERVICENOW_USERNAME}"
    password: "${SERVICENOW_PASSWORD}"

Available Tables and Data #

All ServiceNow tables are available. Table names are prefixed with now_.

Authentication #

In order to fetch information from ServiceNow, cloudquery needs to be authenticated. Either username/password or an access token is required for authentication.

The minimal roles required for the plugin to sync tables are admin and snc_read_only. These should give read only access to all tables.

Configuration Reference #

This is the (nested) spec used by the ServiceNow source plugin.

instance (string) (required)
Name or URL of your ServiceNow instance.
auth_mode (enum) (optional) (default: basic)
Authentication mode to use. Possible values are basic and token.
username (string) (optional)
Username to use for authentication. Only valid in basic auth mode.
password (string) (optional)
Password to use for authentication. Only valid in basic auth mode.
access_token (string) (optional)
Access token to use for authentication. Only valid in token auth mode.
concurrency (integer) (optional) (default: 100)
Number of resources to sync in parallel.
discovery_concurrency (integer) (optional) (default: 100)
Number of goroutines to use for discovering table schemas.