Connect to Google Drive

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

Before you start, set up a Google Drive application. See the Google documentation.

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
   See Register Safe Domains.
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, then click Authorize.
10. 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.
11. Click Save.
12. 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.