Getting started - building an App that takes data and processes it

Question

Hi Azure Community,

I am a complete noobie on here and i am looking to get kick started which i think i will be able to find my momentum.

Essentially i am looking to create an app that takes in data sets, runs some calculations and presents it back with the ability to interact and manipulate the data (future integration with SAP and other platofrms to pull the data directly out).

The data that is presented to you is to make an informed decision and upon confirming the decision being made and any overrides you put in place i want that data to be captured and also stored.

Ive been reading and believe i need to use the below services but dont actually know how to get started:

• Azure functions
• Azure Logic apps
• Azure SQL Databse
• possibly Azure machine learning but at this stage don't require it

Answer 1

Azure Data Factory (ADF) offers you a great connector to SAP that can help you gather from SAP the data sets you may want to put on Azure SQL. Here you will find how to get started with ADF. Here you will find more information about ADF SAP connectors. This video shows how to extract data from SAP also. In addition, you can use OData to extract data from SAP into Azure. This a free course to learn how to perform integrations with ADF.

ADF allows you also to transform the data sets using mapping data flows. Here you will find a tutorial.

You can build an Azure Web App to visualize or manually change some data. Here an example.

You can use Power BI to visualize, analyze and explore the already transformed data on Azure SQL. See a tutorial here.