Description
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, near real-time access to your SharePoint data using standard SQL. As a result, reporting, analytics, and integration with other systems become much simpler.
What SQList does
- Exports SharePoint lists and libraries to SQL Server
It turns SharePoint lists, document libraries, and their metadata into normalised SQL Server tables. This includes support for large lists and complex structures. - Keeps SQL data continuously in sync
It monitors changes in SharePoint and updates the corresponding SQL tables automatically. This means your reports and dashboards always work with up-to-date information. - Enables powerful reporting and analytics
You can 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
SQList 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
It automatically creates and maintains a normalised set of SQL tables that reflects the structure of the SharePoint lists and libraries you select. This can include lookup relationships and attachments where configured. - Support for complex SharePoint structures
SQList can export data from sites and sub-sites. Where needed, it generates aggregated SQL views across similar lists or libraries, which simplifies cross-site reporting. - Scalable and high performance
It is designed to handle large SharePoint environments and high data volumes. This removes common issues such as list view thresholds and performance bottlenecks when you query directly against SharePoint. - Flexible deployment
You can install SQList on any suitable Windows server or VM with network access to your SharePoint environment and SQL Server. It supports 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
It connects to SharePoint using standard web protocols (HTTP/HTTPS) and to SQL Server using standard database connections. Therefore, 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. This ensures that your SQL-based tools always work with current data.
Business benefits
- Faster reporting
Querying SQL Server instead of SharePoint gives you significantly improved performance. It also gives you 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 and 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
It uses standard interfaces and protocols, so you do not need to modify your SharePoint farms, site collections, or SQL Server configuration, apart from granting the necessary permissions and network access.
Licensing and trial
- Simple licensing model
SQList is licensed at server level. The exact terms depend on the chosen edition and agreement, but you can 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. This allows you to evaluate SQList with your own SharePoint and SQL Server environments before you commit 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.