Schedule a ServiceNow transfer

Console

1. Go to the Data transfers page in the Google Cloud console.

   Go to Data transfers

2. Click add Create transfer.

3. In the Source type section, for Source, select ServiceNow.

4. In the Data source details section, do the following:

   • For Instance ID, enter the ServiceNow instance ID. You can get this from your ServiceNow URL—for example, https://INSTANCE_ID.service-now.com.
   • For Username, enter the ServiceNow username to use for the connection.
   • For Password, enter the ServiceNow password.
   • For Client ID, enter the client ID from your OAuth credentials. To generate credentials, see Create OAuth Credentials.
   • For Client secret, enter the client secret from your OAuth credentials.
   • For Value type, choose one of the following:
     • To transfer the values stored in the database, choose Actual.
     • To transfer the display values of the columns, choose Display.

5. In the Destination settings section, for Dataset, select the dataset you created to store your data.

6. In the Transfer config name section, for Display name, enter a name for the data transfer.

7. In the Schedule options section, do the following:

   • In the Repeat frequency list, select an option to specify how often this data transfer runs. To specify a custom repeat frequency, select Custom. If you select On-demand, then this data transfer runs when you manually trigger the transfer.

   • If applicable, select either Start now or Start at set time and provide a start date and run time.

8. In the Service Account menu, select a service account from the service accounts associated with your Google Cloud project. The selected service account must have the required roles to run this data transfer.

   If you signed in with a federated identity, then a service account is required to create a data transfer. If you signed in with a Google Account, then a service account for the transfer is optional.

   For more information about using service accounts with data transfers, see Use service accounts.

9. Optional: In the Notification options section, do the following:

   • To enable email notifications, click the Email notification toggle. When you enable this option, the transfer administrator receives an email notification when a transfer run fails.
   • To enable Pub/Sub transfer run notifications for this data transfer, click the Pub/Sub notifications toggle. You can select your topic name, or you can click Create a topic to create one.

10. Click Save.

bq

Enter the bq mk command and supply the transfer creation flag, --transfer_config:

bq mk \
    --transfer_config \
    --project_id=PROJECT_ID \
    --data_source=DATA_SOURCE \
    --display_name=DISPLAY_NAME \
    --target_dataset=DATASET \
    --params='PARAMETERS'

Replace the following:

• PROJECT_ID (optional): Your Google Cloud project ID. If a project ID isn't specified, the default project is used.
• DATA_SOURCE: the data source (for example, servicenow).
• DISPLAY_NAME: the display name for the transfer configuration. The data transfer name can be any value that lets you identify the transfer if you need to modify it later.
• DATASET: the target dataset for the transfer configuration.

• PARAMETERS: the parameters for the created transfer configuration in JSON format. For example: --params='{"param":"param_value"}'. The following are the parameters for a ServiceNow data transfer:

  	ServiceNow parameter	Required or optional	Description
  connector.instanceId	Required	Instance ID of the ServiceNow instance
  connector.authentication.username	Required	Username of the credentials
  connector.authentication.password	Required	Password of the credentials
  connector.authentication.oauth.clientId	Required	Client ID of generated OAuth
  connector.authentication.oauth.clientSecret	Required	Client Secret of generated OAuth
  connector.valueType	Optional	Actual or Display (default: Actual)

  For example, the following command creates a ServiceNow data transfer in the default project with all the required parameters:

    bq mk \
      --transfer_config \
      --target_dataset=mydataset \
      --data_source=servicenow \
      --display_name='My Transfer' \
      --params='{"connector.authentication.oauth.clientId": "1234567890",
          "connector.authentication.oauth.clientSecret":"ABC12345",
          "connector.authentication.username":"user1",
          "Connector.authentication.password":"abcdef1234",
          "connector.instanceId":"https://dev-instance.service-now.com"}'
  

API

Use the projects.locations.transferConfigs.create method and supply an instance of the TransferConfig resource.