Choosing the right data source – real-world tests
Every data source has unique features that make them ideal for specific scenarios, whether you need a robust relational database, a document-centric infrastructure, or a lightweight approach for mobile applications.
This recipe will test some of Microsoft’s most well-known players in the data source world: Dataverse, SharePoint, and Azure SQL Databases. With the help of Power Automate, we will test both the reading and writing speeds of these three contestants.
Getting ready
The first requirement is to have the same data structure for each service:
- A list with the default Title column in SharePoint
- A table with a Title field in Azure SQL using the Basic performance tier
- A table with a Title column in Dataverse
After creating these data sources, proceed to the Power Automate portal to build our tests at https://make.powerautomate.com/
How to do it…
- We will...
