HI Sebastien ,

Thanks for your reply,  I need to populate the active directory from the sql server . is it any way you can help me with ?

Thanks,

Mohammad Arif.

Hi Mohammad,

I don't know SQL. However, can you check this link to see if it helps?

https://msdn.microsoft.com/en-us/library/azure/dn441161.aspx

-Umesh.S.K

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.

Thanks,

Mohammad Arif

One solution can be using FIM and create two management agents. One for your AD and another for your SQL. On the other hand, you can create a script to export users from SQL and save it to a CSV or something, then feed that CSV to PowerShell to create users.

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.

Thanks,

Mohammad Arif

Hello,

You can synchronize your Azure AD to your local AD. You can look here : http://blogs.technet.com/b/canitpro/archive/2014/05/14/step-by-step-syncing-on-premise-ad-with-azure-active-directory.aspx

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:
 
https://gallery.technet.microsoft.com/scriptcenter/ed20b349-9758-4c70-adc0-19c5acfcae45
 
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:
 
http://social.technet.microsoft.com/Forums/en-US/ITCG/threads
 
Hope this helps.
 

Regards,

Eth