All Apps and Add-ons

Splunk ODBC: How to set up an ODBC connection string for Power BI?

RachelS
New Member

I am trying to set up an ODBC connection via an on-premises gateway for Power BI. I can't figure out the correct connection string to use.

I have tried both:

Driver={Splunk ODBC Driver}; Server URL=mysplunkurl; Port=8089 and
Driver={Splunk ODBC Driver}; Server URL=mysplunkurl:8089

I keep getting the following error:

ODBC: ERROR [HY000] [Splunk]ODBC Not enough information
provided to establish a connection to
the data source and specified to not
prompt for more information.

I'm not sure what else to try, I've tried adding credentials to the string, that doesn't work because they are typed in separate. I've also tried just calling it "Server" in the string, instead of "Server URL". Also, no luck. Any help would be appreciated!

0 Karma

darand
New Member

I don't see a solution for this issue even though the thread is old... 

I still see this issue. Anyone get past it?

0 Karma

klojewski2
Engager

This string works in our environment:

DRIVER={Splunk ODBC Driver};PORT=8089;PWD=myPW;SERVER=myServer;UID=myLocalUser;URL=https://myServer:8089;VERIFYSERVERSSLCERTIFICATE=N;

A great tool for building this is WinSQL. A free download is available, for debugging sql connections.

To use the tool, install the Splunk ODBC driver.

In the tool, create a new connection of type Connection String. Enter "DRIVER={Splunk ODBC Driver};" in the string field, and click OK. The tool then prompts for the rest of your connection settings. When complete, the tool writes the connection string, as above.

supputur
New Member

Hi Team ,
I am also having the same issue
alt text
when we connect Power BI to ODBC drivers it's having the issue . can you please let me know how can i solve this issue

0 Karma

sprijosh
Engager

Hi. Maybe you can try
dsn={Splunk ODBC};server=url:8089

{Splunk ODBC} is your DSN name in your local machine.

0 Karma

RachelS
New Member

Thanks for the reply. I have tried that, and all the various combinations of that I can think of with no luck.

0 Karma
Get Updates on the Splunk Community!

Splunk Education - Fast Start Program!

Welcome to Splunk Education! Splunk training programs are designed to enable you to get started quickly and ...

Five Subtly Different Ways of Adding Manual Instrumentation in Java

You can find the code of this example on GitHub here. Please feel free to star the repository to keep in ...

New Splunk APM Enhancements Help Troubleshoot Your MySQL and NoSQL Databases Faster

Splunk Observability has two new enhancements to make it quicker and easier to troubleshoot slow or frequently ...