Transwarp Inceptor Data Connection

Version 

Application Scenario 

Enterprises that store business data in Transwarp Inceptor databases want to read/write data from/into Transwarp Inceptor databases using scheduled tasks via FineDataLink.

Version and Driver 

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

Connection Information Collection 

Collect the following information before connecting FineDataLink to the database.

• IP address and port number of the database server 

• Database name

• Username and password of the database

1. Log in to FineDataLink, choose System Management > Data Connection > Data Connection Management, click New Data Connection, and click the TRANSWARP INCEPTOR icon, as shown in the following figure.

Note:

 If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission. 

2. Click Custom, select the driver uploaded in the section "Version and Driver," and enter the connection information collected in the section "Connection Information Collection."

Transwarp Inceptor databases support Kerberos authentication. For details, see Kerberos Authentication in Data Connection. Before connecting:

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

• Check if the machine name in the hostname file (/etc/hostname) is consistent with the one in the hosts file (/etc/hosts).

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

• Configure the hosts file (/etc/hosts) for establishing a local connection. Add the remote mapping information, including the IP address and the machine name. For example, 192.168.5.206 centos-phoenix.

4. Configure the HDFS address if you need to write data into a Transwarp Inceptor database. The configuration details are as follows.

Note:

 Since Transwarp Inceptor is developed based on Apache Hive, you are advised to create a table in the Hadoop Distributed File System (HDFS) first and then load the table data into the target table to accelerate the writing.

5. Click Test Connection. If the connection is successful, click Save to save the configuration.

The data source can be used for data reading and writing in Data Synchronization and Data Transformation nodes.

FineDataLink 4.1.3 and later versions support data writing into partition tables that are created during task configuration when a Transwarp Inceptor database is used as the target database. For details, see Partition Table Creation and Data Reading/Writing.

For details about Transwarp Inceptor databases, see Transwarp Inceptor Instruction.