All Apps and Add-ons

Splunk DB Connect: Are drivers for Teradata unsupported?

aniello_cerrato
Path Finder

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 
0 Karma

ehughes100
Explorer

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
SplunkTrust
SplunkTrust

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

0 Karma
Get Updates on the Splunk Community!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...