Connection to Azure SQL with MFA Authentication

Hi, I’m looking to connect to an Azure SQL database, with MFA authentication, using the Microsoft SQL Server Connector node and Driver Name: AzureSQL. I note the response to

Hi, So far I was connection via KNIME to a database in MS SQL Management Studio by using the “Database Connector” and configuring the node as follows: Database driver: com.microsoft.sqlsever.jdbc.SQLServerDriver Database URL: jdbc:sqlserver://xxxxxx.database.windows.net:1433;database=aaaaa;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword user name & password: myname@mycompany.com and my windows passw…

I’ve tried creating an Auth token using the Microsoft Authentication node, and then using this with the JDBC ‘accessToken’ parameter, but without any success. I’m thinking perhaps I would need to use some kind of external code to request a token, but that seems like a fairly complicated approach.

Note that I can connect to an on-prem SQL server instance without any problem, using Native Authentication. Also, I’m able to connect to the Azure SQL database without problems via Microsoft SQL Server Management Studio, using ‘Authentication: Azure Active Directory - Universal with MFA’.

I’m wondering if any new approaches may have become available since the previous discussion?