TDV Adapter for Google Spanner

Build 21.0.8137

Custom Credentials

When to Use a Custom OAuth App

You might want to create a custom OAuth app to change the information displayed when users log into Google Spanner to grant permissions to the adapter.

Desktop Authentication with a Custom OAuth App

Follow the steps below to authenticate with the credentials for a custom OAuth app. See Creating a Custom OAuth App.

Get and Refresh the OAuth Access Token

After setting the following, you are ready to connect:

  • OAuthClientId: Set this to the client Id assigned when you registered your app.
  • OAuthClientSecret: Set this to the client secret assigned when you registered your app.
  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
  • InstanceId: Set this to the Id of the instance you want to connect to.
  • Database: Set this to the name of the database you want to connect to.
  • ProjectId: Set this to the Id of the project you want to connect to.
When you connect the adapter opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The adapter then completes the OAuth process:
  1. Extracts the access token from the callback URL and authenticates requests.
  2. Refreshes the access token when it expires.
  3. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137