Data Connection to INFROMIX

Version

Application Scenario

This document introduces how to connect the Infromix database to FineBI.

Version and Driver

Download the driver package and upload it to FineBI. For details of uploading steps, see Driver Management.

Connection Information Collection

Before connecting FineBI 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, 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 Data Connection Management. For details, see Data Connection Permission Overview.

2. Find the INFORMIX data source, as shown in the following figure.

3. Enter the connection information retrieved in section "Connection Information Collection". Then select Default as the driver is built-in.

The schema options appear only after the database is connected by clicking Click to Connect Database, as shown in the following figure.

The input format for Database Name is Database Name:INFORMIXSERVER=Server Name.

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

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets