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.

Our blog

AxioWork news, product updates, useful articles, hints and tips on how to make the most of your SharePoint data and Power BI Reports.

Image for blog article Archiving SharePoint list and library data to SQL Server Tables

Archiving SharePoint list and library data to SQL Server Tables

As of SQList v5 Professional, we have added a feature that will allow SharePoint list and library items to be archived to a SQL Server table. What do I mean by this? We now have a setting that enables you to maintain deleted list items in the replicated SQL table. Once you have set up replication from a SharePoint lists or library to SQL server, using the SQList manager, items deleted in SharePoint will not be deleted in the corresponding SQL table. They will simply be marked as […]
[read article]

02 Sep 2016 | Share: Twitter icon LinkedIn icon

Image for blog article What is SQList by AxioWorks?

What is SQList by AxioWorks?

We’ve put together a 1minute video to explain our SQList tool: […]
[read article]

01 Jun 2016 | Share: Twitter icon LinkedIn icon

Image for blog article Tame your SharePoint data and build reports, dashboards and KPIs like a master. (Collab365 Session)

Tame your SharePoint data and build reports, dashboards and KPIs like a master. (Collab365 Session)

Here is our session from the Collab365 Summit streamed live from Microsoft HQ in Redmond Tame your SharePoint data and build reports, dashboards and KPIs like a master. (Collab365 Session) In this session we’ll look at ways to cut development and maintenance costs of data externalisation and ETL processes and how AxioWorks SQList can dynamically sync your SharePoint data with SQL Server for reporting, datawarehousing, BI and other LOB integration. We’ll also demonstrate the […]
[read article]

01 Jun 2016 | Share: Twitter icon LinkedIn icon

Image for blog article Options for Replicating SharePoint Data to SQL Server – Collab365 Session

Options for Replicating SharePoint Data to SQL Server – Collab365 Session

In this session from the Collab365 Conference, we looked at the options for externalising SharePoint data including the use of SSIS, CSOM code and a pretty neat shortcut for doing replicating your data to SQL Server without having to write a line of code. SQList Key Features Continuously exports SharePoint lists and documents to single or multiple SQL Server databases. Dynamically builds a normalised set of SQL tables. Export sub-sites automatically: export lists and libraries from a […]
[read article]

11 Mar 2016 | Share: Twitter icon LinkedIn icon

Image for blog article Use SharePoint lists like a SQL Server Database table

Use SharePoint lists like a SQL Server Database table

In this video we look at how to: Treat SharePoint list data like a SQL Server table Aggregate SharePoint lists and libraries across site collections and farms! Cut SharePoint data externalisation costs and timescales Build complex queries against your SharePoint data -NO MATTER WHERE IT IS! Painless integration of SharePoint Data with SSRS, Cognos, Power BI Build powerful reports and dashboards from inside SharePoint […]
[read article]

02 Mar 2016 | Share: Twitter icon LinkedIn icon

Image for blog article Synchronize SharePoint Data to SQL Server quickly and easily with SQList v4.1

Synchronize SharePoint Data to SQL Server quickly and easily with SQList v4.1

We are proud to announce the release of SQList v4.1. This release is designed to make replication of SharePoint data to SQL Server even easier, faster and with a greater degree of automation. We have also added new features, fixes and enhancements. Read all about them here Download AxioWorks SQList v4.1 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 […]
[read article]

11 Feb 2016 | Share: Twitter icon LinkedIn icon

Image for blog article Exporting SharePoint Documents and Metadata to SQL Server

Exporting SharePoint Documents and Metadata to SQL Server

One interesting feature of SQList is that it can be used to export files from SharePoint and SharePoint Online to SQL Server and SQL Azure along with the associated metadata and then keep that data in constant synch. SQList is a unique windows service that will synchronize SharePoint lists and libraries including binary content like files and attachments to a normalised set of SQL Server tables. All tables and mappings are taken care of by the software so it can be set up in minutes. No changes […]
[read article]

30 Dec 2015 | Share: Twitter icon LinkedIn icon

Image for blog article Synchronize SharePoint Online Lists and Libraries to SQL Server or SQL Azure

Synchronize SharePoint Online Lists and Libraries to SQL Server or SQL Azure

In this article we will look at the fastest way to Synchronize your SharePoint Online Lists and Libraries inc metadata with SQL Server Or SQL Azure. It’s possible to your Synchronize entire SharePoint Online (or On-Prem) data to any version of SQL Server within about 10 minutes just by following the steps below: 1. Download a fully working version of SQList from here 2. Install SQList using these instructions (takes a couple of minutes) 3.  Follow Run SQList for the first time […]
[read article]

30 Dec 2015 | Share: Twitter icon LinkedIn icon

Page 17 of 18 | Go to page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

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

*