Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Offline Jobs)/ Configuring Connection Properties/ Configuring PostgreSQL Connection Properties
Updated on 2026-05-20 GMT+08:00
View PDF
Share

Configuring PostgreSQL Connection Properties

When using DataArts Migration, you can configure properties of the JDBC connection to the PostgreSQL data source to optimize the data migration process and resolve possible problems.

This section describes the connection properties. You can add JDBC properties of the connection to a specified data source and configure the properties by referring to the JDBC connector documentation of the corresponding database.

Optional Connection Properties

Property

Type

Description

connectTimeout

int

Connection timeout interval, in seconds. When a large amount of data needs to be migrated or the entire table is retrieved using query statements, the migration may fail due to connection timeout. You can customize the value to avoid failures caused by timeout.

socketTimeout

int

Socket timeout interval, in seconds. When a large amount of data needs to be migrated or the entire table is retrieved using query statements, the migration may fail due to socket timeout. You can customize the value to avoid failures caused by timeout.

useCursorFetch

boolean

The default value is true, indicating that CDM jobs communicate with relational databases using a JDBC connector over a binary protocol. If an error occurs during migration time conversion due to incompatibility of some third-party systems, you can set this parameter to false.

trustServerCertificate

boolean

A PKIX error may be reported during the creation of a secure connection. You are advised to set this parameter to true.

sslmode

string

The default value is disable. The connection to PostgreSQL may fail when SSL authentication is enabled. Set this parameter to require.

Configuration Method

  1. On the Management Center page, locate the PostgreSQL data source configuration.
  2. In the connection property configuration area, click Add to add properties for the connection.
  3. Enter property names and values as needed based on the descriptions in the preceding table.
  4. Save the change and test the connection to ensure that the configuration takes effect and data can be migrated properly.

Precautions

  • When configuring connection properties, ensure that you understand the meaning and function of each property to avoid data migration failures or other issues due to incorrect configurations.
  • If you have any questions during the configuration, refer to the official PostgreSQL JDBC connector documentation for more information and instructions.
  • You are advised to adjust and optimize connection properties based on the data migration scenarios and requirements to achieve optimal migration performance.

By properly configuring PostgreSQL connection properties, you can improve data migration stability and efficiency for smooth data integration.