Forum Discussion
Sending messages on table rows updates/inserts/deletes to RabbitMQ from SQL Server
We have a requirement here. Whenever certain rows in a table are inserted, updated or deleted, we need to send messages to a message broker for further processing. Currently we are using triggers and...
Yes, you can use Debezium, an open-source platform for change data capture (CDC), to integrate SQL Server with RabbitMQ for sending messages based on database events. Alternatively, you can implement custom code to capture database changes and publish them to RabbitMQ using RabbitMQ client libraries.
The examples in Internet shows Apache Kafka (Kafka connect) instead of RabbitMQ. Could you please give a pointer where Debezium could be used with CDC in SQL Server ad send messages to RabbitMQ?
- To integrate Debezium with RabbitMQ for CDC from SQL Server:
1. Set up Debezium to capture SQL Server changes.
2. Configure Debezium to send events to RabbitMQ.
3. Start the connectors.
4. Verify data streaming.- Hi Fatima,
Could you please provide some pointers such that it could be implemented.
Thanks in advance
Ambar Ray
