Here is how I was able to get the Teradata connections working.
First you need to load the Teradata JDBC drivers to the $SPLUNK_HOME/etc/apps/dbx/bin/lib/ directory. The files I have loaded are tdgssconfig.jar and terajdbc4.jar
Next you will need to create a new database type called "Teradata". I copied the database_types.conf to local and added the following lines:
[teradata]
displayName = Teradata
jdbcDriverClass = com.teradata.jdbc.TeraDriver
defaultPort = 6105
connectionUrlFormat = jdbc:teradata://{0}/DATABASE={2}
testQuery = SELECT 1
I was able to get some of this information from the Teradata site as well as glean some of the information from the postgresql database_type as far as formatting.
Once the new database_type is created and a restart of Splunk has been done, you can reference it with new database_type in the GUI. I went to Manage Database Connections and clicked New, provided a unique name for the database within Splunk, selected the newly created Teradata database type from the dropdown, entered in the hostname, left port blank (since it was default), got the database name and credentials from the Teradata DBA and entered them in respectively, and checked both the read-only and validate database connection boxes, and hit Save.
Splunk verified the connection was good and I am able to connect to our Teradata instance.
If there are any questions, I will do my best to answer them.
Thanks
... View more