Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
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?
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?
Tagged:
1
Best Answers
-
Marco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM EngineeringHi,
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,
Marco7 -
ecbeam1 Member Posts: 3 Contributor ISolved 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!2
Answers
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.