How to configure Google Analytics data source to use a service account in TIBCO Data Virtualization?
book
Article ID: KB0076170
calendar_today
Updated On:
TIBCO Data Virtualization
|
8.0.x and higher
|
Description
How to configure Google Analytics data source to use a service account in TDV?
Issue/Introduction
How to configure Google Analytics data source to use a service account in TIBCO Data Virtualization?
Resolution
1. Obtain the service key details. Below is an example what the details will look like in a JSON format.
----------------
"type": "service_account",
"project_id": "tibco-test",
"private_key_id": "72bc98031d1634f426bb28367975b3a40e2811e2",
"private_key": "-----BEGIN PRIVATE KEY-----\nMIIEv ...etc... DSznQ=\n-----END PRIVATE KEY-----\n",
"client_email": "tibco-smallgroup-service@tibco-test.new.serviceaccount.com",
"client_id": "3256713271835340812742",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://accounts.google.com/o/oauth2/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/tibco-smallgroup-service%40tibco-test.new.serviceaccount.com"
----------------
2. Verify that this is a service account i.e. it should contain the following line:
"type": "service_account",
3. Save the private_key value as a file with a .pem extension
Example: C:\temp\JoesPrivateKey.pem
Replace all '\n's in the file with actual newlines.
4. Configure the following settings in the Google Analytics data source:
InitiateOAuth: GETANDREFRESH
OAuthJWTCertType: PEMKEY_FILE
OAuthJWTCert: <path to the file containing the private_key extracted from the JSON>
Example C:\temp\JoesPrivateKey.pem.
OAuthJWTCertPassword: notasecret (i.e. no password is required for JoesPrivateKey.pem. If a password is required, enter it)
OAuthJWTCertSubject: *
(OAuthJWTIssuer: <the client_email value from the JSON file>
Example: tibco-smallgroup-service@tibco-test.new.serviceaccount.com
5. Click the data source's Test Connection button to verify that a connection may be made.
Feedback
thumb_up
Yes
thumb_down
No