Line 1: |
Line 1: |
− | 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 the [[Common Data Service]]. | + | {{Infobox features |
| + | |title = Virtual Entities |
| + | |usecases = Display external data in model-driven apps, represent data in tables in Dataverse without replicating the data. |
| + | |publicpreview = N/A |
| + | |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] |
| + | |mslearn = N/A |
| + | }} |
| | | |
− | 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. | + | 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! |
| + | [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 == |
| 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 [https://myinspire.microsoft.com/sessions/a780eafa-dc4f-44fc-a460-6d6effee28ec 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. | | 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 [https://myinspire.microsoft.com/sessions/a780eafa-dc4f-44fc-a460-6d6effee28ec 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. |
| | | |
− | == You might also be interested in == | + | == See also == |
− | | + | * [[Custom Data Provider]] |
− | [[Embedded canvas apps]] | + | * [[Embedded canvas apps]] |
| | | |
| == Microsoft Resources == | | == Microsoft Resources == |
− | | + | * [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-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 Common Data Service as Virtual Entitites] in the 2020 Release Wave 1 Plan | + | * [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/powerapps/developer/common-data-service/virtual-entities/get-started-ve/?WT.mc_id=DX-MVP-5003780 Get started with Virtual Entities] Virtual Entities in the [[CDS]] section under Power Platform | + | * [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/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 |
| | | |
| == Community Resources == | | == Community Resources == |
| + | === Articles === |
| + | |
| + | VE now with support for CRUD! |
| + | * [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://www.itaintboring.com/dynamics-crm/adding-crud-to-virtual-entities/ Adding CRUD to Virtual Entities] by Alex Shlega 2021-04-03 |
| + | * [https://markcarrington.dev/2021/04/02/create-update-delete-virtual-entities/ CREATE/UPDATE/DELETE VIRTUAL ENTITIES] by Mark Carrington 2021-04-02 |
| | | |
− | === Articles ===
| + | Other articles: |
| | | |
− | * [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://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.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://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://carinaclaesson.com/2020/01/19/virtual-entities-a-forgotten-feature-which-is-still-alive/ Virtual Entities - Series of 4 Articles] by Carina Claesson | + | * [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://dynamicsninja.blog/2018/09/30/virtual-entities-part-1-odata-v4/ Virtual Entities - Series of 3 Articles] by Ivan Ficko | + | * [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://jlattimer.blogspot.com/2017/12/creating-custom-virtual-entity-data.html Creating a Custom Virtual Entity Data Provider] by Jason Lattimer | + | * [https://mikefactorial.com/2020/08/15/direct-query-sql-virtual-entities/ Direct Query SQL Virtual Entities] by Michael Ochs 2020-08-15 |
− | * [http://blog.yagasoft.com/2019/03/virtual-entities-work-arounds Virtual Entities work-arounds] by Ahmed Elsawalhy | + | * [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.itaintboring.com/dynamics-crm/dynamics-365-working-with-the-virtual-entities/ Dynamics 365 working with the Virtual Entities] by Alex Shlega | + | * [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 |
− | * [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 | + | * [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://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 2018-05-19 |
| + | * [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 |
− | | |
− | === Custom Data Provider Samples ===
| |
− | * [https://github.com/mikefactorial/SqlVirtualEntityDataProvider SQL Virtual Entity Data Provider] by Michael Ochs
| |
− | * [https://github.com/CarinaClaesson/CustomDataProvider Custom Data Provider for the SpaceX Rocket Launch API] by Carina Claesson
| |
− | * [https://github.com/jlattimer/D365CustomDataProvider D365 Custom Data Provider] by Jason Lattimer
| |
| | | |
| [[Category: Maker]] | | [[Category: Maker]] |
| [[Category: Developer]] | | [[Category: Developer]] |