Replicating SharePoint Online Lists to SQL Server

We all know that accessing SharePoint data can be challenging, specifically for SharePoint Online implementations. The SharePoint SDK requires advanced software development knowledge, and SharePoint Online itself lacks the ability to provide advanced reporting. As a result, many organizations are looking for a way to replicate SharePoint data to SQL Server on a regular basis so that business analysts can build advanced reports, and to facilitate general systems integration efforts.

A Webinar showing how this is working in more details will take place on August 9, 2017 at noon (US Eastern Time). To register for this webinar, go to: 

Enzo Unified allows you to easily setup a replication job that will create a duplicate copy of your SharePoint data in SQL Server, and optionally keep changes synchronized on a regular basis (for example every minute). This allows SQL Server to keep a near-time copy of SharePoint Online data for reporting and integration purposes. The steps involved in setting up replication with Enzo Unified have been simplified to a point where anyone with basic knowledge of SQL Server can set up replication and be up and running quickly.

The diagram below shows how users (or systems) can communicate to SharePoint Online directly through Enzo Unified by issuing SQL commands. The SharePoint adapter, hosted by Enzo, allows this direct communication to take place. The Integration adapter uses the SharePoint adapter to communicate to SharePoint online, and create a replica of SharePoint lists. This architecture allows a similar implementation with other hosted systems, such as SalesForce tables for example.


For an overview of how this works and further information, visit this page and take a look at the short video:

About Herve Roggero

Herve Roggero, Microsoft Azure MVP, @hroggero, is the founder of Enzo Unified ( Herve's experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. Herve holds multiple certifications, including an MCDBA, MCSE, MCSD. He also holds a Master's degree in Business Administration from Indiana University. Herve is the co-author of "PRO SQL Azure" and “PRO SQL Server 2012 Practices” from Apress, a PluralSight author, and runs the Azure Florida Association.

Print | posted @ Thursday, July 27, 2017 10:06 AM

Comments on this entry:

Gravatar #
by 192.168.l.l administration at 8/1/2017 2:19 AM Admin Security app helps you to access the admin page of any Router modems. It is very time consuming to configure your WiFi using your mobile
Gravatar # 4liker
by fanny at 8/1/2017 7:33 AM

Not only likes you could even obtain arbitrary discuss Facebook. Just give likes as well as obtain credit history as well as use your
Gravatar # Nice post
by My Shirdi Trip at 8/3/2017 1:18 AM

Great content. These are really good tips to follow. Thanks for sharing such a amazing article with us. - shirdi flight package from bangalore, nasik flight package from bangalore
Gravatar # re: Replicating SharePoint Online Lists to SQL Server
by AsturWebs at 8/12/2017 7:23 PM

I just acquired a raspberry pi and I am very useful your article for an experiment that I am doing for the design and web page placement, greetings from Asturias
Comments have been closed on this topic.