Knowledge Base

How to sync information from Active Directory to SharePoint list automatically?

AD Information Sync can perform a two-way synchronization between Active Directory and SharePoint list. To ensure the information in SharePoint list and Active Directory stay up-to-date, you are enabled to automatically sync information by schedule, by minutes, hourly or on a daily basis.

In this article, we will demonstrate how to sync the information automatically by schedule.

WHAT YOU'LL GET

In theSync Schedulesection, you can specify to sync information by minutes, hourly or on a daily basis automatically.

WHAT YOU'LL NEED

The sample data we use for this case

And there are 3 users in the OU Marketing in the Active Directory as following.

Sync information from Active Directory to SharePoint list automatically by schedule

  1. Download the trial version of AD Information Sync and install it to your SharePoint server.

  2. In the Central Administration, click the WEB APPLICATIONS, then click Manage Features.

  3. When Manage Web Application Features dialog appears, set Status of AD Information Sync Timer Job as Active as following.

    This feature will enable a timer job runs in the background to check profiles and synchronize information between Active Directory and SharePoint list automatically.

    Click OK to save the settings.

  4. Navigate to the site in which the Marketing Dept Staff is located.

  5. In the upper right corner, click Settings and then click Site Settings.

  6. On the Site Settings page, click AD Information Sync settings under BoostSolutions Software section in the bottom right corner of the page.

  7. On the AD Information Sync Settings page, click Create Profile to create a new profile, specify a unique name for it.

  8. In the List section, select the SharePoint list to which we will synchronize the information from Active Directory. Select Marketing Dept Staff from the dropdown list.

  9. In the Active Directory section, specify a domain server and user credentials to connect to the domain server (Ensure the user account you specify has the appropriate permissions to access the domain server). Then click Connect. If everything goes right, it will show Connection attempt successful under the Connect button. If things went wrong, please check the user account you specified, make sure it has the permissions required.

  10. In the Filter section, select Filter by Organizational Unit option, then select Marketing in the console tree. And then specify the object type as User.

  11. In the Column Mapping section, map the AD attributes to the list columns as following.

  12. In the Sync Operations section, select the first two options as following.

  13. In the Sync Schedule section, select Sync hourly option, which means the synchronization will be automatically performed on an hourly basis.

    There are four options in the Sync Schedule section.

    Sync manually: Sync information only when the Sync Now button is clicked on the AD Information Sync Settings page.

    Sync every n minutes (1-59): automatically perform synchronizations on an “n” minutes basis. If there are lots of Active Directory information to be sync, the sync interval should be set further apart.

    Sync hourly: automatically perform synchronizations on an hourly basis.

    Sync daily: automatically sync information on a daily basis. You can set the time range, for example, between 12AM and 1PM.

  14. Keep other settings as default and click OK to save the settings for the profile.

  15. And then on the AD Information Sync Settings page, you will find that the schedule type of this profile is Hourly.

  16. Wait for the AD Information Timer Job to run successfully.

    Check the timer job status on the Timer Job Status page. (Central Administration > Monitoring > Check job status)

  17. Navigate to the Marketing Dept Staff list and you will find that those 3 users in the Active Directory have been imported to the Marketing Dept Staff list automatically as following.

  18. Add a new user Kimg James in the OU Marketing in Active Directory and wait for about one hour.

  19. And then the new user Kimg James will be added in the Marketing Dept Staff list automatically as following.

Login