1. Connecting Oracle Analytics Cloud to Your Data
  2. Connecting Oracle Analytics Cloud to Your Data
  3. Connect to Data
  4. Connect to Google Drive or Google Analytics

Connect to Google Drive or Google Analytics

You can create a connection to Google Drive or Google Analytics and use the connection to access data.

Before you start, set up a Google Drive or Google Analytics application. See the Google documentation.
We recommend that you use the latest Google Analytics connector, which supports column-listing.
  1. Ask your Oracle Analytics administrator to allow connections to Google.
    Your Oracle Analytics administrator must register the following domains as safe:
    api.google.com
    *.google.com
  2. On the Oracle Analytics Home page, click Create, then click Connection.
  3. Click Google Drive or Google Analytics to display the Create Connection dialog.
  4. Enter a Connection Name and optional Description.
  5. Copy the URL displayed in the Redirect URL field.
  6. In the Google application, on the Credentials page, paste the Redirect URL value into the Google "Authorized redirect URIs" field, then click Add.
  7. In Google, on the Credentials page copy the "Client secret" value and the "Client ID" value.
  8. In Oracle Analytics, paste the Google 'Client secret' value into the Client Secret field.
  9. In Oracle Analytics, paste the Google 'Client ID' into the Client ID field.
  10. In the Google application, copy the "Account ID" from the Account details and copy the "Property ID" from the Property details.
    In the Google administration settings, navigate to Account, then Account details to obtain the "Account ID", and navigate to Property details to obtain the "Property ID".
  11. In Oracle Analytics, use the "Account ID" and "Property ID" that you copied in the previous step to specify the Account ID value and the Property ID value, then click Authorize.
  12. In the Google prompt to authorize the connection, click Allow.
    The Create Connection dialog refreshes and displays the name of the Google account, and its associated email account.
  13. Save the connection.
  14. Use the connection to connect to your data. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created.