DataSync and Auditing for SharePoint
Crow Canyon’s DataSync and Auditing Tool exports and synchs SharePoint lists, including details of field changes and version history, with SQL and other databases.
(Spacer do not delete)
Export SharePoint list data including versioning
Crow Canyon DataSync for SharePoint can export SharePoint list to any external ODBC-compliant database. It provides continuous synchronization and updating from SharePoint to the database.
Advanced Auditing for SharePoint lists and libraries
DataSync has extensive and powerful capabilities to audit modifications to any SharePoint list or library. The tool exports versioning data on all list and libraries items. This provides a complete record of all changes to items in a SharePoint list or library.
Supports Multiple Data Sources
DataSync can connect to any ODBC-compliant database, such as Microsoft SQL Server 2000-2008 R2, Oracle Database, MySQL 5.0 Database and SharePoint 2007/2010/2013.
Easy and powerful column mapping capabilities
Map data between SharePoint list columns and external database fields to ensure that information is synced accurately. Decide which fields to include or exclude from sync. Data transformation process manages data type transitions from SharePoint to database.
Works in all versions of SharePoint -- Foundation, Server, and Enterprise
SharePoint's native Auditing Logs are not available in SharePoint Foundation.
Update data automatically by schedule
DataSync uses timer jobs to run automatically in the background. Change are updated according to a schedule, thus always keeping data up-to-date.
External data governance
End users can securely access data from SharePoint list after connecting to the external data source. Users can then create, read, update and delete external data from SharePoint list.
Centralized control panel
Access and manage all DataSync jobs from one central location without entering each site or list individually to configure the settings.
Log and track errors
Administrator can track and record errors by setting a log schedule or by enabling email notification so that they will be notified whenever an error occurs during background updates.
Fully compatible with SharePoint 2010 and 2013 Foundation/Server/Enterprise.
Not yet supported on SharePoint Online
|Supports connection to Microsoft SQL Server, MySQL, Microsoft Access, Oracle, and any other ODBC-compliant database|
|All list and library types are supported|
|Ability to synchronize a subset of SharePoint list fields as per user requirements|
|All list and library types are supported Ability to synchronize a subset of SharePoint list fields as per user requirements Export data automatically with configurable timer service|
|Supports Lookup and People columns|
|Supports custom fields using field value transformation|
|List Auditing – complete version history of SharePoint list items is exported toseparate audit table in database|
|Extensive auditing capabilities -- Detailed Audit information in audit table including SharePoint Item Changed, List Field Name, Field Old Value, Field New Value, Modified By, Modified Time|
|Ability to audit a subset of fields selected for auditing|
|Centralized management of all configured list sync settings using DataSync Configuration Tool|
|Track and record errors with application logs and windows event logs|
|Easy to setup and manage list sync settings using the configuration tool|
|Manage DataSync tool settings through easy to use user interface|
|Ability to create tables in external database as per user selected fields for synchronization|
The Crow Canyon DataSync Tool is installed directly on a SharePoint server as a Windows application. It is licensed for one installation on that server. One installation can support multiple data connections (SharePoint list to Database). You do not need an installation for each server in the SharePoint Farm, though in some cases, you may want to run different instances of the application on more than one server. The database and the reporting tools are not part of the DataSync purchase.
|Server License (includes Annual Support)||$998||Buy Now|
|Annual Support Renewal||$199||Buy Now|
- Server License with Annual Support entitles you to install the application on one SharePoint server. It includes support, which means the right to contact us for support within one year from date of purchase. Bug fixes and minor upgrades are included with the Server License.
- Annual Support Renewal renews annual support for another year. This renewal is made after one year.