Synchronise Active Directory Users To SharePoint List

Overview

This article describes how to Synchronise Domain User details from Active Directory to a SharePoint list with Data Synchronisation Studio.

Step 1 - Connect to Active Directory

Enter your credentials and path to your Active Directory either an IP Address or path such as LDAP://OU=test,DC=litwareinc,DC=com. You can also apply a filter to the Active Directory with the LDAPFilter property.

Connect to Active Directory Data Source

Step 2 - Create SharePoint List

Use the SharePoint List Wizard to Create a SharePoint List from the Schema loaded by Data Synchronisation Studio.

Start the Wizard

Step through the Wizard

Select SharePoint Server
Select SharePoint Site
Select List Name

Step 3 - Compare A->B and Synchronise

Run an initial compare to look for the new records that need to be added to SharePoint in this case we should see all records as the SharePoint list contains no records.

Start a Synchronisation

All records will then be added to the SharePoint List.

Start a Synchronisation
Active Directory Staff List in SharePoint Populated
User Record in SharePoint

Step 4 - Schedule the Synchronisation

The next step is to Schedule the Synchronisation to run at defined interval with Windows Task Schedular and the Simego.DataSync.Run.exe command line utility.

The command line utility accepts a list of Data Synchronisation project files as input parameters for example Simego.DataSync.Run.exe project1.dsprj project2.dsprj project3.dsprj

For this scheduled task the command line might look like Simego.DataSync.Run.exe "D:\Sync\ADUsers.dsprj" we also set the Start in directory to the Data Synchronisation Studio installation path.