Revision history [back]

It is possible to run an Azure SQL Server query using the JDBC connector within a Vert.x-based Kafka consumer application.

You can use any JDBC-compatible driver to connect to an Azure SQL Server instance using the JDBC connector. Alternatively, you could use a third-party library such as Azure SDK for Java or the Azure Data Lake Storage connector for Kafka integration.

Once you have established a connection, you can execute queries on the Azure SQL Server and receive the results in your Kafka consumer application. You can use the Vert.x JDBC client to execute the query and process the result set.