Create virtual table in Dataverse to connect external data source

Hello Everyone,

Today I am going to share my experience with virtual tables which can be connected from SQL or Sharepoint to create a virtual table.
Lets gets started.
What is Virtual Table?

Virtual table is an intersect table between two different systems, i.e replica of the data source table(SQL or Sharepoint) in Dataverse.
Previously if you want to connect to external data source, you are supposed to integrate the two systems, like sharepoint or SQL Server data source into the Dataverse.
Now no more coding required to integrate the data source into Dataverse from SQL or Sharepoint, Many thanks to Microsoft.
Note: When a virtual table is created inside the Dataverse from SQL or Sharepoint, the data stored in Dataverse virtual table is not considered towards Dataverse storage even millions of records exists in SQL or Sharepoint.
You can make relationship between virtual table and dataverse tables no issues at all.
Lets see how to create virtual table.
Create a…

Source link

Author: Malla Reddy Gurram

Share This Post On
Share via
Copy link
Powered by Social Snap