AxioWorks SQList

AxioWorks SQList allows developers to expose SharePoint content as normalised SQL Server database tables.

This unique Windows service enables the integration of SharePoint with existing systems like SQL Server Reporting Services (SSRS), or can hugely accelerate the process of developing rich web based applications leveraging the advanced UI, workflow, and access control that SharePoint provides.

SQList Features

  • Exports all the lists and libraries in a SharePoint site as a set of normalised tables to any SQL Server database;
  • Can export lists and libraries from single sites or an entire site collection;
  • Selective replication: precisely control the lists, libraries, and sites you wish to replicate;
  • Parallel list sychronisation: replicate multiple sites and lists in parallel for enchanced performance;
  • Continuously updates the target SQL tables (data and structure) as your SharePoint site changes, every few seconds, or on a schedule you define;
  • Builds an indexed SQL table for each list or library on the fly;
  • Exports attachments and documents, as well as list data, and stores them as binary objects in the target SQL database;
  • If approval is enabled in your SharePoint list or library, SQList can export approved items only.

Flexible and Easily Manageable

  • Runs as a lightweight Windows service that can be hosted on almost any Windows server or desktop PC;
  • Standard and Professional editions allow you to configure multiple source sites and multiple target databases;
  • Can co-exist on servers running SharePoint or SQL Server;
  • Supports Windows and Form authentication and SharePoint OnLine, and SQL Server on premise and SQL Azure;
  • Comes with SQList Manager, for quick entry of site and SQL database connection details, service control, and monitoring;

Integrate your Existing Applications with SharePoint

  • Consume live SharePoint content using familiar T-SQL queries in a clean relational format;
  • Makes SharePoint content access much more development friendly; unlike using SharePoint web services, or accessing SharePoint content databases directly;
  • Easily share content from your SharePoint Intranet with your website or your other web applications;
  • Use SQList to replicate your SharePoint content to multiple SQL databases even over the Internet;
  • Use SQL Server Reporting Services (SSRS) to report on live SharePoint content;

Accelerate Application Development with SharePoint

  • Leverage the low cost, rapid assembly and advanced UI, workflow, document management, collaboration features and access control of SharePoint to manage content, data, and documents for your application:
  • Use SharePoint for anything from an application configuration interface for your web application, to a data entry front-end for your SQL Server Reporting Services solution; the possibilities are endless;

Feature history

Version 4.2

  • Support for ADFS: support for SSO (Single Sign-On) authentication with Office 365 using ADFS versions 2 or 3.
  • Enhancements configuration wizard: added checks and informational messages to the SQList Manager configuration wizard to make setting up replications even easier.
  • Full details in our support section

Version 4.1

  • Support for multiple cultures: support for multiple cultures for both the SharePoint sites and the SQL Server database.
  • Enhanced handling of duplicate columns: new feature to make SQList automatically handle duplicate column names in the SQL tables, when the "clean column name" option is enabled.
  • Changes to the event viewer: a new indicator that shows the current status of the SQList Service and changes to the event viewer
  • Full details in our support section

Version 4.0

  • Export sub-sites automatically: you can now export lists and libraries from a SharePoint site and it's sub-sites in a single replication.
  • Automatically export similar lists: SQList 4.0 will automatically replicate lists and libraries with the same name across a site collection to normalised SQL Server tables.
  • Use of SharePoint native change tracking: we have changed the way SQList detects changed items; this improves performance, reduces load on the SharePoint server and handles threshold limitations without the need to create indexes or change the list view threshold.
  • Union view: SQList can now automatically generate an aggregated SQL view of similar lists and libraries.
  • A brand new UI: we have all but rewritten the SQList Manager UI to make it easier to set-up replications. Our new "replicate in 60 seconds" wizard makes setting up a replication from scratch a breeze. Try it and see for yourself!

See it in action

Watch this video and see a SQL Server database built and updated on the fly from a SharePoint site. All done in just a few minutes!

Try for 14 days

Download a fully functional 14 day trial version of SQList...

Request a demo

Request a personalised online demo of AxioWorks SQList.

Buy SQList

Start building and deploying SharePoint and SQL Server solutions today; choose either Entry, Standard, or Professional versions ensuring you only pay for the capacity you need...

Requirements

  • SharePoint 2007, 2010, 2013, and SharePoint Online
  • SQL Server 2005, 2008, 2012, and SQL Azure
  • Windows XP, Vista, 7, 8, Server 2003, 2008, 2012 (32 and 64 bit editions)
  • .NET Framework 4.0 Runtime

"100% CLEAN" Softpedia award

100% clean and rated 5 stars on GearDownload.com

Download the SQList PAD file.
(what is PAD?)