What are Virtual Tables (Entities) for Dynamics 365?
Microsoft Dynamics 365, Virtual Tables are an easy to deploy solution for viewing data in D365 that resides in an external system.
Perhaps you have data in another system that only needs to be viewed in Dynamics 365.
Or, maybe you have highly sensitive data in an external system that you don't want to be stored in Dynamics.
In both scenarios, Virtual Tables are a new solution for data integration which avoids enlisting a developer to configure a traditional integration that synchronises data back and forth.
Removing the need for custom coding and data replication, Virtual Tables are an alternative to client-side and server-side approaches for connecting external data that is significantly easier to configure and manage.
Virtual Tables are defined in D365 with an internal metadata flag to mark them as virtual which distinguishes them from traditional database held tables.
As such, these are not stored with the associated physical tables specific to records of 'full' entities / tables.
Each Virtual Table will be associated with a virtual entity data provider that offers an OData v4 endpoint, or using a custom connector. During run-time, when a table is referenced, this will be dynamically retrieved from the associated external system.
There is no support for Dynamics 365 business processes around Virtual Table data. As result, business process flows or workflows cannot be utilized that reference this data because it is not held the Dynamics instance or reside on your tenant.
This is an important point and will likely be a defining factor in determining which integration approach is needed.
For businesses that need external data to flow into Dynamics 365 and be a trigger for a process, or to update one of more fields, a traditional client / server-side sync would still be the route to follow.
However, in instances where users want to be able to view everything in one place, including data held in external data sources, Virtual Tables will be a simpler solution that is easier to deploy.
All Virtual Table data is 'read only'.
There isn’t any role level security for Virtual Tables as these are owned by the organisation.
As a result, users will have permissions to see a table, or not, there isn't any middle ground and these entities do not support field level security.
Once enabled, Virtual Tables give users visibility to view data in fields, grids, search results, Fetch XML-based reports and D365 dashboards.
An excellent and low cost alternative to data replication for D365 users who need greater visibility of data!
READ MORE: Get Started with Virtual Tables (Entities)
How to Extract Dynamics 365 Data & Save On Cloud Storage Costs
Using Azure SQL database to store email attachments and other archived data more cost effectively and present this back in Dynamics 365 using Virtual Tables