Splunk® ODBC Driver

Install and Use Splunk ODBC Driver

Enter or change configuration information

The Splunk Open Database Connectivity (ODBC) Driver encrypts your Splunk platform password using Windows data protection APIs. You cannot turn off this encryption.

To enter or change configuration information, perform the following steps:

  1. In your Microsoft Windows environment, navigate to the Start screen (or on the Start menu), type odbc.

  2. Click whichever of the following items that appears. If more than one appears, click the one that corresponds to the ODBC Driver architecture you installed:
    • Data sources (ODBC)
    • ODBC Data Sources (32bit)
    • ODBC Data Sources (64bit)
  3. In the ODBC Data Source Administrator window, click the System DSN tab.

  4. Click Splunk ODBC in the list of system data sources.

  5. Click Configure. The Splunk ODBC Connection Options window appears.

    4 odbc options win.jpg
  6. In this window, you can change any of the options described in the Install the Splunk ODBC Driver topic in this manual, plus the following additional option:
    • Verify Server SSL Certificate: This checkbox instructs the Splunk ODBC Driver to ensure the integrity of the Splunk platform server's SSL certificate. Select this checkbox if your server is across a firewall from the computer on which you're running the Splunk ODBC Driver. Follow the instructions in configure the TLS certificate topic in this manual.

Adjust logging levels

  1. Navigate to \Library\ODBC\ and open the driver configuration file (odbc.ini) in a text editor.
    sudo vi \Library\ODBC\odbc.ini
  2. Change the setting for LogLevel. For example, LogLevel=6. See the following table for information on all of the Log Levels. The best practice is 6.
    Log Level Description
    0 Disables all logging.
    1 Logs very severe error events that might lead the driver to abort.
    2 Logs error events that might still allow the driver to continue running.
    3 Logs potentially harmful situations.
    4 Logs general information that describes the progress of the driver.
    5 Logs detailed information that is useful for debugging the driver.
    6 (TRACE) Logs more detailed information than log level 5.
  3. Set the LogPath attribute to the full path to the folder where you want to save log files. This directory must exist already, and be writable, including being writable by other users if the application using the driver runs as a specific user. For example, LogPath=\tmp.

    if specific path does not exist, or is not writable, then log files will be created in the same folder as your application binary.

  4. Save the driver configuration file.
  5. Restart the application you are using the driver with. Configuration changes will not be picked up by the application until it reloads the driver. The following log file will be created: splunk_driver.log

Configure number of scanned rows in the Splunk ODBC driver

Configure number of scanned rows in the Splunk ODBC driver on a Microsoft Windows operating system.

  1. Navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Splunk ODBC\NumberOfRowsForMetadataExtraction registry key in your system, and open it with a text editor.
  2. Navigate to the REG_SZ text string, and adjust the numerical value. The default and recommended value is 100. The best practice is to adjust only after troubleshooting other options. 1000 is the maximum value.
  3. Save your changes.
Last modified on 13 February, 2023
Verify installation   Configure the proxy server

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