{"id":6469,"date":"2014-01-06T17:43:57","date_gmt":"2014-01-06T09:43:57","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=6469"},"modified":"2023-07-31T11:38:20","modified_gmt":"2023-07-31T03:38:20","slug":"consistent-data-between-sharepoint-ad","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/consistent-data-between-sharepoint-ad\/","title":{"rendered":"How to keep user information consistent between SharePoint and Active Directory"},"content":{"rendered":"

As we know, a User is created in the User Information List when a user is granted access to a site in SharePoint. But this list is hidden and we are not able to use the data directly. As well there may not be a lot of metadata in this list. Sometimes you may create multiple customer lists to store user information. How do you keep user data from multiple systems (Active directory and SharePoint) consistent? The obvious answer would be for IT administrators to manually update information between systems. But it would be hard, maybe even impossible if there is a lot of information, to keep data up-to-date and consistent. One easy method to ensuring that data is up-to-date and consistent is to use BoostSolutions Active Directory Info Sync and Data Connector.<\/p>\n

I will demonstrate a scenario to clarify how to make this method work.<\/p>\n

User Data<\/b><\/h2>\n

Data in Active Directory<\/b>: User (Employee ID, Job Title, Gender, Department, Email, Mobile phone, Employee hiring\/start date<\/p>\n

Data in SharePoint list: <\/b><\/p>\n

Employee Base Information in Administrative site: Employee ID (Key), Name, Job Title, Gender, Department, E-Mail, Mobile phone, Employee hiring\/start date<\/p>\n

Interested Candidates in HR site: Name, Birthday, Interview date, Interview Status, Institution(s) Graduated from, Major, Degree(s)<\/p>\n

Employee Record in HR site: Employee ID(Key), Name, Job Title, Department, on board date, Institution(s) Graduate from, Major, Degree(s), Expiration date of Contract<\/p>\n

 <\/p>\n

Permissions in SharePoint List:<\/b><\/p>\n

Employee Basic information is read-only for all Employees<\/p>\n

Interested Candidates, Employee Record in HR site; contribute-only for HR employee<\/p>\n

 <\/p>\n

The process of hiring a new employee<\/b><\/h2>\n

\"image1\"<\/p>\n

 <\/p>\n

Transferring User Data<\/b><\/h2>\n

Let us focus on how to keep user information consistent.<\/span><\/p>\n

The image below highlights how user data is transferred using BoostSolutions Active Directory Info Sync and Data Connector.<\/span><\/p>\n

\"image2\"<\/p>\n

You need to:<\/p>\n