Data Connection to Google Analytics

Google Analytics is the data statistics program provided by Google. It can access data statistics and analysis for the target website, and provide various parameters for website owners to use. This article will introduce how to connect the Access database of Google Analytics in FineBI.

Downloading the Driver

You can find the JDBC driver from third-party providers, such as https://www.cdata.com/drivers/ganalytics/jdbc/ (with trial restrictions).

A driver for trial is provided in this chapter. Click GoogleAnalyticsJDBCDriver (3).zip to download the installation package.

Installing the Driver

1. Unzip the installation package.

2. Execute the command java -jar setup.jar in cmd for driver installation.

3. When installation is complete, three files will be generated as below:

Adding the Driver

Add all jar and lic files to the classpath of FineBI: webroot/WEB-INF/lib.

Generateing URL for Data Connection

1. Execute the command java -jar cdata.jdbc.googleanalytics.jar In cmd, and the Connection Properties dialog box of the JAR file will pop up. You can use this dialog box to configure and test data connection.

2. Refer to the instructions in the help document: http://cdn.cdata.com/help/DAE/jdbc/default.htm, and configure OAuth and other properties on Google API according to the actual situation. Enter the configured information into the corresponding fields in the Connection Properties dialog box.

For example, select InitiateOAuth as GETANDREFRESH:

3. Click Tset Connection to test and verify the data connection.

Log in with a GA admin account or a user account with permissions to obtain authorization.

4. Click Copy to copy the URL in connection string to Clipboard for next steps.

Connecting the Data in FineBI

1. Open the platform, choose System Management >  Data Connection and click New Data Connection.

2. Select Other JDBC in Others.

3. Name the data connection Others, copy cdata.jdbc.googleanalytics.GoogleAnalyticsDriver and paste it to the Driver field.

4. Paste the URL copied in section “Generateing URL for Data Connection”.

5. Set the Test before connect option to No.

Testing the Connection

1. Click Test Connection and Save when it pops up Connection successfully.

2. Establish a database query to perform SQL queries on the GA database.