Data Connection to Gbase 8s

Version

Application Scenario

This document introduces how to connect to the GBase 8s data source.

Note:

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

Version/Driver

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

Connection Information Collection

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

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

• Database name

• Username and password of the database

• Schema of the database to be connected

1. Log in to Decision-making Platform as the admin, choose System Management > Data Connection > Data Connection Management, and click New 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 Data Connection Management. For details, see Data Connection Permissions Overview.

2. Find the Gbase 8s icon, as shown in the following figure.

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

4. Click Click to Connect Database to test the connection, and select the database mode after successful connection. Finally, save the data connection, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

Null values of the Boolean type are not supported in FineBI and will be displayed as false.