topic DB Connect App with Teradata in All Apps and Add-ons

DB Connect App with Teradata

jodros — Fri, 05 Apr 2013 14:15:24 GMT

We recently started testing the DBX app. So far we have successfully connected to Microsoft SQL databases. Now we would like to test connecting to Teradata databases. Has anyone successfully connected DBX to Teradata? Would we be able to use the generic ODBC type, or would we have to set up a custom database type and import JDBC drivers?

Thanks in advance!

Re: DB Connect App with Teradata

gkanapathy — Fri, 05 Apr 2013 17:15:36 GMT

In general I would recommend using the JDBC drivers with DB connect. In any case, even if you use the ODBC bridge, you would have to install and configure a Teradata-specific ODBC driver on your machine for the JDBC-ODBC bridge to talk to, so I would not consider this any less effort.

Re: DB Connect App with Teradata

jodros — Tue, 09 Apr 2013 20:34:56 GMT

I got this working. If anyone would like to know, hit me up.

Re: DB Connect App with Teradata

ilasa01 — Mon, 22 Apr 2013 18:31:11 GMT

Hello,

Could you please share your experience with me? How did you make it working?
Thanks.
Sal

Re: DB Connect App with Teradata

maidang — Wed, 01 May 2013 05:30:09 GMT

Hi Jodros, can you please share with me steps to install Teradata connector in Splunk, I failed with ODBC and JDBC !!

Re: DB Connect App with Teradata

maidang — Wed, 01 May 2013 06:17:19 GMT

Hi Jodros, can you please share with me steps to install Teradata connector in Splunk, I failed with ODBC and JDBC !!

Re: DB Connect App with Teradata

jodros — Wed, 01 May 2013 12:59:13 GMT

Posting my steps for getting this to work below.

Thanks

Re: DB Connect App with Teradata

jodros — Mon, 28 Sep 2020 13:48:46 GMT

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

Re: DB Connect App with Teradata

maidang — Fri, 03 May 2013 09:06:21 GMT

Hi Jodros, thank you for sending through these lines, it was working but I could not logged in with LDAP as Login Mechanism, error message was:

" [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid"

I changed in database_types.conf as connectionUrlFormat = jdbc:teradata://{0}/DATABASE={2}/LOGMECH='LDAP' but not successful

When I revert back to non LDAP, I received different message which is similar when I used Teradata SQl Assistant !

[SQLState 08004] Password has expired, please use MODIFY USER statement to generate a new password.

Re: DB Connect App with Teradata

maidang — Fri, 03 May 2013 09:17:11 GMT

I could now log on by using Non LDAP password.
Thank You again Jodros, very appreciated, Mai

Re: DB Connect App with Teradata

ilasa01 — Mon, 06 May 2013 14:08:04 GMT

Hi Jodros,

Yes it works! Thank you very much for your help.
Sal

Re: DB Connect App with Teradata

sandipan11 — Wed, 01 Apr 2015 02:58:03 GMT

I did exactly same and able to view Tera Data in Database Type but I am getting "The Java Bridge server is not running ". Do I need to add any other jar. Please suggest

Re: DB Connect App with Teradata

jodros — Mon, 06 Apr 2015 21:14:33 GMT

Are you sure all services are running?

Re: DB Connect App with Teradata

bandit — Mon, 22 Feb 2016 22:01:48 GMT

Were you connecting to the Teradata Viewpoint database? From what I've seen, Viewoint is Terdata's monitoring tool. I'm also interested in being able to see some of these metrics in Splunk.