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.

New version of AxioWorks SQList released (7.0.0.0)

A new version of AxioWorks SQList is out today!

We have been really busy for the past few months, but here we are with a brand new release of AxioWorks SQList! Version 7, a major one.

Let’s see what cool new features come with it…

AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BICrystal Reports, or SSRS.

I want this column, I don’t want that one!

Oh yes, ladies and gentlemen, the long awaited Column Selector has finally arrived!

With this new version you can (at long last!) pick and choose exactly the SharePoint list’s columns you want to export. No more comma delimited filters, looking for Internal names in URLs, or wondering which column name is duplicate. Simply open the Column Selector and selected exactly the columns you want. And if you don’t like their names, go ahead and rename them!

Where can I see whether my list is being replicated?

Now, that’s a question we are asked a lot! And the only answer we have been able give is “well….check the event log and try to figure it out”. Not anymore!

Let us introduce the Service Monitor dashboard! A new panel where you can see which list is being replicated at any given time and follow its progress. It is an incredibly useful feature and much fun to watch too, with all those progress bars and lists moving up and down.

SQList: Unlimited access to unlimited SharePoint sites

We have removed the limit to the number of sites you can export! No more 50 sites, 100 sites, go ahead and export as many as you want. But don’t forget that “with unlimited sites come great responsibilities”: the total number of lists you export from across all sites still affects the performance of SQList.

The removal of site limits gave us also the chance to do some cleaning up: we have discontinued SQList Professional and renamed SQList Professional Plus to simply “SQList”. Plain and simple.

Finally, a few things hardly worth mentioning:

  • we improved the way SQList handles replications to multiple databases;
  • we added an additional authentication type to SQL Server database connections.

As always, a big thank you to those who gave us feedback and suggestions. Feedback from the real world is invaluable and we really appreciate it.

If you would like to read all the details about this release and download it, head over to the support article here: What is new in SQList ver. 7.0.0.0.

Please ensure that you read the SQList Upgrade notes of all versions of SQList between your current one and the latest, as there may be breaking changes. Also, ensure that you read the Known limitations of SQList to avoid surprises. If you have any questions about this release, do not hesitate to contact our support team at support@axioworks.com.

That’s all folks, till next time.

The AxioWorks Team

Latest articles

Gain valueable Insights into your PowerApps using Application Insights

25 Oct 2021

Power Platform provides a great way for citizen developers to develop Apps using low-code /no-code tools like PowerApps, PowerAutomate, and PowerBI. […]
[read article]

AxioWorks Newsletter September 2021: Focus on our sales effort

18 Oct 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Why use SQList to generate Power BI reports from SharePoint lists, rather than using the Power BI native connector to SharePoint?

18 Oct 2021

The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it […]
[read article]

SharePoint Online List vs SQL Server as Data Source in Power-BI

15 Sep 2021

Lists are primarily used as a source of data storage in the world of SharePoint and in most scenarios these lists can grow really fast especially if […]
[read article]

AxioWorks Newsletter August 2021: We’re working hard

30 Aug 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Get the Power of Location-based analytics in Power BI using ArcGIS Maps

16 Aug 2021

In today’s world, data analytics has to become pivotal for making informed decisions and decision-makers are always keen to find new and innovative […]
[read article]

AxioWorks Newsletter July 2021: We’ve expanded!

01 Aug 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

SharePoint Spaces: Empowering enterprises to build Virtual Reality solutions

31 Jul 2021

The World is moving towards virtual reality which is considered by most tech gurus as one of the technologies of the future. The capabilities […]
[read article]

AxioWorks Newsletter July 2021: Building up a successful release in June

03 Jul 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

We are looking for a Sales and Marketing Manager!

18 Jun 2021

We are looking for someone with experience in the SharePoint and BI arenas to take on the role of Sales and Marketing Manager. You will be able to […]
[read article]

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

*