Skip to main content

​
Add the Google Spanner Connector

​
Authenticate to Google Spanner

After you add the connector, you need to set the required properties.
  • Instance Id: Enter the identifier (Id) of the Google Spanner instance to which you want to connect.
  • Database: Enter the name of the Google Spanner database to which you want to connect.
  • Project Id: Enter the project Id of the project where your Google Spanner instance resides.
CData Sync supports authenticating to Google Spanner in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

​
OAuth

​
OAuth JWT

​
GCP Instance Account

​
AWS Workload Identity

To connect with AWS Workload Identity federation credentials, specify the following properties:

  • Auth Scheme: Select AWSWorkloadIdentity.
  • AWS Workload Identity Config: Enter a semicolon-separated list of Key=Value properties, as shown in this example:

    AWSWorkloadIdentityConfig="AuthScheme=AwsRootKeys;AccessKey='AKIAABCDEF123456';SecretKey=...;Region=us-east-1"

    Note that it is optional as to whether you want to include the value within quotes.

  • Workload Pool Id: Enter The identifier (Id) of your Workload Identity Federation pool.
  • Workload Project Id: Enter the Id of the Google Cloud project that hosts your Workload Identity Federation pool.
  • Workload Provider Id: Enter the Id of your Workload Identity Federation pool provider.

​
Azure Workload Identity

To connect with single sign-on via PingFederate, specify the following properties:

  • Auth Scheme: Select AzureWorkloadIdentity.
  • Azure Workload Identity Config: Enter a semicolon-separated list of Key=Value properties, as shown in this example:

    AzureWorkloadIdentityConfig="AuthScheme=AzureServicePrincipal;AzureTenant=directory (tenant) id;OAuthClientID=application (client) id;OAuthClientSecret=client secret;AzureResource=application id uri;"

    Note that it is optional as to whether you want to include the value within quotes.

  • Workload Pool Id: Enter The identifier (Id) of your Workload Identity Federation pool.
  • Workload Project Id: Enter the Id of the Google Cloud project that hosts your Workload Identity Federation pool.

​
Complete Your Connection

To complete your connection:
  1. Specify the following properties:
  • Database Dialect: Select the dialect type for the Google Spanner database. The default dialect is GoogleStandardSQL.
  • (Optional) Database: Enter the name of the Google Spanner database to which you want to connect. If you leave this field blank, Sync attempts to expose all databases in the instance as separate catalogs. If you want to access multiple databases, ensure that the following OAuth scopes are configured:
  1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
  2. Connect to Google Spanner to connect to your Google Spanner account.
  3. Click Create & Test to create your connection.

​
More Information