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.