Scenarios for virtual tables
We’ve learned about Dual-write, one of the native ways to integrate F&O data with Dataverse. Now it’s time to learn about virtual tables, earlier known as virtual entities. virtual tables are a Dataverse concept that’s not exclusive to F&O. It’s a virtual data source that can display data from several different sources in Dataverse.
The most important feature of virtual tables is that the data is not present in Dataverse; we only see a representation of the data from the external system in Dataverse. In the case of Dynamics 365 F&O, we will be able to consume data from the public virtual entities in F&O from Dataverse, but the data will be kept in F&O.
Does this mean we can only read data using virtual tables? No! We can perform all CRUD operations and more:
- Create: For creating data
- Update: For modifying data
- Delete: For deleting records
- Retrieve: For querying a table with just the...