JDBC Confluent Connector - Microsoft SQL Server


Question 

How can I enable Microsoft SQL Server Protocol for the JDBC Connector

Answer 

To enable JDBC you need to download the sqlserver plugin from Microsoft and install it in the plugin.path

For example, let’s assume the plugin.path points to /connectors and the JRE running Kafka Connect is JRE8

plugin.path=/connectors JRE_VERSION=JRE8

To install the JRE8 SQL Server Connector in /connectors, run

curl -L https://go.microsoft.com/fwlink/?linkid=2122437 -o sql.tar.gz
tar xf sql.tar.gz
mkdir -vp /connectors/sqlserver8
mv sqljdbc_4.2/enu/jre8/sqljdbc42.jar /connectors/sqlserver8/sqljdbc42.jar

Additional info for the sqlserver driver you can find 

Microsoft Link with other versions!

Confluent page linking to these drivers!

--
Last modified: April 8, 2024