Using a Google Service Account

You can configure the connector to authenticate the connection with a Google service account. When you authenticate your connection this way, the connector handles authentication on behalf of the service account, so that an individual user account is not directly involved and no user input is required.

To authenticate your connection this way, you must provide a Google service account email address and the full path to a private key file for the service account. You can generate and download the private key file when you set up the service account.

Note:

To configure service account authentication:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
  2. From the OAuth Mechanism drop-down list, select Service Authentication.
  3. In the Email field, type your service account email ID.
  4. In the Key File Path field, type the full path to the .p12 or .json key file that is used to authenticate the service account ID.

Related topics