PolarDB Data Source Configuration Guide

Overview

PolarDB is a high-performance, scalable cloud-native relational database service provided by Alibaba Cloud. It is compatible with multiple database engines such as MySQL, PostgreSQL, and Oracle, offering high availability and elastic scalability. By configuring the PolarDB data source, you can achieve efficient data synchronization and analysis, meeting enterprise-level data management needs.

Parameter Configuration

When configuring the PolarDB data source, you need to provide the following information to ensure a successful connection to the PolarDB service:

Data Source Name: Specify a unique and easily recognizable name for your PolarDB data source.
JDBC Connection Address: Provide the JDBC connection address of the PolarDB instance, usually in the format jdbc:engine_type://host:port/database. For example, jdbc:mysql://polar-db-host:3306/mydatabase.
Username: Enter the username used to connect to the PolarDB instance.
Password: Provide the database password corresponding to the username.
Schema: Specify the default schema to connect to, such as public or any other schema you need to use.
Allow using configuration information to connect to all databases/Schemas: Enable this option to allow the configuration information to be used to connect to all databases and schemas in the PolarDB instance. If not enabled, the connection will be limited to the specified schema.
Data Source Description: (Optional) Add descriptive information for the data source to help you or other administrators understand the purpose or characteristics of the data source.

Connection Configuration

In terms of connection configuration, you can choose one of the following connection methods:

Direct Connection: Ensure that the connection information you entered is accessible over the public network. If the source has enabled an IP access whitelist, make sure the outbound IP address of the data integration service has been added to the whitelist. For specific IP addresses, please contact technical support.
Via SSH Tunnel: To enhance security, you can choose to connect to PolarDB via an SSH tunnel. Enable this option and provide the following SSH tunnel-related configuration information:
- SSH Server Address: Provide the IP address or domain name of the SSH server.
- SSH Port: Specify the port number the SSH server is listening on, usually 22.
- Username: Provide the login username for the SSH server.
- Password: Provide the password corresponding to the SSH server login username.

Notes

Ensure that all provided connection information is accurate and that the PolarDB service is accessible.
Protect your database credentials and SSH credentials to avoid leakage to unauthorized personnel.
Regularly check and update your data source configuration to adapt to changes in the database structure or new security requirements.
Monitor the running status of data synchronization tasks to promptly identify and resolve any potential issues.

Once the configuration is complete, you can select this PolarDB data source in data synchronization tasks to perform data import or export operations. Connecting via SSH tunnel can enhance the security of data transmission, especially when handling sensitive data. Enabling the "Allow using configuration information to connect to all databases/Schemas" option can provide greater flexibility, but use it with caution to avoid security risks.