Overview
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 chapter will introduce how to connect Access database of Google Analytics in FineReport.
Procedures
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 FineReport: 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 Test Connection to test and verify the data connection.
Log in with a GA administrator 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 FineReport
1. Open the designer and define the data connection.
2. Select the database as Others.
3. Copy cdata.jdbc.googleanalytics.GoogleAnalyticsDriver and paste it to the driver field.
4. Paste the URL that was just copied in section “Generateing URL for Data Connection”.
5. Set the Test before Getting Connection option to No.
Testing the Connection
1. Click Test Connection, and click OK when it pops up Connected successfully.
2. Establish a database query to perform SQL queries on the GA database.
