Integerating sensor data with project input data and automating the device to cloud process.

Umair Akhtar 41 Reputation points
2022-09-20T13:14:55.157+00:00

Hi,
I am working on Iot case. Overview of the case, there is a plant which is connected to couple of machines. This plants heats up these machine. Machines and plant are installed with sensors.
Before process to begin. User wants a kind of form or dashboard where user can input his name, machine no. and then login and input further details such as job number, project number, machine etc and then there should be buttons such as start, end, pause, finish. These button should have functionality to initiate the process of sending sensor data to cloud. I tried to use MS form but it does not have functionality to add button and add trigger. I have embedded real live graph/dashboard of sensor data for on premise but I would still need user input for project for particular job during that time combined with telemetry data.

There are two things to figure out

  1. User input data solution - MS forms did not work so need solution to input user data and integrate this user input data with telemetry data that outputs in power bi and Azure SQL database via ASA.
  2. Some functionality in this dashboard or form to login, and start and end the process of sending sensor data to cloud. There should be some kind of automation using azure function or logic app but I am not sure.

I have been stuck with this a while and any help would be really appreciated.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,304 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,857 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,127 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,128 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sander van de Velde 28,796 Reputation points MVP
    2022-09-20T17:39:38.993+00:00

    Hello @Umair Akhtar ,

    you probably need a custom dashboard/management portal with user input/security etc.

    This is typically built using custom software development (eg. an Asp.net MVC Core app with Angular or Vue frontend).

    Or you can use Blazor if you have strong knowledge of C#. (see this blog post as a starting point)

    Or you could go for a low-code solution like PowerApps.

    Because the app is hosted in Azure, you can control other Azure resources with low effort.

  2. Umair Akhtar 41 Reputation points
    2022-10-01T17:25:25.473+00:00

    I have created a dashoboard using PowerApp. I chose Azure SQL as database before deciding to choose PowerApp for front end. Now I have two challenges.

    1) I have 'start', 'pause' & 'end' button in the powerapp which controls the switch on/off process (Start sending device to cloud message & get logged in the database). I saw youtube tutorial where Azure function is used with power automate to control sensor switch on/off. But I am still stuck with this.

    2) Client has only 443 port open while azure sql DB operate on 1433. I planned to use SQL server management studio but blocked 1433 port is major hurdle. Other option is to choose other database as output for stream analytics which is cosmos DB or PostgreSQL which is in preview I think. Also I have to access chosen database from PowerApp which supports Azure SQL DB & PostgreSQL but if Port 1433 is blocked. Would I be able to access it in PowerApp & If not, then What is suitable output option for stream analytics.

    Customer wants to save data in sharepoint to have access to report . But When user input job details. I want to save in Database/storage I choose in stream analytics output as well. One table filled sensor data & other table with user input & create another table which combines these two & use it for historical analysis & report creation. This is apart from sharepoint lists. Price is also in consideration as only less than 50,000 messages produced in a day.

    So what database/storage to choose? which can be populated from PowerApp & support ASA output. Next what is suitable option to start or end thd logging process? switch on/off sensor or control logging process in database or other azure service in the solution?