PolarDB PostgreSQL

TapData Cloud offers you cloud services that are suitable for scenarios requiring rapid deployment and low initial investment, helping you focus more on business development rather than infrastructure management. Free trial with TapData Cloud.TapData Enterprise can be deployed in your local data center, making it suitable for scenarios with strict requirements on data sensitivity or network isolation. It can serve to build real-time data warehouses, enable real-time data exchange, data migration, and more.TapData Community is an open-source data integration platform that provides basic data synchronization and transformation capabilities. This helps you quickly explore and implement data integration projects. As your project or business grows, you can seamlessly upgrade to TapData Cloud or TapData Enterprise to access more advanced features and service support.

Please follow the instructions below to successfully add and use PolarDB PostgreSQL databases in TapData Cloud.

Supported Version

PolarDB PostgreSQL 11

Prerequisites

Authorize Database Account (as a source)

GRANT SELECT ON ALL TABLES IN SCHEMA <schemaname> TO <username>;

Authorize Database Account (as a target)

GRANT INSERT, UPDATE, DELETE, TRUNCATE ON ALL TABLES IN SCHEMA <schemaname> TO <username>;

tip

The above are just basic permission settings. The actual scenarios might be more complex.

Please replace <schemaname> and <username> with the appropriate schema name and username in your actual configuration.