Splunk Enterprise

Unable to setup connectivity between splunkDB Connect with Azure Synapse DB

sphcadm
New Member

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

 

Labels (1)
0 Karma

martinborjesson
Explorer

Hi,

Have you tried installing MSAL4J

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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

---
If this reply helps you, Karma would be appreciated.
0 Karma

sphcadm
New Member

@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 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Routing Data to Different Splunk Indexes in the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...

Getting Started with AIOps: Event Correlation Basics and Alert Storm Detection in ...

Getting Started with AIOps:Event Correlation Basics and Alert Storm Detection in Splunk IT Service ...

Register to Attend BSides SPL 2022 - It's all Happening October 18!

Join like-minded individuals for technical sessions on everything Splunk!  This is a community-led and run ...