All Apps and Add-ons

DB Connect App with Teradata

jodros
Builder

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!

1 Solution

jodros
Builder

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 solution in original post

bandit
Motivator

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.

0 Karma

jodros
Builder

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

sandipan11
Path Finder

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

0 Karma

jodros
Builder

Are you sure all services are running?

0 Karma

ilasa01
Explorer

Hi Jodros,

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

0 Karma

maidang
New Member

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

0 Karma

maidang
New Member

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.

0 Karma

maidang
New Member

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

0 Karma

gkanapathy
Splunk Employee
Splunk Employee

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.

jodros
Builder

Posting my steps for getting this to work below.

Thanks

0 Karma

maidang
New Member

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

0 Karma

ilasa01
Explorer

Hello,

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

0 Karma

jodros
Builder

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

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