CODEWITHSUNDEEP
azureapache-kafkaazure-sql-databaseapache-kafka-connect
thebigshaikh
thebigshaikh

Reputation: 103

Is it possible to connect Apache Kafka to Azure SQL Database?

I have an application to develop where it is required to connect Azure SQL DB to Apache Kafka. Azure DB----> SOURCE CONNECTOR --->Kafka Topic. Is there any such connector available? If not, how else can this be done?

Upvotes: 2

Views: 3748

Answers (2)

Leon Yue
Leon Yue

Reputation: 16401

I found a connector Fivetran can do that. I haven't try it but I think you can learn from it.

Reference: Connect Azure SQL Database and apache-kafka data with Fivetran.

Documentation: Fivetran Documentation.

Hope this can be useful for you.

Upvotes: 0

Robin Moffatt
Robin Moffatt

Reputation: 32050

Assuming Azure SQL DB supports JDBC you can use the JDBC Source connector (deep dive here)

I've not tried it but you might want to see if the SQL Server log-based CDC options work too, available as Kafka Connect connectors:

The difference between query-based (JDBC) capture and log-based CDC is explained in this article.

Upvotes: 1

Related Questions