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!
Here is how I was able to get the Teradata connections working.
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.
If there are any questions, I will do my best to answer them.
Thanks
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.
Here is how I was able to get the Teradata connections working.
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.
If there are any questions, I will do my best to answer them.
Thanks
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
Are you sure all services are running?
Hi Jodros,
Yes it works! Thank you very much for your help.
Sal
I could now log on by using Non LDAP password.
Thank You again Jodros, very appreciated, Mai
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.
Hi Jodros, can you please share with me steps to install Teradata connector in Splunk, I failed with ODBC and JDBC !!
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.
Posting my steps for getting this to work below.
Thanks
Hi Jodros, can you please share with me steps to install Teradata connector in Splunk, I failed with ODBC and JDBC !!
Hello,
Could you please share your experience with me? How did you make it working?
Thanks.
Sal
I got this working. If anyone would like to know, hit me up.