You might find this connector useful for your use case: https://github.com/jcustenborder/kafka-connect-cdc-mssql
Konstantine On Tue, Dec 12, 2017 at 9:29 PM, harish reddy m <harishredd...@gmail.com> wrote: > Hi Team, > > We have a requirement of replicating the data from MSSQL Source database to > MSSQL target database. > > We are using SQL Server 2014 Web edition as the source database and target > database as well. We want to replicate the data from Source database to > target database realtime. > > Enabled the change tracking on the SQL Server Database side as change data > capture is not supported in web edition of SQL Server 2014. > > So we are using Kafka Connect to read the changes (updates/inserts) from > the source database and then push them to target database in realtime. > > Could you help us in getting if any Kafka connectors for MSSQL to Kafka and > Kafka to MSSQL are available for the above scenario. > > We are open for any suggestions as well for the above requirement. > > Thanks > Harish >