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 SQL Server Service Broker for this purpose. But we want to use RabbitMQ for scalability and wider reach. Is there a third party solution component available to meet our requirements. We are ready to implement ourselves if 3rd party component is not available.
5 Replies
Consider leveraging RabbitMQ for real-time updates from SQL Server tables, enhancing scalability and extending reach Photo. Explore third-party solutions or implement custom integration for efficient message delivery and processing.
- 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.
