Solved

Creating a new AD Contact when inserting contact information into a SQL server

Posted on 2011-03-17
2
696 Views
Last Modified: 2012-05-11
Hey,
We currently have a SQL server with contact information used for our billing system and such,
where we insert information about new clients and suppliers.
We've also just installed Microsoft Exchange 2010 and would like all of those contacts to be imported into AD as Contacts.

Ive bulk-imported our existing contacts into AD by using EMS.

To avoid having to add new contacts on both places every time we get a new contact, I was hoping there could be a automated process where AD gets "syncronized" with the SQL server when we create new contacts on the SQL server.

Any suggestions?
0
Comment
Question by:nebb-sbt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

by:
temores earned 500 total points
ID: 35160609
You can use identity managing software such as ILM (http://www.microsoft.com/windowsserver2003/technologies/idm/ilm.mspx) this software allows you to map between database fields to ad user fields, it can automate tasks such as user and email creationg, etc.

otherwise you can use automize the export of the db users and create a script script that reads that file and creates the missing users, this second method is not very recommended since it is more complex to create and execute but it is doable.
0
 

Author Closing Comment

by:nebb-sbt
ID: 35331284
Too general
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question