3,312
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + − + + + + + + − + − + − + − + − + − + + − * [https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/overview Microsoft Power Platform integration with Finance and Operations] + − === Articles ===+ + + + + + − + − * [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://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 − * [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://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 + + + + + + − + + + + + − + − − === 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 − * [https://github.com/ImranCodeBug/codebug.countryprovider/releases Custom Data Provider] by Imran
no edit summary
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 [[Microsoft Dataverse]].
{{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
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.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 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
[[Category: Maker]]
[[Category: Maker]]
[[Category: Developer]]
[[Category: Developer]]