Difference between revisions of "Virtual Entities"

From Power Wiki
Jump to navigation Jump to search
 
(19 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
|title = Virtual Entities
 
|title = Virtual Entities
 
|usecases = Display external data in model-driven apps, represent data in tables in Dataverse without replicating the data.  
 
|usecases = Display external data in model-driven apps, represent data in tables in Dataverse without replicating the data.  
|publicpreview =  
+
|publicpreview = N/A
|generalavailability =  
+
|generalavailability = N/A
 
|msdocs = [https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/virtual-entities/get-started-ve/?WT.mc_id=DX-MVP-5003780 Virtual Entities]
 
|msdocs = [https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/virtual-entities/get-started-ve/?WT.mc_id=DX-MVP-5003780 Virtual Entities]
 +
|mslearn = N/A
 
}}
 
}}
  
 
Virtual Entities is a feature in the Power Platform which makes it possible to display data from other systems in our [[model-driven apps]] without having the data stored in [[Microsoft Dataverse]].  
 
Virtual Entities is a feature in the Power Platform which makes it possible to display data from other systems in our [[model-driven apps]] without having the data stored in [[Microsoft Dataverse]].  
  
The concept of Virtual Entities consists of a Virtual Entity, a Data Source and a Data Provider. Either you can use one of the two built-in data providers (an OData v4 provider or an Azure Cosmos DB provider), or you can develop a Custom Data Provider if your source requires that.  
+
The concept of Virtual Entities consists of a Virtual Entity, a Data Source and a Data Provider. Either you can use one of the two built-in data providers (an OData v4 provider or an Azure Cosmos DB provider), or you can develop a [[Custom Data Provider]] if your source requires that.  
 +
 
 +
Now with support for CRUD!
 +
[https://docs.microsoft.com/en-us/powerapps/developer/data-platform/virtual-entities/sample-ve-provider-crud-operations Sample: Custom virtual table provider with CRUD operations]
  
 
== History ==
 
== History ==
Line 15: Line 19:
  
 
== See also ==
 
== See also ==
[[Custom Data Provider]]
+
* [[Custom Data Provider]]
[[Embedded canvas apps]]
+
* [[Embedded canvas apps]]
  
 
== Microsoft Resources ==
 
== Microsoft Resources ==
* [https://bguidinger.com/blog/virtual-entities-dynamics-365 Virtual Entities in Dynamics 365] by Bob Guidinger
+
* [https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/virtual-entities/get-started-ve/?WT.mc_id=DX-MVP-5003780 Virtual Entities Get started with virtual entities]
 +
* [https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/overview Microsoft Power Platform integration with Finance and Operations]
 +
* [https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-admin-integration-common-data-service-virtual-entities/?WT.mc_id=DX-MVP-5003780 Dynamics 365 Human Resources Configure Dataverse virtual tables]
 
* [https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/finance-operations-crossapp-capabilities/finance-operations-entities-common-data-service-as-virtual-entities/?WT.mc_id=DX-MVP-5003780 Finance and Operations entities in Microsoft Dataverse as Virtual Entitites] in the 2020 Release Wave 1 Plan
 
* [https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/finance-operations-crossapp-capabilities/finance-operations-entities-common-data-service-as-virtual-entities/?WT.mc_id=DX-MVP-5003780 Finance and Operations entities in Microsoft Dataverse as Virtual Entitites] in the 2020 Release Wave 1 Plan
 
* [https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities/?WT.mc_id=DX-MVP-5003780 Create and edit Virtual Entities] Take a look at the On-Premises documentation to get a better understanding for the overall process
 
* [https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities/?WT.mc_id=DX-MVP-5003780 Create and edit Virtual Entities] Take a look at the On-Premises documentation to get a better understanding for the overall process
 
* [https://docs.microsoft.com/en-us/archive/blogs/lystavlen/virtual-entities/?WT.mc_id=DX-MVP-5003780 Virtual Entities] Blog Post from Microsoft 8th of September 2017
 
* [https://docs.microsoft.com/en-us/archive/blogs/lystavlen/virtual-entities/?WT.mc_id=DX-MVP-5003780 Virtual Entities] Blog Post from Microsoft 8th of September 2017
* [https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/overview Microsoft Power Platform integration with Finance and Operations]
 
  
 
== Community Resources ==  
 
== Community Resources ==  
 +
=== Articles ===
  
=== Articles ===
+
VE now with support for CRUD!
* [https://medium.com/@sami.pappila/virtual-entities-for-finance-and-operations-in-common-data-service-part-1-adc7c869a2e6 Virtual Entities for Finance and Operations in Common Data Service] by Sami Pappila 2020-07-28
+
* [https://www.blog.allandecastro.com/custom-virtual-tables-perform-crud-operations-to-another-system/ Custom Virtual Tables: Perform CRUD operations to another system] by Allan De Castro 2021-04-05
* [https://mikefactorial.com/2020/08/15/direct-query-sql-virtual-entities/ Direct Query SQL Virtual Entities] Article describing his SQL Virtual Entity Data Provider, by Michael Ochs
+
* [https://www.itaintboring.com/dynamics-crm/adding-crud-to-virtual-entities/ Adding CRUD to Virtual Entities] by Alex Shlega 2021-04-03
* [https://www.powerazure365.com/blog-1/cds-virtual-entities-with-dynamics-365-finance-and-operations CDS Virtual Entities with Dynamics 365 Finance and Operations] by Aurélien Clere
+
* [https://markcarrington.dev/2021/04/02/create-update-delete-virtual-entities/ CREATE/UPDATE/DELETE VIRTUAL ENTITIES] by Mark Carrington 2021-04-02
* [https://carinaclaesson.com/2020/01/19/virtual-entities-a-forgotten-feature-which-is-still-alive/ Virtual Entities - Series of 4 Articles] by Carina Claesson
+
 
* [https://dynamicsninja.blog/2018/09/30/virtual-entities-part-1-odata-v4/ Virtual Entities - Series of 3 Articles] by Ivan Ficko
+
Other articles:
* [https://jlattimer.blogspot.com/2017/12/creating-custom-virtual-entity-data.html Creating a Custom Virtual Entity Data Provider] by Jason Lattimer
+
 
* [http://blog.yagasoft.com/2019/03/virtual-entities-work-arounds Virtual Entities work-arounds] by Ahmed Elsawalhy
+
* [https://temmyraharjo.wordpress.com/2021/03/05/dynamics-crm-implement-virtual-entity-part-1/ Series of Articles about Virtual Entities] by Temmy Whayu Raharjo 2021-03-05
* [https://www.itaintboring.com/dynamics-crm/dynamics-365-working-with-the-virtual-entities/ Dynamics 365 working with the Virtual Entities] by Alex Shlega
 
* [http://imran-chowdhury.blogspot.com/2019/09/virtual-entity-chapter-1-definition-and.html Virtual Entity : Chapter 1 – Definition and Usage] by Imran 2019-09-08
 
* [http://imran-chowdhury.blogspot.com/2019/09/virtual-entity-chapter-2-create-custom.html Virtual Entity : Chapter 2 – Create a Custom Data Provider for a Virtual Entity] by Imran 2019-09-08
 
* [http://imran-chowdhury.blogspot.com/2019/09/virtual-entity-chapter-3-translating.html Virtual Entity : Chapter 3 – Translating an advanced find query to a query understood by the Data Source] by Imran 2019-09-08
 
* [http://imran-chowdhury.blogspot.com/2019/09/virtual-entity-chapter-4-pulling-api.html Virtual Entity : Chapter 4 – Pulling API Endpoint Settings from Data Source Entity] by Imran 2019-09-08
 
 
* [https://www.itaintboring.com/dynamics-crm/virtual-entities-revisited-using-embedded-canvas-app-for-updates/ Virtual Entities Revisited: using embedded canvas app for updates] by Alex Shlega 2020-12-06
 
* [https://www.itaintboring.com/dynamics-crm/virtual-entities-revisited-using-embedded-canvas-app-for-updates/ Virtual Entities Revisited: using embedded canvas app for updates] by Alex Shlega 2020-12-06
 
* [https://www.itaintboring.com/dynamics-crm/virtual-entities-revisited-setting-up-a-virtual-entity/ Virtual entities revisited: setting up a virtual entity] by Alex Shlega 2020-12-06
 
* [https://www.itaintboring.com/dynamics-crm/virtual-entities-revisited-setting-up-a-virtual-entity/ Virtual entities revisited: setting up a virtual entity] by Alex Shlega 2020-12-06
 
* [https://www.itaintboring.com/dynamics-crm/virtual-entity-revisited-lets-see-how-far-we-can-push-them/ Virtual entity revisited – let’s see how far we can push them] by Alex Shlega 2020-12-05
 
* [https://www.itaintboring.com/dynamics-crm/virtual-entity-revisited-lets-see-how-far-we-can-push-them/ Virtual entity revisited – let’s see how far we can push them] by Alex Shlega 2020-12-05
 +
* [https://mikefactorial.com/2020/08/15/direct-query-sql-virtual-entities/ Direct Query SQL Virtual Entities] by Michael Ochs 2020-08-15
 +
* [https://medium.com/@sami.pappila/virtual-entities-for-finance-and-operations-in-common-data-service-part-1-adc7c869a2e6 Virtual Entities for Finance and Operations in Common Data Service] by Sami Pappila 2020-07-28
 +
* [https://www.powerazure365.com/blog-1/cds-virtual-entities-with-dynamics-365-finance-and-operations CDS Virtual Entities with Dynamics 365 Finance and Operations] by Aurélien Clere 2020-07-01
 +
* [https://carinaclaesson.com/2020/01/19/virtual-entities-a-forgotten-feature-which-is-still-alive/ Virtual Entities - Series of 4 Articles] by Carina Claesson 2020-01-19
 +
* [http://imran-chowdhury.blogspot.com/2019/09/virtual-entity-chapter-1-definition-and.html Virtual Entities - Series of 4 Articles] by Imran 2019-09-08
 +
* [https://dynamicsninja.blog/2018/09/30/virtual-entities-part-1-odata-v4/ Virtual Entities - Series of 3 Articles] by Ivan Ficko 2018-09-30
 
* [https://crmazurecomponents.wordpress.com/2018/08/19/dynamics-virtual-entities-odata-v4-data-source-using-request-parameters/ Dynamics Virtual Entities – ODATA V4 Data Source – Using Request Parameters] by Simaranjit Bhalla 2018-08-19
 
* [https://crmazurecomponents.wordpress.com/2018/08/19/dynamics-virtual-entities-odata-v4-data-source-using-request-parameters/ Dynamics Virtual Entities – ODATA V4 Data Source – Using Request Parameters] by Simaranjit Bhalla 2018-08-19
* [https://dreamingincrm.com/2018/06/14/using-virtual-entities-to-query-metadata/ Using Virtual Entities to query metadata] by Natraj Yegnaraman
+
* [https://dreamingincrm.com/2018/06/14/using-virtual-entities-to-query-metadata/ Using Virtual Entities to query metadata] by Natraj Yegnaraman 2018-06-14
* [https://dreamingincrm.com/2018/05/19/virtual-entities-for-tracking-recently-used-items/ Virtual Entities for tracking recently used items] by Natraj Yegnaraman
+
* [https://dreamingincrm.com/2018/05/19/virtual-entities-for-tracking-recently-used-items/ Virtual Entities for tracking recently used items] by Natraj Yegnaraman 2018-05-19
* [https://lystavlenhistoric.home.blog/2017/09/08/virtual-entities/ Interact with data from external systems using the new virtual entities] by Jesper Osgaard  
+
* [https://www.itaintboring.com/dynamics-crm/dynamics-365-working-with-the-virtual-entities/ Dynamics 365 working with the Virtual Entities] by Alex Shlega 2017-10-30
 +
* [https://lystavlenhistoric.home.blog/2017/09/08/virtual-entities/ Interact with data from external systems using the new virtual entities] by Jesper Osgaard 2017-09-08
 +
* [https://bguidinger.com/blog/virtual-entities-dynamics-365 Virtual Entities in Dynamics 365] by Bob Guidinger 2018-03-11
  
 
=== Videos ===
 
=== Videos ===
*[https://www.youtube.com/watch?v=zgb4sOXbVdQ French HowTo #9 - Dynamics365 F&O CDS Virtual Entities] in Frensh, by Aurélien Clere
+
*[https://www.youtube.com/watch?v=zgb4sOXbVdQ French HowTo #9 - Dynamics365 F&O CDS Virtual Entities] in French, by Aurélien Clere
  
 
[[Category: Maker]]
 
[[Category: Maker]]
 
[[Category: Developer]]
 
[[Category: Developer]]

Latest revision as of 09:16, 4 May 2021

Virtual Entities
Use Cases Display external data in model-driven apps, represent data in tables in Dataverse without replicating the data.
Public preview N/A
General availability N/A
MS Docs Virtual Entities
MS Learn N/A

Virtual Entities is a feature in the Power Platform which makes it possible to display data from other systems in our model-driven apps without having the data stored in Microsoft Dataverse.

The concept of Virtual Entities consists of a Virtual Entity, a Data Source and a Data Provider. Either you can use one of the two built-in data providers (an OData v4 provider or an Azure Cosmos DB provider), or you can develop a Custom Data Provider if your source requires that.

Now with support for CRUD! Sample: Custom virtual table provider with CRUD operations

History

The July 2017 update for Dynamics 365 (online) introduced Virtual Entities. The upcoming Release Waves after that did not bring any news whithin this area, but during a session at eXtreme 365 Matt Barbour said "Virtual Entities are not dead". In the 2020 Release Wave 1 plan it was presented that Dynamics 365 Finance & Operations entities will be available in the Common Data Service as Virtual Entities. In July 2020 at Microsoft Inspire Vitural Entities was on the map again when it was included in Charles Lamanna's session Build agile business processes with the Power Platform – Focus on CDS, Power Apps, Power Automate + RPA and it was included in the Roadmap for Key Capabilities for 2020/2021.

See also

Microsoft Resources

Community Resources

Articles

VE now with support for CRUD!

Other articles:

Videos