Splunk® ODBC Driver

Install and Use Splunk ODBC Driver

Enter or change configuration information

Enter or change configuration information in the Splunk ODBC driver.

Change login information

To change the Splunk server login information for the Splunk Open Database Connectivity (ODBC) Driver, follow these steps:

  1. In your macOS environment, navigate to the /Library/ directory in your system, and open the odbc.ini file with a text editor.
  2. Navigate to the username and password stanzas, and adjust them to the login information for your desired Splunk platform instance.

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 macOS operating system.

  1. Navigate to the /Library/ODBC/odbc.ini library in your system, and open it with a text editor.
  2. Navigate to the [Splunk ODBC] stanza, and adjust the numerical value for NumberOfRowsForMetadataExtraction = 100. 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 of the Splunk ODBC driver on macOS   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