View All Blog Posts

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.

Example solutions you can build with Data Synchronisation Studio and the Active Directory Connector

  • SharePoint Contact List from Active Directory
  • SharePoint Employee Directory from Active Directory
  • ERP Database to Active Directory
  • Self Service solutions to synchronise updates from SharePoint to Active Directory

To learn more about our Data Synchronisation Studio Active Directory Connector please see Active Directory. We also have an new and improved connector for Active Directory please see Active Directory V2 Connector for more information.

In this Guide we show you how to sync your Active Directory Users to a SharePoint Contact List.

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.


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.


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 where the users are members of the Simego Users group.

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


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


Locate the List you created earlier from the SharePoint Explorer.


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.


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


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.


Click Start to actually Synchronise the Data with SharePoint.


After a few Seconds the sync process will complete.


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


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

| |