Virtual tables enable integrating data from external data sources by seamlessly representing that data as tables in Microsoft Dataverse, without data replication. Solutions built on Microsoft Power Platform can leverage virtual tables as if they were native Dataverse tables.
A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database, SharePoint, etc. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.
- Data Source – the location where the external data is stored.
- Data Provider – defines the behavior of the virtual table.
- Connection – this sets up the ability to connect to the data source/ Authentication.
- Connection Reference – this provides a way for Dataverse to use the connection to the data source.
Download and install the Virtual connector
- Go to Microsoft AppSource.
- Search for Virtual connectors in Dataverse.
- Click on Get it Free.
4. Enter the Work or school account which is used for the Dataverse Environment login.
5. Click on Sign In.
6. Click on Get it Now.
7. Select the Dataverse Environment to Install and Click on Install.
8. Virtual Connectors in Dataverse is Installed in the Dataverse Environment.
Hope you learn something, Thanks for Reading 📖!