how to sync data between Azure Cosmos DB for PostgreSQL clusters?

Question

Hi, I want to sync data from a Azure Cosmos DB for PostgreSQL cluster to other. Does Azure Cosmos DB for PostgreSQL support CDC now? Can I use some tools like debezium to do it? If not, is there any other solution?

Thanks!

Answer 1

Hi Peter •,

Welcome to Microsoft Q&A forum.

As I understand, you want to sync data between two Azure Cosmos DB for PostgreSQL.

Azure Data Factory for real-time ingestion could be used for this scenario.

Here are key reasons to choose Azure Data Factory for ingesting data into Azure Cosmos DB for PostgreSQL:

• Easy-to-use - Offers a code-free visual environment for orchestrating and automating data movement.
• Powerful - Uses the full capacity of underlying network bandwidth, up to 5 GiB/s throughput.
• Built-in connectors - Integrates all your data sources, with more than 90 built-in connectors.
• Cost effective - Supports a pay-as-you-go, fully managed serverless cloud service that scales on demand.

Note:

Data Factory doesn't support private endpoints for Azure Cosmos DB for PostgreSQL at this time.

Steps are described here: https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/howto-ingest-azure-data-factory#steps-to-use-data-factory

Let us know if this helps or you have a different ask.

Thanks