Splunk DB Connect: Are drivers for Teradata unsupported?

[aniello_cerrato]

Hi,

I have to create in Splunk DB Connect a new database connection for teradata.

I have recover the drivers TeraJDBC 14.00.00.44 and insert in /bin/lib of splunk db app but when I verify the drivers it says unsupported and when I try to create the connection I have the below error:

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: [Teradata JDBC Driver] [TeraJDBC 14.00.00.44] [Error 165] [SQLState HY000] isValid: function not supported in this version 

[ehughes100]

I could not get the drivers to show they were installed when going to the Drivers tab of the DB Connect Settings page when following this instructions here - http://docs.splunk.com/Documentation/DBX/3.0.1/DeployDBX/Installdatabasedrivers#Supported_databases

It stated - From inside the TeraJDBC_... directory, copy or move the two .JAR files (terajdbc4.jar to the $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers and tdgssconfig.jar to the $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/terajdbc4-libs) directory.

I was able to get the drivers to show up as installed and it listed the driver version when I put the files in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/lib folder instead. When I tried to connect to a Teradata instance I received an error - "Could not initialize class com.teradata.tdgss.jtdgss.TdgssManager". Restarting Splunk made the error go away and allowed me to connect to and pull data from Teradata

[burwell]

So, per the documentation jcoates listed above, you need to be at version 15.00.00.07 of the Teradata JDBC driver.

[jcoates_splunk]

http://docs.splunk.com/Documentation/DBX/3.0.1/DeployDBX/Installdatabasedrivers#Supported_databases