Overview
Version
FineBI Version | Functional Change |
6.0 | / |
6.0.9 | Support direct connection |
Application Scenarios
This article will introduce how to connect to Gbase 8T data source.
Preparations
Version and Related Information
Download the driver package and upload it to FineBI.
Supported Database Version | Driver Download Link |
Gbase 8T (based on informix) |
Connection Information Collection
Before connecting 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
Database type
Procedures
1. Admin logs into FineBI, clicks Manage > Data Connection > Data Connection Management > New Data Connection.
Note: If you are common users and want to configure data connection, you need to get the permission of data connection management from the admin.
2. Find the Gbase 8T icon.
3. Select Custom and the driver uploaded in section "Version and Related Information", then enter the collected connection information.
4. Click Click to Connect to Database to test the connection. If the connection is successful, you can choose the connection mode as needed, and click Save to save the configuration.
Adding Database Tables to FineBI
There are two ways to add database tables to FineBI:
Add database tables.
Add SQL datasets.
Notes
Null value in Boolean type will be displayed as false in FineBI.