Azure DB connection string template for JDBC connection
Hi,
We switched to Azure and ReadyAPI Database connection string is changed(for JCDB steps). Doesn't need user and password. There are additional properties, We should able to connect to Azure DB without user. However, when I use "com.microsoft.sqlserver.jdbc.SQLServerDriver" as driver.it force me fill out user.
Driver is MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection string structure with properties : jdbc:sqlserver://<HOSTname>;database=<DBName>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;Authentication=ActiveDirectoryIntegrated
As you see there is no User in String.
Do I need to add new Driver template or Should I create User ? Also Do I need to change proxy?
Which Driver is relevant for Azure and Where can I download.