Data Breakout let's you select exactly any inserted, updated or deleted row for message publication. These data events will then in real time reliably and transactionally be delivered to the message broker of your choice.
Data Breakout was built originally for a Danish corporate client running a large Microsoft SQL Server 2014 installation. In recent years it's been adjusted and installed successfully and running perfectly as well with Microsoft SQL Server 2017 and later installations. Once installed, Data Breakout connects seamlessly with your existing transactions, by enlisting with the distributed transaction coordinator (DTC). When your existing transactions commit, the data events for message delivery are also committed to the databases internal Service Broker message delivery mechanism. Change Data Capture (CDC) is not used by Data Breakout, and therefor not required!
Data events are streamed in real-time from Microsoft SQL Server to one or more message brokers, such as RabbitMQ or Google Cloud Pub/Sub. Data Breakout has been built for high performance and is capable of a sustained throughput of millions of messages per minute for even very small Microsoft SQL Server installations. Data Breakout was designed as well with the capacity of streaming and delivering database events regardless of message size! Developer friendly and easy to work with, framework conventions for addressing of messages and delivery to message topics and queues is available and programmable by your team.
