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 BI, Crystal Reports, or SSRS.
[*SP] Lists provides an easy and robust way of storing and manipulating data in SharePoint. When you set up a new custom list, you also get OOTB data entry forms to perform CRUD (Create, Read, Update, Delete) operations easily. However, most of the time we will need to customize those OOTB forms in order to make them more user-friendly for business users or implement some business rules to control the User interface. Previously, The only way to customize List forms was by using [*PAPPS] but now Microsoft has introduced a new built-in form editor to do some quick customizations without using Power Apps or any other external tool. Today we will look at essentially what we can or can’t do by form editor feature and we will be using an Issue Tracker List scenario.
SharePoint Lists plays a pivotal role in any SharePoint development primarily because it is the preferred source of data storage in SharePoint. All the great features like security permissions trimming, views, various types of columns, data validations, and entry forms that come out of the box and can be easily configured give SharePoint Lists an edge over any other data storage options. However, there are several scenarios that make SharePoint Lists less desirable especially when it comes to reporting. Reporting becomes very critical when we store business-critical data in SharePoint since it is vital for business users to make decisions. E.g. if you are storing customer orders in SharePoint Lists then soon you will need to develop some reports to get insights on your customer buying trends.
In our previous article on MS Lists, we did a detailed introduction including some of the great features which can help any business in implementing use cases like issue tracking and inventory management.
In this blog, we will use MS Lists to create an issue tracking solution using an out of the box template and then we will use SQList to synchronize data between MS Lists and SQL Server database. Finally, we will use Power BI to generate charts.
by Danish Ali Detho | O365 & Power Platform Solution Architect///
Organizations all over the world are trying to find new ways of automating their business processes in order to reduce redundancies, minimize manual data entry and human error. Artificial intelligence plays a significant role when it comes to improving the business process by taking automation to the next level where the process is not only automated but smart and self-sufficient as well.
Microsoft Power Automate provides businesses the capability to automate their business processes easily using their suite of low-code/no-code solutions in Power Platform and now they released a new tool in order to provide them the ability to add artificial intelligence in the form of AI Builder. In this article, we will take a look at AI Builder and the different types of models available for various purposes. We will then create a Form processing model that will extract the form data and then save it in a SharePoint List.
In the real-world, reporting often includes master/detail scenario in which a master list item is selected in order to get more details about the entity. In SharePoint, master data will be stored in a list that contains a lookup column of detail list/s, and getting data from multiple lists would require multiple data sources and then modelling their relationships in Power BI. In this blog, I will show you how easy it is to achieve a master-detail scenario on live data coming from SharePoint lists using AxioWorks SQList. We will start off by looking at the lists which we are going to use in this scenario and followed by how we can use SQList to synchronise data between SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate a report which shows master data in one table and details in the other based on a selection.
A new version of SQList: version 6.2.0.0 is out today!
We haven’t blogged about new releases for years, why we don’t know. We’ve been notifying all our users of SQList, been publishing support articles, but not a mention on our website. Silly strategy you may think…and so do we! But it has not been a strategy as much as a negligence on our part, and today we’re putting an end to it!
In this blog, We will take an in-depth look into how SQList transforms SharePoint lists into SQL tables and how it stores data into each column. We will also look at how all changes made in SharePoint are continuously synchronized into their corresponding SQL Server tables.
I’ll show how easy it is to set up this continuous replication, how we can install AxioWorks SQList anywhere and how we don’t need to make any changes to our SharePoint farm as well as showing some of the ways we can use our SharePoint data form SQL Server.
Please feel free to download a 30 day fully functional trial of AxioWork SQList which will allow you to replicate your own SharePoint data to SQL Server.