Choosing the right data source – real-world tests
Every data source has unique features that make it 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 the most well-known players of Microsoft's data source world: Dataverse, SharePoint, and Azure SQL Database. 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 in each service:
- A list with the default Title column in SharePoint
- A table with a Title field in Azure SQL using the Basic tier
- A table with a Title column in Dataverse
After creating these sources, we head to Power Automate to build our tests at https://powerautomate.microsoft.com/
How it works…
- To run our test, we will need some data, so let&apos...
