Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

[sphcadm]

Hi ,

I am trying to connecting Splunk DB Connect App with Azure Synapse SQL Pool (SQL DW) using JDBC connection string with Azure Active Directory Authentication then its throwing error related to loading ADAL4J library failed to load. Same connectivity working fine with SQL Authentication.

JDBC Connectivity string

jdbc:sqlserver://sqlserversplunktest.database.windows.net:1433;database=spsplunktest;user=xxxx;password=xxxxx;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword 

I am getting error message - "Failed to load ADAL4J Java library for performing ActiveDirectory authentication"

Can someone please assist in this case.

Regards

IY

[martinborjesson]

Hi,

Have you tried installing MSAL4J

[richgalloway]

Do you have the right driver installed in Splunk DB Connect?

[sphcadm]

@richgalloway  : i installed the latest splunk db connect version and jre 8, sqljdbcdriver 8.4.1 and adal4j-1.6.6-javadoc driver

is there any driver/apps need to update for fixing this 

[richgalloway]

It looks like you have what you need, but check https://docs.splunk.com/Documentation/DBX/3.4.0/DeployDBX/Installdatabasedrivers#Use_a_different_def... to make you've performed all the steps.