Skip to main content

NineData Supports DWS to PostgreSQL Replication

After data is consolidated in Huawei Cloud DWS, many teams still need to move structures and datasets into PostgreSQL for application queries, reporting, delivery pipelines, or downstream processing. The challenge is not just exporting data. It is doing the transfer in a controlled, reusable, and verifiable way.

According to the latest NineData replication matrix, DWS -> PostgreSQL supports schema replication, full replication, and data comparison.

  • Delivering DWS datasets into PostgreSQL for downstream applications.
  • Migrating data by schema in smaller batches instead of one risky big bang.
  • Building a PostgreSQL environment for reporting, testing, or business-facing access.

What NineData does​

  • Schema replication to initialize target objects.
  • Full replication to complete historical data loading.
  • Data comparison to support result verification before delivery.
  • Unified task management for object selection, mapping, prechecks, and monitoring.

Current boundary​

  • In the current public release, this link does not support incremental replication.
  • The source needs USAGE on schemas and SELECT on tables and views.
  • The target PostgreSQL side needs DDL and read/write privileges.

Learn more​