Overview
Version
| FineDataLink Version | Functional Change |
|---|---|
| 4.0.7 | Scheduled Task supported data reading from and writing into the DM database. |
| 4.1.6.1 | Pipeline Task supported data writing into the DM database. |
| 4.1.6.3 | Data Service supported the DM database. |
| 4.1.11.4 | Real-Time Task supported data writing into the DM database. |
Function Description
FineDataLink supports connection to the DM database for data reading and writing using scheduled tasks, data writing using pipeline tasks and real-time tasks, and for releasing data services.
Preparation
Prerequisite
For details, see Overview of Data Connection.
Version and Driver
Download the driver package and upload it to FineDataLink. For the specific steps of uploading the driver package, see Driver Management.
| Supported Database Version | Driver Package |
|---|---|
| 8.1 | DmJdbcDriver18-8.1.2.79.jar |
Connection Information Collection
Collect the following information before connecting FineDataLink to the database.
IP address and port number of the database server
Username and password of the database
Procedure
1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, select a folder, and create a data connection, as shown in the following figure.
2. Set the data connection name. You can also modify the directory of the data connection.
3. Find the data source by searching the data source name or filtering the data source by Data Source Type, Supported Form, and Compatible Module, as shown in the following figure.
4. Click Custom, select the driver uploaded in the "Version and Driver" section, and enter the connection information collected in the "Connection Information Collection" section.
The DM database supports Kerberos authentication. For details about the Kerberos authentication method, see Kerberos Authentication in Data Connection.
5. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.
Data Source Usage
After configuring the data source, you can use it in Scheduled Task. For details, see Overview of Scheduled Task.
After configuring the data source, you can use it in Data Pipeline. For details, see Overview of Data Pipeline.
After configuring the data source, you can use it in Data Service. For details, see Overview of Data Service.
After configuring the data source, you can use it in Real-Time Task. For details, see Overview of Real-Time Task.
Previous：Greenplum Data Connection
