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?