AxioWorks SQList

AxioWorks SQList is a software solution designed to export and continuously synchronize SharePoint lists and libraries to SQL Server tables. According to the vendor, this solution allows businesses of various sizes to have up-to-date SharePoint data available in Power BI, SQL Server, and other applications. AxioWorks SQList caters to a range of professions and industries, including business analysts, data analysts, IT professionals, SharePoint administrators, financial services, healthcare, manufacturing, retail, and education.

Key Features

Export and continuous synchronization: According to the vendor, AxioWorks SQList can replicate SharePoint lists and document libraries to single or multiple SQL Server databases, ensuring that the data is always up to date.

Union view: The vendor states that AxioWorks SQList automatically generates an aggregated SQL view of similar lists and libraries across a site structure, simplifying data analysis and reporting.

Support for all versions of SharePoint: AxioWorks SQList supports all versions of SharePoint from 2010 onward, including SharePoint Online in Office365, according to the vendor, ensuring compatibility with various SharePoint environments.

Quick setup: The vendor claims that AxioWorks SQList allows users to easily select the lists, libraries, and sites to export with granular control. Additionally, it can be installed anywhere without making changes to SharePoint or SQL Server.

Simple licensing: According to the vendor, only one license is needed to export data from different SharePoint servers, simplifying the licensing process for businesses with multiple SharePoint instances.

Standard SQL and HTTP connections: AxioWorks SQList connects to SharePoint and SQL instances via local network or across the Internet, allowing for flexibility in deployment options, as stated by the vendor.

Export documents and attachments: The vendor claims that AxioWorks SQList saves documents and attachments as binary columns in the SQL tables, preserving the integrity of the original files.

Scheduled or ad hoc exports: In addition to the SQList synchronization service, the vendor states that AxioWorks SQList can be run from a command line or via a task scheduler, providing flexibility in exporting data on a scheduled or ad hoc basis.

No list view threshold issues: According to the vendor, AxioWorks SQList utilizes native SharePoint change tracking capabilities, eliminating the need for column indexes or increasing the list view threshold and ensuring smooth data replication.