Yes, it's best practice to set index time parameters even when the data is collected via dbconnect
For example, in Splunk addon for Mcafee , which collect epo via dbconnect , you'll find
SHOULD_LINEMERGE=false
LINE_BREAKER=([\r\n]+)\d{4}-\d{2}-\d{2}\s+\d{2}:\d{2}:\d{2}\s+
MAX_TIMESTAMP_LOOKAHEAD=21
TIME_FORMAT=%Y-%m-%d %H:%M:%S
TZ=UTC
Failure to set TZ for example will make events appear in wrong timezone
Setting the parameters will also improve index time performance.
You can also set TRUNCATE to a higher value than default depending on your data and NO_BINARY_CHECK = true
you should set KVMODE =auto (which is search time config) as data written by dbconnect is in key = value format
... View more