'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.
Solution 1:[1]
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 and in more detail here.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Robin Moffatt |