CData Connection Test to Google BigQuery

Versions

Application Scenarios

When connecting to data of Google BigQuery in FineBI, if the data volume reaches ten million or more, performance issues may occur when using the server dataset to directly call the BigQuery API. Therefore, this chapter will introduce how to connect to Google BigQuery by JDBC driver of CData.

Downloading the Diver

Installing the Driver

1. Install the driver package.

The directory after installation is shown as follows:

Note:

1. CDATA Driver has a one-month trial period, and requires payment if you want to use afterwards. The version used this time is the trial version.

2. You can refer to the readme.html file for instructions of using the driver.

Lib directory of installed driver is shown as follows:

2. Copy the files in the lib directory to the path under the webapps directory of FineBI: D:\FineBI 6.0\webapps\webroot\WEB-INF\lib

Testing the Connection with CData Testing Tool

1. In the directory where the driver is installed, double click the java -jar cdata.jdbc.googlebigquery.jar package to open the window for connection test provided by CData.

2. Perform parameter configuration as below:

3. Click Test Connection, and the user OAuth authorization webpage will automatically pop up. You need to agree to authorize to save account information for successful connection. For more details, see the document: https://cdn.cdata.com/help/DBG/jdbc/pg_oauthembeddedapp.html

Note: The authentication methods include user account and service account. User account is used for authentication in this test.

When the connection test is successful, you need to copy the information in the Connection String (required for connection in FineBI), for example: jdbc:cdata:googlebigquery:InitiateOAuth=GETANDREFRESH;ProjectId=NameOfProject;DatasetId=NameOfDataset

Data Connection in FineBI

1. Open Manage > Data Connection > Data Connection Management > New Data Connection, click All > Other JDBC, and add a JDBC connection.

2. Input the driver and URL: Enter cdata.jdbc.googlebigquery.GoogleBigQueryDriver in the driver field, paste the connection information from Connection String copied in section 3.1 "Test the Connection with CData Testing Tool" to Data Connection URL and select No for Test before Connect.

3. Create SQL dataset and update data.

Using the following SQL statement to create a SQL dataset and perform data updates:

Note: CData has high stability, and authentication is completed in the jar package. You only need to refer to section 3.1 "Testing the Connection with CData Testing Tool" to configure data connections in FineBI.