Nowadays, Power Pages sites are gaining popularity for their responsive design interface, security features, and built-in templates. Power Pages allow users to create professional websites using Dynamics 365 data and services. However, not all data may reside in Dynamics 365, and replicating structures solely for Power Pages can be time-consuming and impractical. This limitation restricts Power Pages to using only Dynamics 365 data.
In a recent Microsoft update, it’s now possible to integrate external data sources such as SQL Server or Microsoft Fabric into Power Pages websites. This blog will discuss using SQL data for Power Pages sites.
Consider an IT Helpdesk scenario where ticket management occurs in SQL, and IT agents update ticket statuses directly from SQL. They aim for a centralized system where users can log tickets, which are then synchronized with SQL for IT agents to process.
In this use case, the centralized system referred to is the Power Pages Site. Each user has their login to log tickets, which are automatically synced with SQL without requiring additional integration setup.
To achieve this, we first need to create virtual tables for entities like Accounts, Contacts, Tickets, and Users within Power Pages.
Within your solution, click on “New” and then choose “Table from external data”.… Read More »
