Toad Data Studio 1.1 - User Guide

Create Google Analytics Connections

Toad allows you to create connections to your Google Analytics data. A connection in Toad allows you to access the Google Analytics accounts and data that are available to you from your Google user account.

If you have multiple Google user accounts, you can create a separate Google Analytics connection in Toad for each account. For an explanation of Google accounts, see the following: https://developers.google.com/analytics/resources/concepts/gaConceptsAccounts

After creating a connection, see About Google Analytics Data Sources for more information about working with this data source.

About Google Analytics Connections

When you create a Google Analytics connection in Toad, you log in to Google using your Google account. During the connection creation process, you also grant Toad access to the Google Analytics data accessible from that Google account.

Toad provides you with an interface to the Google log-in and authorization pages and displays these pages within the Create New Connection (and Connection Properties) dialog. The Google pages displayed are independent of Toad. The log-in process is the same as you normally encounter with your other Web-based Google log-in procedures. The only difference is that by creating a connection in Toad, you are giving Toad permission to access your Google Analytics data. This is accomplished when you click Accept in the Google authorization page.

To create a Google Analytics connection

1. Click on the Connections toolbar (ALT+F+N).
2. In the Group list, select Google Analytics. The Google log-in page immediately displays within the Create New Connection dialog.

3. Enter the credentials (email address and password) for your Google account and click Sign in.

   Note: If you have multiple Google accounts and have previously logged in to Google (or connected through Toad), the Google log-in page may display the last Google account used. To specify a different Google account for the new connection, use the Google links/menu to select another account.

4. (optional) You can enter a name for your new account and select a category. You can also make these modifications later using the Connection Properties dialog.

5. In the Google authorization page that displays, click Accept to allow Toad access to your Google Analytics data. Toad then attempts to establish a connection to Google Analytics. If the connection is successful, the Create New Connection dialog closes.

6. Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.

Reauthorizing a Connection

If you encounter an error message when attempting to connect using your Google Analytics connection, Toad's authorization (access) to the Google account for that connection may have been lost. Use the following procedure to re-establish authorization for the connection.

You can also use this procedure to specify a different Google log-in account for a connection.

To Reauthorize

1. In the Navigation Manager, disconnect from the connection. You must disconnect before you can re-authorize.
2. After disconnecting, right-click the connection and select Properties.
3. In the Connection Properties dialog, click Reauthorize.
   • If you are no longer logged in to Google, the Google log-in page displays.
     • To reauthorize using the same Google account, re-enter your Google account credentials and click Sign-in. Then click Accept on the authorization page.
     • To specify a different Google account for this connection, use the Google links to switch the account just as you normally would in the Google Web site. Once you specify a different account, this is the Google account associated with this connection in Toad. Click Sign-in. Then click Accept on the authorization page.
   • If you are still logged in to Google, the Google page for granting Toad access to your Google Analytics data displays.
     • To reauthorize using the same Google account, click Accept.
     • To specify a different Google account for this connection, use the Google menu or links to switch the Google account just as you normally would in the Google Web site. Once you specify a different account, this is the Google account associated with this connection in Toad. Click Sign-in. Then click Accept on the authorization page.

Notes:

• The instructions provided here are based on the Google Website's workflow for the account log-in and the application authorization procedures that were in place at the time of this Toad Data Studio release.
• See Set Connection Categories for more information about creating connection categories.
• You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.

Related Topics

Troubleshoot Google Analytics Connections