Easily keep SharePoint Online lists in sync with SQL Tables with Reality Tech’s custom list replication solution.
The solution is a robust and dynamic system that replicates SharePoint Online lists into SQL tables in real-time. It includes an automated XML mapping generator that uploads a custom map of SharePoint Online list fields to SQL table fields, and dynamically creates the corresponding SQL table. The system includes bulk load and real-time event receiver driven list replication and synchronization. The mapping includes options for handling lookup columns, and optional formatting for People and Taxonomy fields.
Great for audit purposes and for reporting from a wide range of lists across the farm, without placing a load on SharePoint Online, itself.
Unlike Search, which is typically working from a search index that is not real-time, this solution is fully real-time.
Leverage SSRS and other SQL based reporting capabilities to report against SharePoint Online lists across the enterprise.