populate active directory with SQl database users

All replies

• 

  

  0

  Sign in to vote

  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

  Tuesday, August 18, 2015 6:27 AM
• 

  

  0

  Sign in to vote

  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.

  Tuesday, August 18, 2015 8:48 AM
• 

  

  0

  Sign in to vote

  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

  Tuesday, August 18, 2015 8:53 AM
• 

  

  1

  Sign in to vote

  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.

  ---

  Mahdi Tehrani   |     |   www.mahditehrani.ir
  Please click on Propose As Answer or to mark this post as and helpful for other people.
  This posting is provided AS-IS with no warranties, and confers no rights.

  • How to query members of 'Local Administrators' group in all computers?

  • Proposed as answer by Ethan HuaMicrosoft contingent staff Wednesday, August 19, 2015 7:41 AM

  Tuesday, August 18, 2015 9:46 AM
• 

  

  0

  Sign in to vote

  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,
  

  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
  

  • Edited by Ethan HuaMicrosoft contingent staff Wednesday, August 19, 2015 7:41 AM
  • Proposed as answer by Ethan HuaMicrosoft contingent staff Monday, September 7, 2015 9:04 AM
  • Marked as answer by CMARIF Monday, September 7, 2015 10:42 AM

  Wednesday, August 19, 2015 7:40 AM