Hello everyone,
I’m facing issues with replicating data from my Caché 2016 database to a PostgreSQL database. I need to handle around 300 data updates per minute, and whenever certain tables are modified, those changes must be reflected in other databases.
So far, I’ve tried various approaches, including:
- Setting up an intermediary API,
- Using Azure Service Bus,
- Leveraging Caché Jobs,
- All of which rely on table triggers as the entry point.
However, each of these solutions has led to performance bottlenecks and system lockups. I’m running out of ideas on how to proceed, as none of the
.png)

.png)
..png)

.png)
.png)

