Can we connect the spark sql using token mechanism in Splunk DB Connect app?

astik — Tue, 24 Nov 2020 12:09:45 GMT

Rather than using the creds, I want to use tokens in Splunk DB Connect to get the data from Spark database.

Q1: Can we change the Auth Mech to token based, while creating the identities or connections in Splunk DB Connect app?

Q2: Can we put authentication parameters into the JDBC url itself?

The possible JDBC url for connecting to the database.

jdbc:spark://<hostname>:<port>/<database>;transportMode=<transport_mode>;ssl=1;httpPath=http;AuthMech=3;UID=token;PWD=<token>

Some reference Link for Simba driver: https://www.simba.com/products/Spark/doc/JDBC_InstallGuide/content/jdbc/options/authmech.htm

Re: Can we connect the spark sql using token mechanism in Splunk DB Connect app?

richgalloway — Tue, 24 Nov 2020 13:58:21 GMT

DB Connect currently supports only credential-based authentication. Go to https://ideas.splunk.com to suggest it support token-based authentication.

topic Re: Can we connect the spark sql using token mechanism in Splunk DB Connect app? in Splunk Dev

Can we connect the spark sql using token mechanism in Splunk DB Connect app?

Re: Can we connect the spark sql using token mechanism in Splunk DB Connect app?