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

jcoates_splunk
Splunk Employee
Splunk Employee
0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...