Overview
Version
FineDataLink Version | Functional Change |
---|---|
4.1.3 | Supported the reading of partition tables from PostgreSQL. |
Function Description
FineDataLink supports connection to the PostgreSQL database for data reading/writing using scheduled tasks and pipeline tasks and for releasing data services.
Preparation
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 Download |
---|---|
PostgreSQL 9.4 7 and 9.5.0 | Download the latest version of the PostgreSQL driver. |
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
Database pattern
Procedure
1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, click New Data Connection, and click the PostgreSQL icon.
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. Fill in the connection information. Set Driver to Custom, and select the uploaded driver mentioned in the Version and Driver section.
You cannot set Pattern unless the database is connected. Click Click to Connect Database and then click Pattern, as shown in the following figure.
3. Click Test Connection. If the connection is successful, click Save.
Data Source Usage
After configuring the data source, you can use it in Data Development. For details, see Overview of Data Development.
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.
PostgreSQL 4.1.3 and later releases support the reading of partition tables from PostgreSQL. For details, see Partition Table Creation and Data Reading/Writing.