Skip to main content

    Power BI

    Needs Votes

    Connect to Teradata using LDAP Authentication

    Vote (140) Share
    's profile image

    on 16 Oct 2015 21:52:04

    My organisation requires connections to Teradata to use LDAP authentication. This option should be available in PowerBI. It was previously requested in Power Query but is not yet delivered: https://social.technet.microsoft.com/Forums/en-US/2c3c74a8-6ef9-4c34-8dec-83d21d041e39/how-to-connect-to-teradata-with-ldap-authentication-via-powerquery?forum=powerquery

    Comments (32)
    's profile image Profile Picture

    b709d578 ff79-4dfc-853b-f1ed60896984 on 05 Jul 2020 23:05:43

    RE: Connect to Teradata using LDAP Authentication

    Please add LDAP connector to Power BI as we really need this for our systems.

    's profile image Profile Picture

    16830133 22e7-4a00-9e1a-33b306850f7d on 05 Jul 2020 23:05:29

    RE: Connect to Teradata using LDAP Authentication

    This is an urgent requirement for enterprise use. Please can Microsoft provide feedback on it?

    's profile image Profile Picture

    c5556b79 a8d4-497a-8d94-0132ce4d20f3 on 05 Jul 2020 23:02:40

    RE: Connect to Teradata using LDAP Authentication

    I am not able to connect to Active directory with LDAP authentication.

    's profile image Profile Picture

    0c25ca5e 7011-439b-9a3c-aed4609205f8 on 05 Jul 2020 23:01:58

    RE: Connect to Teradata using LDAP Authentication

    This was posted here too. https://community.powerbi.com/t5/Integrations-with-Files-and/Teradata-and-LDAP/m-p/34286/highlight/true#M3571

    Any chance MSFT would publish the source code for the Teradata .NET connector ?
    The fix is actually straight-forward: enable the 'connection string' edit field available for other connectors and one can add any applicable parameter, in this case "...;Authentication Mechanism=LDAP"

    's profile image Profile Picture

    81e8c4e9 4edd-4e16-ad22-9973adccd2e8 on 05 Jul 2020 22:59:56

    RE: Connect to Teradata using LDAP Authentication

    Yup User Experience / Adoption is being impacted

    's profile image Profile Picture

    2c99ddf9 fb09-40c6-8fd4-45070f230a18 on 05 Jul 2020 22:59:40

    RE: Connect to Teradata using LDAP Authentication

    Not having the LDAP connector is holding back our adoption of Power BI, it would be really good to have this sorted :-)

    's profile image Profile Picture

    0c25ca5e 7011-439b-9a3c-aed4609205f8 on 05 Jul 2020 22:58:59

    RE: Connect to Teradata using LDAP Authentication

    Now that custom connectors are out, can this be patched to allow LDAP ? Or can MSFT publish the code for the community to take over and make some enhancements ?
    This is really a bottleneck if you wish to use DirectQuery as the workaround, using ODBC driver, does not allow DirectQuery. A real bummer when you have a 100M dataset...

    's profile image Profile Picture

    692bcd91 e75f-463f-9d0e-7bb78ad07b2b on 05 Jul 2020 22:49:35

    RE: Connect to Teradata using LDAP Authentication

    Is there any progress ? When will be possible to connect to Teradata using .NET provider with LDAP ?

    's profile image Profile Picture

    174235da ebeb-49cf-9494-9319667a7b9a on 05 Jul 2020 22:47:23

    RE: Connect to Teradata using LDAP Authentication

    Any update on this suggestion? The ODBC workaround suggested below is not feasible for very large data sets.

    's profile image Profile Picture

    672b2f44 1f75-48d8-b15c-51b356e968f4 on 05 Jul 2020 22:40:11

    RE: Connect to Teradata using LDAP Authentication

    For Imported reports, you can use Teradata ODBC for Power BI Desktop and Gateway w/ DSN set with AuthMeth=LDAP as a 'stored/shared credential'. MS is working on LDAP support with Teradata connector (aka Teradata .NET), contact MS for status.