Kingbase Data Connection

Version

Application Scenario

This document introduces how to connect theKingbase database to FineBI.

Note: 

This database does not support data tables with direct connection attributes.

Version and Driver

Connection Information Collection

• IP address and port number of the database server

• Username and password of the database

• Database name

• Schema of the database to be connected

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 Kingbase icon, as shown in the following figure.

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

Note:

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

4. Click Click to Connect Database, and select the required schema after successful connection. (If no schema is selected, the default schema will be used.) Finally, save the data connection, as shown in the following figure.

• Adding Database Tables

• Adding SQL Datasets