Data Connection to Transwarp Inceptor

Version

Application Scenario

This document introduces how to connect to the Transwarp Inceptor data source.

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 database server

• Database name

• Username and password (if username and password authentication is used); client principal and keytab file path (if Kerberos authentication is used)

1. Log in to FineBI 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 Transwarp Inceptor 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."

Note:

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

Transwarp supports Kerberos authentication. For details about Kerberos authentication methods, see Kerberos Authentication in Data Connection. Before connecting the database, you need to check the following information.

• Check if the IP address corresponding to the machine name in /etc/hosts is a LAN IP address.

• Check if the machine name set in /etc/hostname is consistent with that set in /etc/hosts.

• Check if the IP address and machine name in the hosts file of the machine where FineBI is located are correct.

• In some cases, especially in non-public network environments, the hostname of the database server cannot be resolved by your client. In such cases, you need to configure the hosts file in /etc/hosts and add remote mapping (IP address and Machine name, for example, 192.168.5.206 centos-phoenix).

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