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

Maximising Power BI Reporting from SharePoint: The Strategic Advantage of AxioWorks SQList over Native Connectors

15 Feb 2024

In today’s data-driven environment, making informed decisions rapidly can offer a significant competitive edge. This is where Power BI comes […]
[read article]

AxioWorks Newsletter January 2024: A Promising Start to the New Year!

29 Jan 2024

Hello Reader, We hope this newsletter finds you well and thriving. At AxioWorks, we are embracing the new year with great enthusiasm and are […]
[read article]

Exciting New Partnership and Innovative SharePoint Tools from AxioWorks and Lightning Tools

17 Jan 2024

AxioWorks is excited to announce a strategic partnership with Lightning Tools, a leader in creating innovative SharePoint components. This […]
[read article]

AxioWorks Newsletter November 2023: ESPC23, new partnership, and SQList update!

30 Nov 2023

Hello Reader, Welcome to this month’s edition of the AxioWorks newsletter! We’re thrilled to bring you updates on our recent […]
[read article]

Why Support Legacy SharePoint Versions Like SharePoint 2010?

16 Nov 2023

In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
[read article]

Why Companies are choosing SQList over Power Automate

30 Oct 2023

In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
[read article]

AxioWorks Newsletter October 2023: An exhilarating month.

28 Oct 2023

Hello Reader, As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
[read article]

Why Choose SQList for SharePoint Data Extraction Over DIY Solutions

16 Oct 2023

In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
[read article]

AxioWorks Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

19 Sep 2023

In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
[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

*