populate active directory with SQl database users RRS feed

  • Question

  • Hi,

    I have a SQL table which consists of user data ,I need to populate the active directory with that user data . Active Directory is in azure ,and from that I need to authenticate to office 365 with same users. Could you please  tell me how can i achieve this.


    Mohammad Arif

    Tuesday, August 18, 2015 5:57 AM


  • The general process should be 1) export user data from SQL server with some script, 2) import it to Active Directory.
    Active Directory supports to import bulk users from a .csv file. Here is script on how to Import users in Active Directory from CSV file, please take a look and see if it helps:
    I'm not sure about your SQL database, it might have some differences in attribute mappings between the SQL table and Active Directory. You might need an additional script to make some modifications to the .csv file exported from your SQL server.
    For further assistance/any questions about the script, I'd suggest post in the script forum:
    Hope this helps.


    Ethan Hua

    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Wednesday, August 19, 2015 7:40 AM

All replies