Using online database for Windows Client app and Mobile apps

Category: azure database for mysql

Question

Vikrant_Agrahari on Fri, 13 Sep 2019 13:39:00


Hello there,

I am developing software which is on Windows PC. The software inserts into the Azure Cloud SQL database. And I want to get the updated data on mobile apps (android and iOS). If possible, I want to have the notification on mobile apps on every new data entry on the cloud database.

Regarding my question, I am confused about what kind of Azure cloud service should I use since I am very new to this field?

Your help will be appreciated.

With Thanks,

Vikrant 

Replies

NavtejSaini-MSFT on Fri, 13 Sep 2019 14:31:26


Hi Vikrant

You can possibly use the Azure Logic Apps which has different connectors for Azure Services. You connect with Azure SQL and logic apps and once a row is inserted to DB, it will trigger a logic app job and you use it to send notifications.
Please find more information here.

You can also use Azure functions to achieve this. Read more about this here.

You can also refer following links for more information.

https://azure.microsoft.com/en-us/resources/templates/201-alert-to-text-message-with-logic-app/
https://www.sqlshack.com/configuring-email-notifications-in-azure-sql-database/

Hope this helps.

Thanks
Navtej S

NavtejSaini-MSFT on Mon, 16 Sep 2019 14:58:20


Hi

The last answer has been proposed as an answer. Please mark it as an answer if this has helped you or get back to us with more questions.

Thanks
Navtej S