Connect to Azure Database

Hello,

I am using Knime and I would like to connect to the Azure Database.

I tried the Microsoft SQL Server Connector node and encountered an error.

ERROR Microsoft SQL Server Connector 0:1 Execute failed: Failed to load ADAL4J Java library for performing ActiveDirectoryPassword authentication.

I have downloaded the ADAL4J from Microsoft including the dependencies and also the JDBC driver from Knime installation marketplace.

I have tried the following:

1. Create a plugin and include the ADAL4J downloaded in lib folder and then place it in the knime plugins directory - not working

2. I have included the ADAL4J library in knime jre PATHTOKNIME\plugins\org.knime.binary.jre.win32.x86641.8.0.202-b08\jre\lib\ext - not working

3. I have included ADAL4J library in the lib folder and made changes to the MANIFEST.MF PATHTOKNIME\plugins\org.knime.database.connectors.sqlserver.driver_6.2.2.v201908130931 - not working

Hence I would like to ask how do I connect to the Azure SQL database? Attached is the screenshot of the setting.