Rediger

Line of business extension

Data Factory
Functions
SQL Database
Power Apps
Power BI

Solution ideas

This article is a solution idea. If you'd like us to expand the content with more information, such as potential use cases, alternative services, implementation considerations, or pricing guidance, let us know by providing GitHub feedback.

This example shows how you can modernize your legacy systems that can't support new processes and provide better user experience.

Potential use cases

Out-of-box or custom connectors can help simplify process automation and connect to third party data sources or legacy systems. Azure Functions can then schedule calculations on a scheduled basis to simplify your business processes. Power Apps can be used to process and share data with third parties via standard exports.

Architecture

Architecture shows data from C D S to S Q L via Data Factory and from E R P to S Q L. Power app gets data, sends via C S V, Power B I shows trends.

Download a Visio file of this architecture.

Dataflow

The data flows through the solution as follows:

  1. Supplier data stored in CDS is moved to SQL via Data Factory.
  2. Purchase order (PO) data stored in ERP system is sent to Azure SQL database.
  3. Azure Functions uses API to surface PO data monthly and creates a task for user to review.
  4. Power Apps retrieves data from Azure SQL Database through API.
  5. User reviews and updates POs in Power Apps and sends this data to suppliers through CSV export.
  6. Power BI reports trends in supplier status.

Components

Data is loaded from these different data sources using several Azure components:

  • Power Apps: Increase agility across your organization by rapidly building low-code apps that modernize processes and solve tough challenges.
  • Azure Functions: Accelerate and simplify application development with serverless compute
  • Azure API management: Hybrid, multi-cloud management platform for APIs across all environments
  • Azure SQL Database: Build apps that scale with the pace of your business with managed and intelligent SQL in the cloud
  • Azure Data Factory: Hybrid data integration service that simplifies ETL at scale
  • Power BI: a suite of business analytics tools to analyze data and share insights. Power BI can query a semantic model stored in Analysis Services, or it can query Azure Synapse directly.

Next steps