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

ecbeam1
ecbeam1 New Altair Community Member
edited November 5 in Community Q&A
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?
Tagged:

Best Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Answer ✓
    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
    ecbeam1 New Altair Community Member
    edited January 2020 Answer ✓
    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!

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Answer ✓
    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
    ecbeam1 New Altair Community Member
    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.




  • ecbeam1
    ecbeam1 New Altair Community Member
    edited January 2020 Answer ✓
    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!

Categories