You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@kafka.apache.org by Konstantine Karantasis <ko...@confluent.io> on 2018/01/16 06:04:35 UTC

Re: Connectors Information from Microsoft SQL Server to Kafka

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 <ha...@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
>