topic Re: Unable to setup connectivity between splunkDB Connect with Azure Synapse DB in Splunk Enterprise

Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

sphcadm — Mon, 28 Sep 2020 14:28:32 GMT

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

Re: Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

richgalloway — Mon, 28 Sep 2020 15:03:44 GMT

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

Re: Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

sphcadm — Mon, 28 Sep 2020 15:32:51 GMT

@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

Re: Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

richgalloway — Mon, 28 Sep 2020 16:52:00 GMT

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

Re: Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

martinborjesson — Tue, 29 Sep 2020 07:59:32 GMT

Hi,

Have you tried installing MSAL4J