Azure SQL DB Instance From BW6 JDBC Connection

[ajay kamath]

Hi TIBCO Team,

 

We are trying to connect to Azure SQL DB Instance From BW6 JDBC Connection using below URL and the same is failing to connect. basically it is unable to recognize Azure Active Directory Authentication. SQLJDBC4.jar for BW6 installation uses SQLJDBC4.jar . Please help if anyone has come across this issue and has resolved the same

URL:

jdbc:sqlserver://vaim0-dbt-01.e9a7413eb0a9.database.windows.net:1433;databaseName=ODS_CORE;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.e9a7413eb0a9.database.windows.net;loginTimeout=30;Authentication=ActiveDirectoryIntegrated