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:
- In your macOS environment, navigate to the
/Library/directory in your system, and open theodbc.inifile with a text editor. - Navigate to the
usernameandpasswordstanzas, and adjust them to the login information for your desired Splunk platform instance.
Adjust logging levels
- Navigate to
/Library/ODBC/and open the driver configuration file (odbc.ini) in a text editor.sudo vi /Library/ODBC/odbc.ini - Change the setting for
LogLevel. For example,LogLevel=6. See the following table for information on all of the Log Levels. The best practice is6.Log Level Description 0Disables all logging. 1Logs very severe error events that might lead the driver to abort. 2Logs error events that might still allow the driver to continue running. 3Logs potentially harmful situations. 4Logs general information that describes the progress of the driver. 5Logs detailed information that is useful for debugging the driver. 6(TRACE) Logs more detailed information than log level 5. - Set the
LogPathattribute 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.Note: if specific path does not exist, or is not writable, then log files will be created in the same folder as your application binary. - Save the driver configuration file.
- 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.
- Navigate to the
/Library/ODBC/odbc.inilibrary in your system, and open it with a text editor. - Navigate to the
[Splunk ODBC]stanza, and adjust the numerical value forNumberOfRowsForMetadataExtraction = 100. The default and recommended value is100. The best practice is to adjust only after troubleshooting other options.1000is the maximum value. - Save your changes.