Splunk® ODBC Driver

Install and Use Splunk ODBC Driver

Acrobat logo Download manual as PDF

This documentation does not apply to the most recent version of ODBC. Click here for the latest version.
Acrobat logo Download topic as PDF

Frequently Asked Questions (FAQs)

Is my Splunk password encrypted?

Yes, the Splunk ODBC Driver encrypts your Splunk password using Windows data protection APIs. You cannot turn off this encryption.

Can I use the Splunk ODBC Driver if my network requires a proxy?

Yes, you can use the Splunk ODBC Driver on networks that require proxy servers. To enable this scenario, add an environment variable to the computer that runs the Splunk ODBC Driver.

For information about configuring the Splunk ODBC Driver on a network with proxy servers, see "Proxy Server Configuration".

Does the Splunk ODBC Driver support the new data models in Splunk Enterprise 6?

Yes, the Splunk ODBC Driver supports data models in Splunk Enterprise 6. You can create a report that leverages data models.

To access a data model using the Splunk ODBC Driver, save any "pivot" results as a "report." This ensures that Splunk will use the data model when it accesses that new table in Excel or Tableau.

What keywords or portions of keywords can't be used as field names?

Some SQL keywords or portions of keywords are reserved. You cannot use them as field names. They include the following:

  • avg
  • hour
  • key
  • max
  • min
  • second

My report has a space in its name. Is it compatible with the Splunk ODBC Driver?

Do not use a report (saved search in Splunk Enterprise 5) with a space in its name with the Splunk ODBC Driver. It might result in an error. Use the Splunk Enterprise rename function to replace any spaces in report names with underscores.

How do I ensure secure communication between the Splunk ODBC Driver and my Splunk Enterprise instance over a firewall?

The Splunk ODBC Driver checks your Splunk Enterprise server's SSL certificate. To enforce this option:

  1. Follow the instructions in the "Configuration" section.
  2. In the Splunk ODBC Connection Options window, select the Verify Server SSL Certificate checkbox.

Is Preview Now supported in Excel?

When setting up a query with the Query Wizard in Microsoft Excel, you can preview your results. For example the Choose Columns window includes a Preview Now button. The Splunk ODBC Driver does not support previewing results.

Last modified on 24 September, 2014
Use the driver with Tableau

This documentation applies to the following versions of Splunk® ODBC Driver: 1.0, 1.0.1

Was this documentation topic helpful?

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