CODEWITHSUNDEEP
sql-serverapache-kafkaapache-kafka-connectdebeziumconfluent-cloud
Pranjit Borah
Pranjit Borah

Reputation: 15

How to stream data from locally installed SQL Server to Kafka topic on confluent cloud, without installing Kafka in the local machine

SQL Server database is in local system
Kafka is configured in confluent cloud
Operating system of the local machine is Windows 10
Is there any way without installing Apache Kafka in the local machine to stream data out from SQL Server database to Kafka topic on confluent cloud.

Upvotes: 1

Views: 971

Answers (1)

Robin Moffatt
Robin Moffatt

Reputation: 32050

You don't need to install Apache Kafka locally in order to stream data from your database.

Since you are using Confluent Cloud it is easiest to use one of the two available managed connectors for getting data from SQL Server. Since you're using a local machine you're going to have to make sure you can expose it on a fixed IP and port (the connector is "pull" from Confluent Cloud and not a "push" from your local machine, if that makes sense).

Which connector you use depends on factors covered briefly here.

Upvotes: 2

Related Questions