Connect to external database MS SQL 2017 using Azure Active Directory credentials on Pega cloud
We have a requirement to use Azure Active Directory credentials to connect to external database MS SQL 2017 from Pega Cloud. We did a POC in Java and executed on windows machine to check this and connection established successfully with below JDBC URL. To get success response we had to add 'sqljdbc_auth.dll' file to .. \Java\bin folder. Not sure how we can achieve this on Pega cloud which is hosted on Linux machines. Please throw some light if you have any similar experiences, appreciate your help.
jdbc:sqlserver://<host_name>;databaseName=ABCDB;integratedSecurity=true;domain=corp;user=********;password=*****;
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
check this Microsoft link for more details: https://docs.microsoft.com/en-us/sql/connect/jdbc/using-kerberos-integrated-authentication-to-connect-to-sql-server?view=sql-server-2017