Data Connection to Gbase 8a

Version

Function Description

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

Version and 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 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

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and choose Create > 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 Permission Overview.

2. Find the GBase 8a icon, as shown in the following figure.

3. Set Driver to Custom, select the driver uploaded in section "Version and Driver", and enter the connection information in section "Connection Information Collection", as shown in the following figure.

Note:

Select Default from the Encoding drop-down list. If garbled characters appear, you can modify the encoding corresponding to the current data connection.

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

You can add database tables to FineBI by the following two methods.

• Adding Database Tables

• Adding SQL Datasets