Unable to connect LDAP from Azure synapse

Pravin007 1 Reputation point
2022-11-11T10:52:41.687+00:00

Hi Team,

We want to fetch data from LDAP-AD on prem server and store it into ADLS using Azure synapse. For that we have tried the connection using Synapse HTTP REST ODBC linked services but I unable to connect it.

Can you please let us know how we can connect to LDAP-AD from Azure Synapse?

Thanks in advance!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 29,266 Reputation points Microsoft Employee
    2022-11-11T21:48:31.317+00:00

    Hello @Pravin007 ,

    Welcome to the MS Q&A platform.
     
    A similar thread has been discussed here.

    Per the thread, you can use Office 365 connector to pull data from the Graph API using copy activity.

    (or) if you have an existing PowerShell script to pull the LDAP data, then you run the PowerShell script using the Custom activity to pull the LDAP data.

    Here is the documentation about how to use Custom activity.
     
    I hope this helps. Please let me know if you have any further questions.