Overview
Version
FineReport Version | JAR Package Date |
11.0 | / |
Application Scenario
BigQuery is a fully-managed, serverless data warehouse that helps users manage and analyze data through built-in capabilities such as machine learning, geospatial analysis, and business intelligence. This chapter will introduce how to connect Google BigQuery in FineReport with CDatas JDBC driver.
Driver Preparation
Downloading the Diver
Driver Installation | Download Link |
Download the appropriate installation package based on different systems such as Windows, Cross-Platform Unix, Linux and Mac. |
Installing the Driver
a. 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:
b. Copy the files in the lib directory to the path under the webapps directory of FineReport: D:\FineReport 11.0\webapps\webroot\WEB-INF\lib
Connection Steps
Testing the Connection with CData Testing Tool
a. 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.
b. Perform parameter configuration as below:
Configuration Items | Values |
AuthScheme | OAuth |
ProjectId | Corresponding project ID |
InitiateOAuth | GETANDREFRESH |
c. 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.
d. When the connection test is successful, you need to copy the information in the Connection String (required for connection in FineReport), for example: jdbc:cdata:googlebigquery:InitiateOAuth=GETANDREFRESH;ProjectId=NameOfProject;DatasetId=NameOfDataset
Connecting Data in FineReport
1. Connecting Data in the Designer
a. Add data connection: Click Server > Define Data Connection in the designer of FineReport , and add a JDBC data connection.
b. Configurate data connection: Fill in the driver name and URL in each column according to your needs.
The setting items are as shown below:
| Setting item | Values | Note |
|---|---|---|
| Database | Others | / |
| Driver | cdata.jdbc.googlebigquery.GoogleBigQueryDriver | Input manually |
| URL | Paste the connection information from Connection String copied in section "Testing the Connection". | Example: jdbc:cdata:googlebigquery:InitiateOAuth=GETANDREFRESH;ProjectId=NameOfProject;DatasetId=NameOfDatase |
| Username and Password | Enter the set username and password of dataset | / |
c. Test connection: Click Test Connection, the system will prompt successfully connected when the connection is successful.
2. Connecting Data in the Decision-making System
a. Click Server > Platform Management in the designer to enter the Decision-making Platform.
b. Click Manage> Data Connection > Data Connection Management in the Decision-making Platform, and select the added JDBC data connection.
c. Click Edit > Test Connection, the system will prompt Connection Successful when the connection is successful.
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 FineReport.
