Description
SQList
SQList is a server-side integration tool that continuously replicates your SharePoint lists and libraries into Microsoft SQL Server tables. It gives you fast, reliable, and near real-time access to your SharePoint data using standard SQL, making reporting, analytics, and integration with other systems much simpler.
What SQList does
- Exports SharePoint lists and libraries to SQL Server
Turns SharePoint lists, document libraries, and their metadata into normalised SQL Server tables, including support for large lists and complex structures. - Keeps SQL data continuously in sync
Monitors changes in SharePoint and updates the corresponding SQL tables automatically, so your reports and dashboards always work with up-to-date information. - Enables powerful reporting and analytics
Use tools such as Power BI, SQL Server Reporting Services (SSRS), Excel, and other BI platforms directly against SQL tables instead of struggling with SharePoint’s native query limitations.
Key features
- Continuous export and synchronisation
Replicates SharePoint lists and document libraries to one or more SQL Server databases and keeps them in sync with changes made in SharePoint. - Dynamic table creation
Automatically creates and maintains a normalised set of SQL tables that reflect the structure of the SharePoint lists and libraries you select, including lookup relationships and attachments where configured. - Support for complex SharePoint structures
Can export data from sites and sub-sites and, where needed, generate aggregated SQL views across similar lists or libraries, simplifying cross-site reporting. - Scalable and high performance
Designed to handle large SharePoint environments and high data volumes, removing common issues such as list view thresholds and performance bottlenecks when querying directly against SharePoint. - Flexible deployment
SQList can be installed on any suitable Windows server or VM with network access to your SharePoint environment and SQL Server, including support for on-premises SharePoint, SharePoint Online, and SQL Server or SQL Azure (subject to platform compatibility).
How SQList works
- Service and management application
SQList consists of a Windows service that performs the synchronisation and a management application used to configure replications, select lists and libraries, and monitor status. - Standard connectivity
Connects to SharePoint using standard web protocols (HTTP/HTTPS) and to SQL Server using standard database connections, so no changes are required to SharePoint or SQL Server beyond basic connectivity and permissions. - Near real-time updates
Once configured, SQList continually tracks changes in SharePoint and applies them to the corresponding SQL tables, ensuring that your SQL-based tools are always working with current data.
Business benefits
- Faster reporting
Querying SQL Server instead of SharePoint gives you significantly improved performance and freedom to build complex queries, joins, and aggregations without native SharePoint limits. - Data-driven decisions
With reliable, up-to-date SharePoint data available in SQL, teams can build dashboards and reports that support informed, timely decision-making. - Easy integration with other systems
Because your SharePoint data is available as standard SQL tables, it can be integrated more easily with line-of-business systems, data warehouses, and custom applications.
Security and control
- Your infrastructure, your data
SQList runs within your own infrastructure or chosen hosting environment. You control where it is installed, how it connects, and who has access to the SQL data. - No changes required to SharePoint or SQL Server
Uses standard interfaces and protocols, so you do not need to modify your SharePoint farms, site collections, or SQL Server configuration beyond granting the necessary permissions and network access.
Licensing and trial
- Simple licensing model
SQList is licensed at server level (exact terms depend on the chosen edition and agreement), allowing you to configure multiple replications from your SharePoint environments to SQL Server under a single installation. - Free trial available
A time-limited, fully functional trial is available so you can evaluate SQList with your own SharePoint and SQL Server environments before committing to a licence.
SQList is ideal for organisations that rely on SharePoint but need the performance, flexibility, and integration options that only SQL Server and standard BI tools can provide.
