Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How do I specify my Teradata database connection authentication mechanism as LDAP

Hello,

I've configured the Teradata drivers according to RapidMiner documentation and verified that I am entering the correct host and port details with my IT department but I still get an error from Teradata saying my account name/account/password is incorrect. I've had the same issue with other analytic applications but have been able to specify the Authentication as LDAP and the issue was resolved. However, I am unable to find any such option in RapidMiner to tell it that the connection is LDAP. Is this possible to do?

Find more posts tagged with

AI Studio

Teradata

Databases

Authentication

SQL

LDAP SAML

Accepted answers

Marco_Boeck

Hi,

I do not have a Teradata DB at hand to test, but according to their documentation, you should be able to use LDAP by adding /LOGMECH=LDAP to the DB url. So the final URL would for example look like this:
jdbc:teradata://myserver/LOGMECH=LDAP

Source: https://downloads.teradata.com/forum/connectivity/jdbc-ldap-connection-with-encrypted-password

Regards,
Marco

ecbeam1

Solved it!

Leaving all settings in the screenshot above as-is, in the Host field I had to put "servername/LOGMECH=LDAP,username,password"

Thank you Marco_Boeck for putting me on the right track!

All comments

Marco_Boeck

ecbeam1

Hi Marco_Boeck,

I tried the proposed solution and received the following error

[Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1035] [SQLState HY000] Authentication Mechanism LDAP:1035/ not supported on this machine.

This confuses me because I'm using LDAP Authentication Mechanism for both Tableau and Spider(Python) without errors.

Below are my connection and driver details and I'm using RapidMiner 9.5.001. FYI I tried legacy database connection setup as well with the same error. Also tried leaving port blank but it threw an error until I filled it in.

Image: https://us.v-cdn.net/6030995/uploads/editor/61/dtr56y7xi7p8.jpg

Image: https://us.v-cdn.net/6030995/uploads/editor/x8/490jwpndclrv.jpg

Image: https://us.v-cdn.net/6030995/uploads/editor/3c/az4dd1ijw3k3.jpg

ecbeam1

Solved it!

Leaving all settings in the screenshot above as-is, in the Host field I had to put "servername/LOGMECH=LDAP,username,password"

Thank you Marco_Boeck for putting me on the right track!