Data Connection to Apache Kylin

Version

Application Scenario

This document introduces how to connect to the Apache Kylin database.

Version/Driver

Download the driver package and upload it to FineBI. For details, see the "Uploading the Database Driver" section in Driver Management.

Note: To upload the driver package, you need to decompress the Log JAR.rar file below to obtain the log JAR file and upload it to FineBI together with the driver package.

Connection Information Collection

Before connecting FineBI to the database, you need to collect the following information:

• IP address and port number of the database server

• Database name

• Username and password of the database

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, click Create, and select Data Connection, as shown in the following figure.

Note:

If you are not the admin, you can configure data connections only after the admin assigns you the permission on the data connection module. For details, see Data Connection Permission Overview.

2. Find the Apache Kylin database, as shown in the following figure.

3. Select Custom from the Driver drop-down list, select the driver uploaded in the "Version/Driver" section, and enter the connection information collected in the "Connection Information Collection" section.

Click Click to Connect Database, and select the database schema (Schema is available after successful connection.), as shown in the following figure.

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

Time Zone Discrepancy Issue

Regardless of the configured time zone, Kylin enforces GMT (UTC+0) timestamp conversion when outputting data, resulting in a consistent 8-hour offset for timezone-aware systems. When you query data in the Kylin database, if the result is 2018-01-01, the actual data retrieved from the database is 2017-12-31 due to time zone discrepancy.

Therefore, you need to manually add an 8-hour offset in SQL statements.

Data Table with Direct Connection Attributes

Since some functions are not supported by the Kylin database, data tables with direct connection attributes are subject to the following restrictions.

1. When you retrieve data tables with direct connection attributes from the Kylin database, note that the following functions are not supported due to inherent limitations of the Kylin database.

2. You cannot perform Left Join or Right Join operations on DATE and TIMESTAMP fields from data tables with direct connection attributes.