For the Integrate talk I wanted to create the same demo but repeat it 4 times to show the different ways each of the operations technologies would help you in the monitoring and management of your solution. The idea is by using the same demo we can focus on the differences between the different operations technologies to better understand what value they can add to the solution and to help people understand which technology to use for which scenario.
The Use Case
The demo scenario for this talk was based around the scenario where I have a factory which makes unicorns. The factory receives supplies from suppliers and each time I receive supplies I recieve a flat file message in CSV format from the supplier. I then parse this flat file and upload messages to a Power App on the Microsoft Power Platform which I will use to manage the inventory of my supplies for building unicorn toys.
The Power App
Below is a screen show from my Power App showing the list of todays ingredients that we have received from suppliers and one of the chart views that is easy to setup in Power Platform.
If I open up one of the ingredients you would see the form below:
You can see it has a link on the from field which is a reference to the Dataverse account entity where I have a list ofthe suppliers for the factory.
The Interface Architecture
The interface needs to do the following things:
- Receive a CSV message
- Debatch the message
- Find the matching account record in the dataverse
- Load Records into the ingredients entity in the dataverse
I have decided to debatch the CSV file and load messages to an event hub and then have a Logic App which processes messages from the event hub into the dataverse. This seperation means if I ever want to infuture extend my demo I might also add an API approach to receive supplies and then I could also write them to the event hub and process them from there.
A diagram of the architecture would look like the below:
To simulate the interface regularly receiving data so the demo has regular data to help me demonstrate how the various tools work I have added a logic app which will simulate a partner sending a CSV file and then I have set it to run every few hours so there is plenty of data regularly running through the system to show a meaningful demo. If you bring in the test scenario the modified architecture we would be looking at looks like below.