Azure Active Directory import to SQL 2017

  • Hi All

    In the past, I have had an employee lookup table in my warehouse by importing from an AD Server on prem.

    We now have our AD in Azure and I'm trying to find articles about connecting to the Azure AD.  Does anyone have any links on how to bring down info to a VM in Azure with a SQL 2017 Server?

    Thanks

    Cathryn

  • If third party tools are an option you can take a look at our solution which add components to SSIS to support reading/writing from/to Azure AD (as well as on-prem): https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-directory-services

    Let us know if you have any questions!

    Thank you,
    KingswaySoft

  • Thank you for the suggestion.  We'd like to avoid any 3rd party software to pull AD data.  I've always been able to just pull it directly and would like to know how to do this for the Azure AD

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply