SharePoint DataSync Tool


Archive, Audit, or Migrate SharePoint data

Use with SharePoint on-premises or Microsoft Office 365

export data from sharepoint list to sql server

Export and Sync SharePoint Lists

…including details of field changes and version history, to SQL and other databases!

  • Synchronize SharePoint lists with just about any database.
  • Export the version history of list items for auditing and regulatory purposes.
  • Include important information: what items were changed, which fields were modified, what the old and new values are, who made the change, when it was made. 
  • Use Crystal Reports, SQL Server Reporting Services, or other tools to generate comprehensive, detailed reports and audits on the SharePoint data.
SharePoint’s native Auditing Logs do not include this information!

DataSync Features for Efficient List Transfers


SharePoint Data Export

Export SharePoint List Data

Our SharePoint DataSync Tool can export SharePoint lists to any external ODBC-compliant database. It provides continuous synchronization and updating from SharePoint to the database. Export data automatically with configurable timer service.


SharePoint Data Export Audit

Advanced Auditing

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. Audit a subset of fields selected.


SharePoint list Export

Multiple Data Sources

DataSync can connect to any ODBC-compliant database, such as Microsoft SQL Server, Oracle Database, MySQL Database and SharePoint 2010/2013/2016/2019/SE.




export sharepoint lists to sql

Column Mapping

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.


SharePoint list data export

Version Compatible

Works in all versions of SharePoint — Foundation, Server, and Enterprise as well as Office 365.




export sharepoint lists

Scheduled Updates

Easy to setup and manage list sync settings using the configuration tool. DataSync uses timer jobs to run automatically in the background. Changes are updated according to a schedule, thus always keeping data up-to-date.



export sharepoint list data to excel

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.




export sharepoint data to mysql

Centralized Control Panel

Centralized management of all configured list sync settings using DataSync Configuration Tool. Access and manage all DataSync jobs from one central location without entering each site or list individually to configure the settings.



export sharepoint data

Log & Track Hours

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. Track and record errors with application logs and windows event logs.

SharePoint DataSync Tool

$799/year
Subscription
Licensed for installation on one Windows Server
Supports multiple data connections
Subscription includes support & upgrades
*Database and reporting tools are not included in the DataSync purchase. 

The SharePoint DataSync Tool is installed on a Windows server as a Windows application. For SharePoint on-premises environments, the Tool is installed on a Windows Server running SharePoint. For SharePoint Online (Office 365) environments, the Tool is installed on a Windows Server, but that server does not need to have SharePoint on it. The Tool is licensed for one installation on the Windows server. One installation can support multiple data connections (SharePoint list to Database).