Rediger

Line of business extension

Azure Data Factory
Azure Functions
Azure 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, therefore providing a better user experience.

Architecture

Architecture shows data from CDS to SQL via Data Factory and from ERP to SQL. Power Apps gets data, sends via CSV, Power BI 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 users 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, multicloud 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.

Scenario details

Out-of-the-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. You can use Power Apps to process and share data with third parties via standard exports.

Potential use cases

You can use this solution in scenarios like the following:

  • You have legacy systems that can't be modernized or can't support new processes
  • You need to automate connecting third-party data sources to Azure

Next steps