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.

The latest Google Analytics connector supports column-listing. If you can’t access column lists using a Google Analytics connection, create another Google Analytics connection and use that one to get the column-listing capability.

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, and then click Connection.
3. Click Google Drive or Google Analytics.
4. Configure the connection details.
   1. Enter a Connection Name and Description.
   2. Copy the URL displayed in the Redirect URL field.
   3. Open and sign into the Google application. Copy and paste the Redirect URL into the Google Authorized redirect URIs field and then click Add.
   4. In Google, locate the Client ID field, copy the key value and paste it into the Oracle Analytics Client ID field.
   5. In Google, locate the Client Secret field, and then click Show.
   6. In Oracle Analytics, enter the Google Client Secret value into the Client Secret field.
   7. In View Name, specify the name of the default reporting view in Google Analytics that you'd like to analyze.
   8. Click Authorize.
   9. 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.
5. Save the connection.