Synchronise Active Directory Users with SharePoint List

17 October 2013

Quick guide that shows how you can use Data Synchronisation Studio with your Active Directory and SharePoint to create a Staff Directory or similar from Data Stored within your Active Directory.

First step is to create a “Contacts” List in the SharePoint Site you want to use to hold the data from Active Directory. Here we're using SharePoint 2016 but you can use SharePoint 2007, 2010 and 2013.

SharePoint

Next Step is to create a Column to store the Active Directory Identifier (DSID in Data Sync). Data Sync includes a Wizard that allows you to create a Read-only Column on your SharePoint list.

Go to the Tools menu and Select “Create SharePoint Column

Create SharePoint Column)

This starts the Column Wizard. Enter your SharePoint Site URL, choose the list you wish to add the column to from the dropdown and then type in a name for the new column. In this example we will use the list we created earlier and we will create the column DSID, type System.String, Hidden (DSID is a special column type known to Data Sync).

Column Wizard

Click finish and Data Sync will add the DSID column to the SharePoint List.

Next Step is to connect Data Source A in Data Sync to your Active Directory, Click “Connect Data Source” on Data Source A.

Connect

Then Locate the Active Directory Users Provider and enter the LDAP path to your Directory, this could be something like LDAP://dc=corp, dc=litware, dc=com or a server name or IP address like LDAP://yourdomaincontroller If You want to also filter the returned users to a specific Group you can also define the Group filter in the LDAPFilter property.

For example the filter below returns objects of Type User from OU office.simego.com where the users are members of the Simego Users group.

&(objectClass=user)(memberOf=CN=Simego Users,CN=Users,DC=office,DC=simego,DC=com))

Connect

Next Step connect Data Source B to your SharePoint List (Use the SharePoint (Client API) Provider with SharePoint 2010 - 2016)

Connect

Locate the List you created earlier from the SharePoint Explorer.

List

Pressing OK, brings up Data Sync Automatic Mapping feature where Data Sync will automatically apply a pre-defied schema map. Select the AD to SharePoint Contact List (DSID) Map.

Mapping Rules

This then creates a pre-configured schema map ready to go.

Schema

Now click Compare A->B to load the data from AD and SharePoint and work out the changes required to make both sides equal.

Compare

Data Sync then displays the results where you can view the data before it is copied to SharePoint.

Compare Results

Click Synchronise on the results window to open the synchronise data window.

Synchronise

Click Start to actually Synchronise the Data with SharePoint.

Sync

After a few Seconds the sync process will complete.

Sync

Now if you switch to SharePoint you will see your data created in your list.

SharePoint

Now if you want to run this on a Schedule via Windows Task Scheduler you should stave the project and run the “Create Scheduled Task” option from the Tools Menu.

Create Schedules Task

Select the schedule Click OK and enter your Password. Windows will then Run your project based on the Schedule you selected to keep your Data between AD and SharePoint up to date.

Create Scheduled Task

| |