The event also records the source mobile phone number as the DataTypeKey field ( ie the Primary Key). The JSON event being generated by the mobile phone app is intentionally very simple.Īt pace the mobile phone app can send 20 events/second registering the X, Y, Z and G of the device in that instant. Yeah, its still in a bit of development, however the interface is simple, effective and elegant ( pft! of course)! This is a screenshot of the Windows 10 Mobile Phone App which sits on the mobile device and generates the JSON events. To set the scene, I will briefly describe each of the pipeline Azure data services up to the Twilio phone integration point, and then deep dive into the details. To be clear up front – Azure itself does not have native phone capability – so to make outbound phone calls I leverage an external “Twilio” API from within an Azure Function, and “Twilio” connects the outbound call.Īnd so, lets see the Twilio phone setup and c# Function code in action! However the part of the demo that received the most interest was the external phone call integration with Azure Functions. The entire demo solution is actually really interesting (tsk, of course!) – and I will blog about other separate parts of this presentation at some point later. Azure Event Hub + Azure Function (AF) (for queuing events which have a G Force reading greater than 3 and then triggering a phone call back to the original device from which the event originated).Azure SQL Database (ASDB) (for tabular storage of all event data).Power BI (for a live dashboard of all event data).Azure Blob Storage (for archive of all event data).An Azure Stream Analytics (ASA) job that queries the Event Hub and routes the event data to several outputs, including….An Azure IoT Hub (AIH) which accepts the JSON events posted from the mobile device.A mobile phone app which generates JSON events with the X, Y, Z location of the device and G (g-force) detected in the device during movement.The solution had several key components and stages outlined in the architecture below. If interested the presentation deck is here – SSUG Melbourne – Building Streaming Data Pipelines Using Azure Cloud Services Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing Streaming Data Pipelines Using Azure Data Services and as such wanted to build a compelling Azure demo that worked with simple streaming data which under certain event conditions would trigger an outbound phone call.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |