Splunk® ODBC Driver

Install and Use Splunk ODBC Driver

The Splunk ODBC Driver

The Splunk Open Database Connectivity (ODBC) Driver allows a Splunk platform user to connect Microsoft Excel, Tableau Desktop, and Microsoft Power BI (Microsoft Windows machines only) to their Splunk platform deployment through Open Database Connectivity. After installing and configuring the Splunk ODBC driver, you can visualize and report Splunk software data directly from Microsoft Excel, Tableau, or Microsoft Power BI.

How the Splunk ODBC Driver fits into your Splunk platform environment

Open Database Connectivity (ODBC) is a mechanism that enables ODBC-compliant apps to access data sources such as database management systems and, using the Splunk ODBC Driver, a Splunk platform server. The Splunk ODBC driver is installed on a machine in your environment, and not in your Splunk platform deployment

The following diagram illustrates how Microsoft Excel, Tableau Desktop, or Microsoft Power BI accesses your Splunk platform through the Splunk ODBC Driver. Within Excel, Tableau, or Power BI, you configure the ODBC Driver Manager, which uses the Splunk ODBC Driver to access your Splunk deployment server.

This image shows how Excel, Tableau, or Power BI accesses the Splunk platform through the Splunk ODBC Driver. Within Excel, Tableau, or Power BI, you configure the ODBC Driver Manager, which uses the Splunk ODBC Driver to access your Splunk Deployment Server.

The Splunk ODBC Driver can be used to connect and access data from Splunk Enterprise or Splunk Enterprise Cloud instances. The cloud instance must have the management port 8089 open to enable REST API access for the driver to work. For assistance with such requests, contact Splunk Support.

The main advantage of using the Splunk ODBC Driver to connect an app to your Splunk platform is the ability to use a familiar interface, such as Microsoft Excel, Tableau Desktop, or Microsoft Power BI, to perform actions that you might not be as comfortable doing with Splunk. For example, you don't have to use the Search Processing Language (SPL) to interact with a Splunk deployment server. You can instead use the Query Wizard in Excel or the interface in Tableau. The Splunk ODBC Driver then translates your actions in the app to SPL behind the scenes.

Get support and find out more information about the Splunk platform

Support for the Splunk ODBC Driver is provided by Splunk support.

If you have a support contract, file a case using the Splunk Support Portal. See Support and Services

You can also find help through the broader community:

You have a variety of options for finding more information about Splunk:

Last modified on 13 February, 2023
  Hardware and software requirements for the Splunk ODBC Driver

This documentation applies to the following versions of Splunk® ODBC Driver: 3.1.0, 3.1.1


Was this topic useful?







You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters