Trying to connect SQL server with Azure MFA Authentication, It works fine using metadata connection. However, when the metadata connection is added to a Job, the Job fails with below error:
Failed to load MSAL4J Java library for performing ActiveDirectoryInteractive authentication.
com.microsoft.sqlserver.jdbc.SQLServerException: Failed to load MSAL4J Java library for performing ActiveDirectoryInteractive authentication.
Upon checking the modules view in Talend Studio, the MSAL4J jar is already installed.
Resolution
In the Advanced settings of the tDBConnection for the SQL Server connection, enable the option labeled "Authenticate using Azure Active Directory", and subsequently attempt to run the Job once more. Upon enabling this option, the msal4j jar will be automatically packaged during the Job build process.
Environment
