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.

AxioWorks SQList is now available online

We have launched SQList Online! The cloud-based software as a service (SaaS) version of SQList, our on-prem application that makes it extremely easy for organizations to store and synchronize SharePoint On-prem/SharePoint Online data into SQL Server databases, allowing them to efficiently generate reports using their preferred reporting tools like Power BI, Excel, or SSRS by connecting directly to SQL tables.
In this article, we will take a look at how to set up your account for SQList Online and then how to set up your fist replication.

AxioWorks SQList Online synchronises SharePoint lists to SQL Server

 

How to Setup replication

Open the SQList Online in your browser and then click on Create New Account.

*Please note that SQList Online is in beta at the time of writing this article.

Provide your details to create an account. Once done, log in using your email address and password.

Now, in order to create a new replication, we will first need to create a SharePoint and SQL connection.

Create a SharePoint connection by providing the URL of the SharePoint site and authentication details and then test to make sure the connection is successful.

Now, make sure you have already created a database in your SQL Server. Create a Database connection by providing the SQL Server information which holds the replication database and authentication details, and then test to make sure the connection is successful.

We are ready to create a replication. Click on Replications in the left-side menu and then create new replication.

Select the SharePoint connection.

Select the list’s in the SharePoint site which you want to be replicated in SQL database

Select the database connection which has the database which you want to use for replication.

Give your replication a meaningful name and then click Finish.

This will start the process of replication. You can view all the logs in the Service monitor.

That’s all, now you should be able to view your SharePoint Lists data in the SQL Database table.

 

Latest articles

AxioWorks Newsletter November 2022: Is it almost Xmas already?

29 Nov 2022

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

Future of SharePoint in the world of Power Platform

29 Nov 2022

Microsoft SharePoint has been the driving force for enabling virtual team collaboration and the modern workspace revolution over the last three […]
[read article]

Power Pages: A website builder like no other 

31 Oct 2022

There is no denying the fact that low-code/no-code software development tools have gained a significant market segment of software development and […]
[read article]

AxioWorks Newsletter October 2022: It’s been a while!

26 Oct 2022

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

AxioWorks SQList is now available online

27 Sep 2022

We have launched SQList Online! The cloud-based software as a service (SaaS) version of SQList, our on-prem application that makes it extremely easy […]
[read article]

MS Purview : One-Stop-Shop for data governance across your data estate

30 Aug 2022

Every organization utilizes various sources of data often scattered across cloud and on-premises systems. Over time, these data sources continue to […]
[read article]

DevOps in the world of Power Platform using GitHub Actions

31 Jul 2022

DevOps plays a vital role in the success of any software development project but when it comes to building low-code/no-code solutions it is often […]
[read article]

Build your Apps in MS Teams with MS Dataverse for Teams

27 Jun 2022

MS Teams has become one of the most widely used tools for team collaboration and communication in organizations using Microsoft echo-system for […]
[read article]

Dataverse: A one-stop-shop for your App data storage and management

24 May 2022

Data is at the centre of any business application development and is often the deciding factor for which tech. stack to be used for the development. […]
[read article]

AxioWorks Newsletter April 2022: Still working on the next release of SQList…

30 Apr 2022

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 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

*