Connection to Azure SQL with MFA Authentication

Hello Andrew,
you can use a new function in the JDBC driver to get the token and do the authentication. To do so you need to register the latest driver and some additional jars which is all explained in this workflow:

Once the driver is registered you can use the component from the workflow to establish the connection.

To make this easier we are planning to add a dynamic input port to the Microsoft SQL Server Connector node to pass in the token from the the Microsoft Authentication node.
Bye
Tobias

3 Likes