# Microsoft Power Platform Enterprise Architecture ![rw-book-cover](https://m.media-amazon.com/images/I/81K64OmalKL._SY160.jpg) ## Metadata - Author: [[Robert Rybaric]] - Full Title: Microsoft Power Platform Enterprise Architecture - Category: #books ## Highlights - when you need complex marketing management, does it make sense to choose a Power Apps single-app license for $10 per user and invest months of complex development to implement all of the requirements or rather purchase Dynamics 365 Marketing for $1,500 per month, where all your requirements are covered out-of-the-box? ([Location 880](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=880)) - Power Platform solutions can benefit from using Azure Functions in several ways: Database replication of the Dataverse database into its own Azure SQL instance to get full access to Power Platform data on the database level ([Location 1069](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=1069)) ## New highlights added February 9, 2024 at 8:09 PM - Power Platform is operated on so-called scale groups, which are unified blocks of cloud infrastructure that consist of various infrastructure components necessary for running the services. There are database servers, reporting servers, web servers, app servers, integration servers, and many more, but the Power Platform customer doesn’t have access to these infrastructure components. ([Location 1264](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=1264)) - in a managed environment, every app and flow is considered premium, and every user needs to be equipped with a Power Platform license – a Microsoft 365 license or any other low-level license is not sufficient. ([Location 1463](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=1463)) ## New highlights added February 10, 2024 at 5:13 PM - The CDM is a standardized data model consisting of a metadata system and data schemas. ([Location 570](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=570)) - Microsoft Dataverse can be understood as an implementation of the CDM for the purpose of hosting data for Power Platform applications. But Microsoft Dataverse is much more than just a database. ([Location 578](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=578)) - The purpose of Power Pages is to provide external-facing websites connected with Microsoft Dataverse data for users outside of their own organization. ([Location 706](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=706)) - Currently, the basic storage capacity every new customer gets with their first subscription is as follows: Database: 10 GB Log: 2 GB File: 20 GB ([Location 1351](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=1351)) - The values of the request limits depend on the license type the user communicating with the platform has. These vary between 6,000 and 250,000 requests per 24-hour interval. ([Location 1371](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=1371)) - These limits apply to every individual Power Platform environment separately, but only for API requests. These are evaluated automatically in 5-minute windows for every web server within a scale group. The following measures are evaluated regarding the API limits: Number of requests Execution time Number of connections ([Location 1375](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=1375)) - let’s introduce the new paradigm in developing business applications by involving and empowering the citizen developer. Empowering citizen developers so that they can develop simple applications can solve small business needs and bring business value quickly as opposed to engaging large and complex IT projects. ([Location 2209](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=2209)) ## New highlights added February 20, 2024 at 7:36 AM - The expected value of a Power Platform solution can be found in the following areas: Modernization: Replace the siloed, product-centric approach with a customer-focused approach (360° customer view). Multichannel capability: Extend the number of communication channels with the customer and provide an integrated omnichannel solution including social channels. Automation and AI: Extend the traditional data-centric manual processes with automations, artificial intelligence, mixed reality, and more. Mobility: Empower mobile workers with the same capabilities as traditional desktop workers. Cost saving: Change the traditional CapEx model to OpEx, saving significant upfront costs of a traditional IT solution, such as new hardware, software licenses, or even the extension of the own data center space. Flexibility: Provide a flexible and adaptable solution, being able to quickly respond to changing demand. Agility: Empower citizen developers to bring agility into the organization and reduce the dependency of IT by being able to participate in building IT solutions on their own. ([Location 3219](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=3219)) - Executive steering committee The executive steering committee is a group of individuals representing higher management positions from all major organization units, senior professionals, and experts. The members should be able to steer all projects running in the organization to ensure that company policies and objectives are followed, resources are allocated, budgetary constraints are under control, and projects are in line with the overall organization strategy. The projects usually require the steering committee to make key decisions as they influence the whole organization. Customer project sponsor The customer project sponsor is usually a representative from higher management who serves as an escalation level, makes key decisions, and ensures that major project issues and roadblocks are cleared. ([Location 3579](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=3579)) - A Power Platform solution based on Dataverse stores its data in a cloud database. Microsoft provides the possibility to hand over the database to the customer when the Power Platform subscription ends. This gives the opportunity to perform a well-structured data migration from the Dataverse database to the successor solution. ([Location 4038](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=4038)) - the consulting company, Proseware Inc., ([Location 4046](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=4046)) ## New highlights added February 21, 2024 at 8:04 AM - One of the limitations of Dataverse is the inability to directly work with the underlying relational Azure SQL database that’s holding the business data. ([Location 6522](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=6522)) - Figure 9.8: Integration with Azure SQL ([Location 6531](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=6531)) - Backend integration patterns and solution approaches ([Location 6679](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=6679)) - While they all belong under the Dynamics 365 umbrella, the underlying technology is very different since the main ERP modules – Dynamics 365 Finance and Dynamics 365 Supply Chain Management – are not based on the Dataverse technology. ([Location 6854](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=6854)) - Backend integration Contoso Inc. have a multitude of existing IT systems that are candidates for backend integration. After carefully analyzing their capabilities, they decided to use the following approaches: Data from all existing IT systems that does not need to physically reside in Power Platform, will be integrated using virtual tables. The preferred way for integrating data that must be physically in the Power Platform solution and can be integrated asynchronously is a solution based on Azure Logic Apps in combination with Azure API Management. The project team considers this the most scalable and secure solution for Contoso Inc. They have evaluated that their existing IT systems have APIs, and it seems that all of them can be integrated by using some of the existing public data connectors. For integrating on-premises IT systems, an on-premises data gateway will be implemented in the most secure way. If there are any requirements for real-time integrations, the preferred method will be to use a solution based on Azure Service Bus in the relay mode. Since the Power Platform solution at Contoso Inc. will consist of CRM and ERP modules from the Dynamics 365 product family, they decided to further investigate the dual-write and virtual tables capabilities and to use them to the highest possible extent as a simple, reliable, and Microsoft-supported integration solution. All of those high-level decisions will be documented in the Power Platform integration design document. Contoso Inc. is now confident that they have a good foundation to integrate the Power Platform solution into their complex IT landscape. ([Location 6995](https://readwise.io/to_kindle?action=open&asin=B0BD8QLFP2&location=6995))