Important: If you are using TIBCO Cloud™ Spotfire, you can access data from Google BigQuery and Google Analytics in the Spotfire web client right away. You do not have to make any of the following configurations.
In the web clients, the Google Analytics connector supports creating new connections.
In the web clients, you can use the Google BigQuery connector access data from connections that you have created in an installed client.
To be able to access data from Google BigQuery and Google Analytics in Spotfire web clients, you must make sure your web clients are allowed to access the Google APIs. This requires that you make some configurations in your Google project and in Spotfire:
In your Google project, you must set up OAuth Credentials to use with Spotfire, and enter redirect URI:s for the Spotfire clients.
In Spotfire, you must configure the Google preferences to use your project’s OAuth Client ID and Client Secret.
Prerequisites
The Google project you use to make these configurations must have the APIs for Google BigQuery and/or Google Analytics enabled, depending on what connectors you want to enable.
Note: If you are going to use the Google BigQuery connector, make sure your Google project has the required OAuth 2.0 scopes for viewing and managing BigQuery data.
Configuring your Google project
In the Google API console, you must create OAuth credentials for Spotfire in your Google project.
See the official documentation from Google for detailed instructions on how to set up and configure OAuth credentials in Google Cloud Platform.
Client ID and Client Secret
When you create OAuth credentials for your Google Cloud Platform project, note down the Client ID and Client Secret.
Redirect URIs
In the OAuth credentials, add the following addresses as Redirect URIs:
https://<spotfire_server>/spotfire/wp/oauth2/code
Note: The above URL is used to allow access from web clients on your Spotfire Server.
http://localhost:55931
http://localhost:55932
Note: The above URLs are used to allow access from Spotfire installed clients. You can use any port numbers you want in the URL (if you do not want to use the suggested port numbers above) but it must be the same as the port numbers that you specify for the LocalRedirectPorts preference in Spotfire.
Configuring the Google preferences in Spotfire
In Windows, open Spotfire Analyst and log in as a user with administrator rights.
On the menu bar, select Tools > Administration Manager....
In Administration Manager, go to the Preferences tab. In the list of Available groups, click to select the group of users that you want to enable to work with Google data.
Under the list of Preferences for the selected group, click Edit.
In the Edit Preferences dialog, to configure both the Google BigQuery and Google Analytics connectors, select Connectors > Google Authentication.
Tip: To configure only one of the Google connectors, click either Connectors > Google BigQuery or Connectors > GoogleAnalytics instead.
In the ClientID and ClientSecret fields, enter the Client ID and Client Secret from your Google Project’s OAuth credentials.
In the LocalRedirectPorts field, enter 55931, 55932 (separate each entry with a comma or semicolon).
Note: The port numbers must be the same as the port numbers that you used for the localhost redirect URIs in your Google Project. If you opted to use port numbers that are different from the default 55931, 55932, enter those port numbers instead.
To save your changes and close the Edit Preferences dialog, click OK.
See also:
Accessing Data from Google BigQuery
Details on Google BigQuery Connection
Supported Functions - Google BigQuery
Repeated Columns from Google BigQuery