Skip to main content

Replication Limitations

The Reporting DB does not support logical replication, Change Data Capture (CDC) or replication slot access. CDC/replication slots are not part of the cTrader product offering and are not supported as an external integration mechanism.

Query-Based Replication

Use query-based incremental replication with your existing read-only credentials. This method:

  • Works by periodically querying tables for incremental updates
  • Does not require additional permissions or infrastructure changes
  • Is supported by most ETL and data integration tools

Reporting API

For workloads that benefit from near-real-time event delivery, our RabbitMQ-based Reporting API can serve as an alternative integration path. This API:

  • Streams events as they occur
  • Avoids reliance on database-level replication
  • Can complement or fully replace periodic query-based extraction depending on your needs