Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

AxioWorks | AxioWorks SQList | Export SharePoint lists to SQL Server tables

SQList

Export and continuous synchronisation of SharePoint lists and libraries to SQL Server tables.

Access up-to-date SharePoint data in Power BI, SQL Server, and your favourite apps.

Try SQList for 30 days

 

Exporting SharePoint data to SQL Server made easy with SQList

With SQList, you can effortlessly export your SharePoint data to SQL Server and gain valuable business insights. By simply directing SQList to your SharePoint site and a SQL database, it will convert your rigid SharePoint data into manageable, dynamically updated SQL Server tables. This enables you to access all of your SharePoint data in real-time, with no limits and lightning-fast performance, empowering you to make data-driven decisions with ease. 

What is AxioWorks SQList

What can I do with SQList?

Microsoft Power BI logo

Using SQList with Power BI

SQList makes it incredibly easy to generate Power BI reports on up-to-date SharePoint lists and libraries. That means you create reports more quickly and more efficiently using real-time SharePoint data created from SQL tables. 

See how SQList works with Power BI

Microsoft SSRS logo

Use SQList with SQL Server

Turn your SharePoint lists and libraries into fully synchronised SQL tables by using SQList with SQL Server. You will be able to query your SharePoint data live, without limitations, and at lightning-fast speeds. 

See how SQList works with SQL Server

Use SQList with your LOB systems

Use SQList with your LOB systems

Since SQList turns your SharePoint data into continuously syncing SQL Server tables, it’s easy to integrate live SharePoint data with systems you use every day. Make meaningful business intelligence part of your team’s regular workflow. 

See how SQList works with your systems

SQList features

  • Continuously exports SharePoint lists and document libraries:
    SQList will replicate SharePoint lists and documents libraries to single or multiple SQL Server databases.
  • Dynamically builds a normalised set of SQL tables:
    SQList dynamically builds and maintains a normalised set of SQL tables that reflect your SharePoint lists and libraries.
  • Export sub-sites automatically:
    Export lists and libraries from a SharePoint site and its sub-sites in a single replication.
  • Union view:
    SQList can automatically generate an aggregated SQL view of similar lists and libraries across a site structure.
  • Supports all versions of SQL Server from 2008 onward:
    including SQL Azure.
  • Quick setup:
    With granular selection of lists, libraries, and sites to export.
  • Can be installed anywhere:
    Does not require any changes to SharePoint or SQL Server.
  • Simple licensing:
    You only need one license to export data from different SharePoint servers.
  • Uses standard SQL and HTTP connections:
    SQList will connect via local network or across the Internet to cloud hosted SharePoint And SQL instances such as SharePoint Online and SQL Azure.
  • Supports all versions of SharePoint from 2010 onward:
    Including SharePoint Online in Office365.
  • Export documents and attachments:
    As binary columns in the SQL tables.
  • Scheduled or ad hoc exports:
    In addition to the SQList synchronisation service it is possible to run SQList from a command line or via a task scheduler.
  • No list view threshold issues:
    SQList uses native SharePoint change tracking capabilities to negates the requirement for columns indexes or to increase the list view threshold.
  • Expose your SharePoint data to virtually any BI tool:
    SQL Server Reporting Services (SSRS), Power BI, IBM Cognos, iDashboard and build powerful SharePoint  ETL solutions.

SQList pricing and licensing

SQList is available with a perpetual licence, which means there are no renewals or expiry dates to worry about. Once you’ve bought it, it’s yours to use for good.

With each license purchased, you are entitled to one installation of SQList. The price of the license includes a one-year support and upgrade plan, which can be renewed through the available plans if you wish to continue receiving support and maintenance services.

SQList Standard

  • One installation of SQList with 2 instances included.
  • Includes 1 year Preventative Maintenance.
  • Supports SharePoint Online and On-Premises 2010 onward.
  • Suports SQL Azure and SQL Server
  • Perpetual licence.

$6,162.17 (USD)

Display prices in: GBPEUR
(rates checked on 18 Mar 10:00 UTC)

SQList Enterprise

  • One installation of SQList, choose your number of instances (min. 4).
  • Includes 2 years Preventative Maintenance.
  • Supports SharePoint Online and On-Premises 2010 onward.
  • Suports SQL Azure and SQL Server
  • Perpetual licence.

P.O.A.

Display prices in: GBPEUR
(rates checked on -)

Preventative Maintenance

  • Get expert advice within one UK business day.
  • Out of hour and weekend support available upon request.
  • Escalation procedure for urgent support.
  • Includes all software updates.
  • 1 year recurring subscription(1).

$2,342.03/year (USD)

Display prices in: GBPEUR
(rates checked on 18 Mar 10:00 UTC)

About our plans and prices:

(1) Preventative Maintenance is a subscription based plan that has to be renewed annually, renewals start from the end of the previous period (retroactively if purchased after the previous period has expired).

(2) Professional Services begin with a free 30-minute initial consultation, during which we determine our ability to take on the job. Once we have assessed the requirements of the job, we will offer either a fixed price for the agreed-upon deliverables or "pay as you go" billing. If you opt for the latter, hours will be billed at the end of each day and include time spent on meetings, calls, emails, analysis and research, and custom development. Travel and accomodation costs are charged separately for in person visits.

 

Prices shown are excluding tax. Prices in currencies other than GBP are calculated using exchange rates provided by Open Currency Rates and carry a 6% conversion fee. Prices charged at checkout may be slightly different than those shown here due to intra-day exchange rate changes.

Multi-buy discounts: We offer the following discounts when multiple licences or renewals are purchased at the same time, provided they are purchased directly from us:

  • 3-5 items: 15%
  • 6-10 items: 25%
  • >10 items: please contact us 

We add 5% to the discounts above (including on a single item) for charities and educational institutions.

How does SQList work?

How AxioWorks SQList works

SQList sits between SharePoint and SQL Server, creating a continuous sync between the two. It takes unwieldy SharePoint data and turns it into easy-to-manage SQL tables.

After a simple set up process, SQList continuously exports your SharePoint lists and SharePoint document libraries to your database or multiple databases. This gives your organisation instant access to a wealth of real-time business intelligence, so you can:

  • Send valuable SharePoint data to Power BI, SSRS and other BI tools.
  • Query live SharePoint data from SQL Server.
  • Integrate SharePoint data with other systems and apps.

 

Exporting your SharePoint lists and document libraries to SQL Server could not be any easier, it only takes a few steps:

1) Access

AxioWorks SQList screenshot

Manage your lists and libraries in SharePoint and take full advandage of advanced UI, workflow, and access control that SharePoint provides.

2) Select

AxioWorks SQList screenshot

Use SQList Manager to select the lists you want to export. You can select lists across the entire site collection.

3) Sync

AxioWorks SQList screenshot

SQList exports the selected SharePoint lists as SQL tables and keeps them in sync with changes made in SharePoint.

4) Query

AxioWorks SQList screenshot

Query your up-to-date SharePoint data directly in SQL Server, without any limitations on the number of items or columns.

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*