Book Image

Microsoft Power Platform Enterprise Architecture

By : Robert Rybaric
Book Image

Microsoft Power Platform Enterprise Architecture

By: Robert Rybaric

Overview of this book

For forward-looking architects and decision makers who want to craft complex solutions to serve growing business needs, Microsoft Power Platform Enterprise Architecture offers an array of architectural best practices and techniques. With this book, you’ll learn how to design robust software using the tools available in the Power Platform suite and be able to integrate them seamlessly with various Microsoft 365 and Azure components. Unlike most other resources that are overwhelmingly long and unstructured, this book covers essential concepts using concise yet practical examples to help you save time. You’ll develop the skills you need to architect, design, and manage a complex solution as you follow the journey of a fictitious enterprise customer as they enter the world of Power Platform. Throughout the book, you’ll discover how to combine the functionality of Power Apps, Power Automate, Power BI, and Power Virtual Agents with various methodologies to effectively address application lifecycle management, security, and extensibility. Finally, you'll learn how to overcome common challenges in migrating data to and from Microsoft Power Platform using proven techniques. By the end of this book, you’ll have the strategic perspective of an enterprise architect to make accurate architectural decisions for your complex Power Platform projects.
Table of Contents (15 chapters)
1
Section 1: The Basics
4
Section 2: The Architecture
8
Section 3: Implementation

Understanding data migration tools and techniques

There are several ways to accomplish data migration to CDS. The CDS platform itself offers some out-of-the-box possibilities; however, these only cover the less complex migration scenarios. For the most complex scenarios, an external solution needs to be considered, as you'll learn in the following sections.

Doing manual entry

For the smallest data volumes where there's just a few records, the easiest and fastest way to migrate data is to manually enter it. Any semi-automated or automated data import would just take more effort and time to implement, compared to simple manual data entry.

Using Excel files

The simplest way to import data into a CDS entity is to use the Excel's export feature. CDS applications provide a standard feature to export data from any entity into Excel. There are several export possibilities, but for importing data, the Static Worksheet option needs to be used since it can be used for...