Introduction

Crow Canyon DataSync Tool works to continuously sync SharePoint list data and audit information to any ODBC-compliant database.

Crow Canyon DataSync Tool for SharePoint is a server-side tool that synchronizes any SharePoint list to any ODBC-compliant database. Users can then use standard reporting tools of their choice (e.g. Crystal Reports, SQL Server Reporting Services, etc.)  to run comprehensive reports on the exported SharePoint list data. Most importantly, the DataSync Tool provides access to the Version History of SharePoint list items for audit and historical reports. Audit information includes details such as what SharePoint items were changed, which fields were modified, what the old and new values are, who made the change,  and when it was made.

The tool is deployed to the SharePoint application server. Through a few simple steps, users can quickly configure data synchronization from a SharePoint list to an external database. The tool provides support to configure any number of SharePoint lists. Users can start and stop the sync at any time for one or more lists. Users can specify the length of time between data syncs as per their reporting requirements.