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

Why AxioWorks SQList? Here are 7 reasons.

17 May 2023

SharePoint has established itself as a powerful platform for internal collaboration, document management, and web application development within […]
[read article]

PowerApps Modern Controls

16 May 2023

Introduction PowerApps Modern Controls are a new set of controls that can be used to create more modern and engaging apps. The controls are based on […]
[read article]

AxioWorks Newsletter April 2023: Sneak peak on what’s coming in SQList, Microsoft365 Co-Pilot and much more

25 Apr 2023

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

Exporting SharePoint Data to SQL Server: The Best Way to Access SharePoint Data without Limitations

24 Apr 2023

SharePoint is a powerful collaboration and content management platform used by many organizations for storing and managing data. However, SharePoint […]
[read article]

Microsoft 365 Copilot: AI Revolutionizing the way we work

18 Apr 2023

Artificial Intelligence (AI) is revolutionizing the way we do just about everything in life whether it’s doing chores at home or performing […]
[read article]

AxioWorks Newsletter March 2023: Focus on SQList next release

31 Mar 2023

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

Our Favourite Picks from Power BI Global Summit 2023

17 Mar 2023

Power BI Summit is the biggest Power BI conference of the year which ran virtually from 6th March to 10th March. It brought speakers from the […]
[read article]

AxioWorks Newsletter February 2023: Development of SQList new release is in full swing

28 Feb 2023

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

MS List Templates bundled with Power Automate Flow

20 Feb 2023

Microsoft Lists previously known as SharePoint Lists is the go-to option for maintaining and storing data in the world of O365 and its usage has […]
[read article]

AxioWorks Newsletter January 2023: Kicking off 2023 with some great content

30 Jan 2023

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

*