Hi Sagar, Thank you for the information, you solved our confusion. I also saw lots of links for documentation on Kafka, but I am confused which document I should use. So can you share the proper link from where I can read the documents.
Thanks, Avani Panchal On Mon, Jun 26, 2023 at 1:48 PM Sagar <sagarmeansoc...@gmail.com> wrote: > Hey Avani, > > Kafka Connect <https://kafka.apache.org/documentation/#connect> is the > tool > to use when you want to stream data to/from Kafka via external systems. One > would typically configure connectors which allow streaming data to/from > Kafka. There are 2 types of connectors: > 1) Source Connectors: Which stream data from external systems like > databases etc to Kafka and > 2) Sink Connectors: Which stream data from Kafka to external systems. > > Since you want to stream data from MySQL to SQL Server, with Kafka Connect > it would be a 2 step process: > > 1) Capture changes from MySQL to Kafka using connectors like JDBC source > connector or Debezium MySQL connector. > 2) Once the data is in Kafka, you can use JDBC sink connectors to stream > data from Kafka topics to the tables in SQL Server. > > Note that this is a very simplified view of how you can achieve your goal > of streaming changes from MySQL to SQL Server and I would recommend reading > the documentation of the individual connectors and the Kafka Connect > framework to understand how to make it work for your usecase. > > Thanks for your interest on Apache Kafka! > > Thanks! > Sagar. > > > On Mon, Jun 26, 2023 at 11:42 AM Avani Panchal > <avani.panc...@adit.com.invalid> wrote: > > > Hi, > > In my application I want to sync my client's data to my SQL server. at > > client place the database is MYSQL. > > > > How can I achieve this using Kafka? I read a lot of documents but I don't > > understand which setup I need and how I can achieve it. > > > > I was also wondering about "Book a demo with Kafka" but didn't find it. > > > > Please help me. > > > > Thank you, > > Avani > > >