[Direct Connection] Data Connection to Kyligence Enterprise

Version

Application Scenario

This document introduces how to connect to the Kyligence Enterprise Edition data source.

Only the FineBI direct connection version is supported.

Version/Driver

URL format of the data connection: jdbc:kylin://Hostname:Port number/Database?fineBIDialect=kyligence

Note:

Download the appropriate driver version from the official website according to your own database version.

Connectin Information Collection

1. Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management. Click Save after successful upload, as shown in the following figure.

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

• IP address and port number of the server where the database is located

• Username and password of the database

• Schema of the database to be connected

1. Choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

2. Find the Kyligence database icon, as shown in the following figure.

3. Select the driver uploaded in section "Preparation", and enter the connection information collected in the section. To ensure the accuracy of the database extraction, you need to add ?fineBIDialect=kyligence to the direct data connection URL, as shown in the following figure.

Note:

You can optionally modify other advanced settings on the page. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

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