ADDM Teradata DB connection solution

ADDM, Client Management, Spread sheet loads by ITSM, etc..
Post Reply
hudatolah
Site Admin
Posts: 132
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

ADDM Teradata DB connection solution

Post by hudatolah » Thu Jun 02, 2022 4:36 pm

Just wanted to share our experience with getting Teradata integration configured and there was a syntax issue with Documentation.

From: https://community.bmc.com/s/question/0 ... n-solution

download.label=Driver download page at teradata.com
download.notes=Download the latest drivers
download.url=https\://downloads.teradata.com/download/connectivity/jdbc-driver
driver.class=com.ncr.teradata.TeraDriver
driver.enabled=true
driver.info=Tera Database Beta driver
driver.name=Teradata DB Driver
driver.supports_ipv6=false
driver.url=jdbc\:teradata\://%endpoint%[/DBS_PORT\=%port%][,DATABASE\=%database%][,%LIST&extra_parameters%]
translation.database=Database Instance Name
translation.port=Database Connection Port
translation.endpoint=Database IP Address
translation.extra_parameters=Additional JDBC Parameters
validationregex.port=[0-9]+
DriverManager.setLoginTimeout=120


Make sure you get the driver version JDBC Driver 16.20.00.11 : Teradata JDBC Driver Sample Programs
and use the argument LOGMECH=LDAP in the extra_parameters as well as the other default settings like ANSI and UTF8.
Following these simple steps will allow you to connect and query the database. We've just spent 4 days trying to get this work and I hope it will save you that research time.


Documentation unfortunately shows a question mark in the driver.url which will not work.
It also missed the setLoginTimeout and port settings, although these were not crucial in making the connection work.
The Blackholesurfer. My surfboard has teeth.