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.
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”
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).
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 office.simego.com where the users are members of the Simego Users group.
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.
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.
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.
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.