KingbaseES (PostgreSQL) Data Connection

Version

Application Scenario

FineDataLink supports connection to KingbaseES (PostgreSQL) data sources for data reading and writing using scheduled tasks and for publishing data services.

Prerequisite

For details, see Overview of Data Connection.

Version and Driver

1. For independently deployed FineDataLink projects, place the downloaded driver package in FineDataLink installation directory\webapps\webroot\WEB-INF\lib.

For FineOps-deployed FineDataLink projects, place the driver in the customlib folder in the mounting directory of the project. If you are unsure of the mounting directory location, see Exporting Project Deployment Information.

For a cluster project, you must upload the driver file to the corresponding folder on each cluster node.

2. Restart the FineDataLink project.

Connection Information Collection

Before you connect FineDataLink to the database, collect the following information:

• IP address and port number of the database server

• Username and password of the database

• Database name

• Schema of the database to be connected

Connection Procedure

For details about how to create a data connection, see Data Source Creation and Management.

Scheduled Task

You can read data from and write data into KingbaseES(PostgreSQL) data sources.

Data Reading

1. The Parallel Read function is unavailable.

2. Reading stored procedures is not supported.

3. Displaying table descriptions is supported.

4. Writing SQL statements to read partition tables is supported.

Data Writing

1. DDL change synchronization is not supported when KingbaseES (PostgreSQL) serves as the target of a scheduled task.

2. Writing data to existing partition tables is supported, but the Partition Setting function is unavailable during automatic table creation.

Data Service

Data reading from KingbaseES (PostgreSQL) data sources and publishing data query APIs are supported.

For details, see Overview of Data Service.

Data Management

The Database Table Management function is available.

General Configuration

Under System Management > General Configuration, the Auto Table Creation Configuration function is available for this data source, while the Field Mapping Rule function is not.