You are a Solution Architect and need to evaluate the data sources for your Power Apps project.
The project should read and write the data stored in Azure SQL Database and the Dataverse.
Please select the three data sources that you can use in your solution.
Click on the arrows to vote for the correct answer
A. B. C. D. E. F.Correct Answers: B, C and E
For Power Platform projects, you should consider storing all data in the Dataverse.
The Dataverse provides not only the storage for various data types but also rich business logic, security, data, and integration functionality.
You can use the Dataverse API to access data in the Dataverse outside the Power Platform.
Or you can copy the data to the Dataverse from other sources.
If you need to use data from other sources in the Power Apps project, several tools will help you.
These tools include the Connectors, Virtual tables, and Dataflows.
Power Platform provides 400+ out-of-the-box connectors, including the SQL Server Connector.
This connector allows you to connect to Azure SQL Database and SQL Server running on-premises.
The Virtual table creates the representation of non-Dataverse data sources inside the Dataverse in a table form.
You can read and write the data in a virtual table, and the Dataverse takes care of the data synchronization.
The Dataflows help you extract, transform, and load (ETL) data from any source and bring it to the Dataverse or Azure Data Lake Storage.
Option A is incorrect because we need to create or use the Custom connector only if Microsoft does not provide the connector for the data source.
Microsoft offers the SQL Connector, and we do not need to create a custom connector.
Option D is incorrect because the activity table does not provide the data integration with non-Dataverse data sources.
Option F is incorrect because the SharePoint Connector is irrelevant for the current task.
For more information about the data source type for Power Platform projects, please visit the below URLs:
Sure, I'd be happy to provide a detailed explanation of the data sources that can be used in a Power Apps project that needs to read and write data from Azure SQL Database and Dataverse.
Azure SQL Database: This is a cloud-based relational database management system (RDBMS) that is designed to store and manage structured data. Power Apps can connect to Azure SQL Database using the SQL Server connector. The SQL Server connector provides a way to create, read, update, and delete records in Azure SQL Database. It can also be used to execute stored procedures and SQL queries.
Dataverse: This is a cloud-based data platform that is designed to store and manage data for business applications. It provides a set of standard tables and fields that can be used to store data. Power Apps can connect to Dataverse using the Dataverse connector. The Dataverse connector provides a way to create, read, update, and delete records in Dataverse.
Custom Connector: A custom connector is a connector that you can create to connect to any web API that exposes a RESTful endpoint. It allows you to extend the functionality of Power Apps by integrating with external systems. In this case, a custom connector can be created to connect to Azure SQL Database and Dataverse to read and write data.
Virtual Table: A virtual table is a table that is created by defining a SQL query in Power Apps. It allows you to join, filter, and aggregate data from multiple tables. In this case, a virtual table can be created to combine data from Azure SQL Database and Dataverse.
Dataflows: Dataflows allow you to extract, transform, and load data from various sources into Dataverse. It provides a way to automate the data integration process and keep data up-to-date. In this case, dataflows can be used to extract data from Azure SQL Database and load it into Dataverse.
SharePoint Connector: SharePoint connector can be used to connect to SharePoint lists and libraries to read and write data. However, it is not relevant in this case as it does not allow direct connection to Azure SQL Database and Dataverse.
In summary, the three data sources that can be used in a Power Apps project that needs to read and write data from Azure SQL Database and Dataverse are SQL Server Connector, Dataverse Connector, and Custom Connector.