Data Connection to GaussDB 200

Version

Application Scenario

This document introduces how to connect to the GaussDB 200 database.

Version and Driver

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

• Schema of the database to be connected

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 GaussDB 200 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:

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

4. Click Click to Connect Database to test the connection, and select the database schema as needed after successful connection. Finally, click Save, as shown in the following figure.

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

• Adding Database Tables

• Adding SQL Datasets

• To add a SQL dataset to FineBI, avoid single quotes in the field name in the SQL statement. Otherwise, FineBI will incorrectly adjust the field name to ?column?.

• To add a SQL dataset, if the SQL statement contains the order by statement, you must select extracted data as the data processing mode of the SQL dataset for data saving.