Our blog

Highlights of the Microsoft SharePoint Summit 2017 Microsoft unveiled plans for SharePoint, Onedrive and Offiec365 during the SharePoint Virtual Summit today (May 16th) Here’s a summary of some of the announcements and reaction to those [View the story “Highlights of the SharePoint Summit” on Storify] […]
[read article]

16 May 2017 | Share:

How To: Import SharePoint libraries into Power BI and create links to the documents If you have tried to import from SharePoint to power BI you have probably realised you can import Lists and folders but not libraries. In this post, which is based on a video by Ruth Pozuelo Martinez who is a microsoft MVP we’ll look at the Ruth’s suggested steps for doing the following: Export the data from a SharePoint document library into the Power BI desktop Create a visualisation that includes […]
[read article]

02 Apr 2017 | Share:

In this post I’m going to summarise all the updates to SQList in v5 releases (5.0, 5.1, 5.2, 5.3 and 5.4 at the time of writing) It’s probably worth saying that upgrades from v4 are available to all SQList customers who subscribe to our preventive maintenance plan. If you like more information about his or a would like a quote for an upgrade please contact our sales department. There have been a few potentially breaking changes in as part of the SQList v5 releases! Look out for […]
[read article]

01 Apr 2017 | Share:

5 Ways To Export SharePoint Data to SQL Server SharePoint provides us with a great way of capturing and managing data which has seen a huge increase in business data stored in SharePoint On Premise and SharePoint Online lists and libraries. This often means we have the requirement to report against this data. SharePoint doesn’t always make this easy for us! We can install reporting services into a SharePoint site but it’s still not easy to report against the data. As a consequence of the […]
[read article]

01 Apr 2017 | Share:

We are proud to announce the release of SQList v5.3. Today we announce some great new features in our SQList 5.3 release, namely: Export SharePoint lists that exceed the list view threshold Export attachments, without binary data Duplicate site configurations and database connections Configurable timeout for SharePoint web service connections Various bug fixes Let’s look at these changes in a bit more detail: Export SharePoint lists that exceed the list view threshold SharePoint limits […]
[read article]

28 Mar 2017 | Share:

Set up a scheduled export of SharePoint lists and libraries to SQL Server Tables In this article we will see how to: Schedule exports of SharePoint lists and libraries to normalised SQL Server database tables without any development effort Use the windows task scheduler and SQList to provide automated replications of complicated SharePoint data structures Get around SharePoint list threshold and lookup threshold issues Make SharePoint data available to SSRS, PowerBI, Tableau, SAP HANA and […]
[read article]

05 Mar 2017 | Share:

We are proud to announce the release of SQList v5.0. The following new features have been added to this release: Warning: There are a few potentially breaking changes in this release! Look out for this symbol  Archive SharePoint Data in SQL / Maintain deleted list items in SQL tables We have added a setting that enables you to maintain deleted list items in the replicated SQL table. This can be useful it you want archive SharePoint list items to SQL server.To disable the removal of deleted […]
[read article]

02 Oct 2016 | Share:

Features include: Support for SharePoint 2007, 2010, 2013 and SharePoint Online in Office365 Exports all the lists and libraries in a SharePoint site as a set of normalised tables to any SQL Server database; Selective replication: precisely control the lists and files 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 […]
[read article]

12 Sep 2016 | Share: