2018-01-29

We have all been there! An urgent request arrives into the team demanding that we provide a report on 2 large SharePoint lists, requiring joins, sorts, calculations, “order by’s” and where conditions.

Ok, that’s kinda feasible.

You could hook them up to Excel and do a few fancy pivot tables then try to make it look nice in a report. Or maybe you could try to use Power BI.

Oh, hang on!

They also want to include some profile information from an internal HR system that lives in (on-premises) SQL Server tables.

Damn, so, now we’ve a massive SharePoint List and need to join it to a SQL Table and it needs to be thrown into a report and on the bosses desk by tomorrow morning.

Don’t you wish you could write SQL queries against your SharePoint Lists?

Well you can! Collab365 have partnered with AxioWorks to offer the community a chunky 10% discount on all of their plans for Collab365 members!

Here’s how to get going and try out the goodies. I think you will like this one ?

Paul, at AxioWorks is a good friend and I suggested that he offered a fully-functional free version that shows how easy it is to synchronise a SharePoint (online / on-prem) lists with SQL Server tables

(It really is simple!)

Here’s Paul himself …

https://www.youtube.com/watch?v=GFVdWx9Nl2Y

Download now and don’t forget your discount 🙂

All you need to do is download and install the software, tell it about your source SharePoint List and also your target SQL server and let it do it’s magic. Minutes later you will Be “Select *’ing” like a Ninja.

If you like the product (as much as I think you will), and find that it’s something you’d like for lots of your lists then make sure you use the discount code “Collab365-10” to get 10% reduction.

Next Steps:

  • Download: 15 day trial : Download Link
  • Purchase (saving 10%): Use ‘Collab365-10’ to get the 10% discount.

 

(Visited 229 times, 1 visits today)

About the author 

Mark Jones

Collab365 Founder helping people learn Microsoft 365 via these: 👉 Collab365 Summits - Massive virtual conferences for Microsoft products 👉 Collab365 Today - Aggregation site for the best community blogs 👉 Collab365 Community - Huge blog site including plenty of Microsoft content I want to provide a friendly online community, where we can learn and grow together: 👉 365ers - coming very soon!

Leave a Reply

  1. You can do all that for free with Excel’s Get & Transform (in Excel 2016, or the free addin Power Query for Excel 2013 and 2010). I have dozens of examples where I combine data from several SharePoint lists (on premise and in the cloud), SQL server databases and Active Directory, for example, into one report. Click one button to refresh. Easy and you don’t have to spend a cent for any tools because all the tools you need come built in with MS Office.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

2 Free Ebooks: How to govern Microsoft teams 

Download your 2 free Microsoft Teams governance Ebooks and learn the steps necessary to create a bullet-proof governance strategy.