Configuring Authentication

You can configure the Simba Google Ads ODBC Connector to authenticate the connection to the database using one of several methods. For more information, see the following sections:

Configuring Authentication With an Access Token

If you already have a valid access token, specify it in your DSN so that the connector can use it to authenticate the connection.

To configure authentication with an access token:

  1. Set the Auth_Type property to Access Token.
  2. Set the Auth_AccessToken property to the access token used for authentication.
  3. Set the Developer_Token property to the developer token associated with the manager account that you use to grant access to the Ads API.
  4. Set the Client_Customer_Id property to the client customer ID of the Ads account that you want to fetch report data for.

Configuring Authentication With Your Ads Credentials

You can configure the connector to use OAuth 2.0 to authenticate your connection.

To authenticate using OAuth 2.0:

  1. Set the Auth_Type property to Access Token.
  2. Set the Auth_Scope property to a comma-separated list of OAuth scopes for the access token.
  3. Set the Auth_Client_ID property to the OAuth 2.0 client ID used to generate the completed redirect URI and the authorization URL.
  4. Set the Auth_Client_Secret property to the OAuth 2.0 client secret used to generate the completed redirect URI and the authorization URL.
  5. Set the Developer_Token property to the developer token associated with the manager account that you use to grant access to the Ads API.
  6. Set the Client_Customer_Id property to the client customer ID of the Ads account that you want to fetch report data for.

Configuring Authentication With Service Authentication

You can configure the connector to use the Ads service account to authenticate the connection.

To configure authentication with Service Authentication:

  1. Set the Auth_Type property to Service Authentication.
  2. Set the Auth_Email property to the email ID associated with the service account.
  3. Set the Auth_KeyFilePath property to the full path of the plain text JSON object or .p12 or .json key file that is used to authenticate the service account email address.
  4. Set the Developer_Token property to the developer token associated with the manager account that you use to grant access to the Ads API.
  5. Set the Client_Customer_Id property to the client customer ID of the Ads account that you want to fetch report data for.