Overview
Version
FineDataLink Version | Functional Change |
---|---|
4.0.28 | Pipeline Task supported data writing into the SeaboxMPP database. |
4.1.5.5 | Scheduled Task supported the reading from and writing into the SeaboxMPP database. |
Function Description
FineDataLink supports connection to Seabox MPP for data writing using pipeline tasks and data reading and writing using scheduled tasks.
Preparation
Version and Driver
Download the driver package and upload it to FineDataLink. For the specific steps of uploading the driver package, see the section "Prerequisite" of Driver Management.
Supported Database Version | Driver Package Download |
---|---|
SeaboxMPP 21.0.3.398 | postgresql-42.1.4.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, and click New Data Connection, as shown in the following figure.

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 the SeaboxMPP icon.
3. Fill in the connection information.

You can modify the connection pool settings. For details, see Connection Pool Setting.
4. Click Test Connection. If the connection is successful, click Save to save the configuration.
Data Source Usage
Pipeline Task
For FineDataLink 4.0.28 and later releases, Pipeline Task supports data writing into the SeaboxMPP database. For details, see Overview of Data Pipeline.
Scheduled Task
For FineDataLink 4.1.5.5 and later releases, Scheduled Task supports the reading from and writing into the SeaboxMPP database.
When writing data into a SeaboxMPP database, you can set Load Method to COPY Loading or Common Loading. As shown in the following figure.
Load Method | Description | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Common Loading | It is selected by default for JDBC-based parallel loading. | |||||||||
COPY Loading | Prerequisites: To use COPY Loading, ensure the target database and users meet the following requirements:
Working principles: The loading effect varies with the write method when you select COPY Loading.
|