Hi All!
I'm using Arduino Cloud to capture information from various sensors and display it on a dashboard. Recently, I’ve discovered ways to stream the data and manipulate it more comfortably; however, I don’t fully understand the requirements to do this.
By linking through a webhook, I’m able to acquire the data instantly every time a value is received by Arduino Cloud — this real-time functionality is exactly what I need. I saw the available Webhook options, but I don't fully understand how each one can help me manipulate the data so it can later be stored in an SQL database, which will be queried in Power BI in the future.
My goal is to have data synchronization between Arduino Cloud and my final database (Power BI), and for everything to stay in the cloud — without needing a Python script or any other code running locally to perform these tasks.
I explored the option of using Render to host the Python client code and write to SQL every X minutes, but Arduino Cloud doesn’t accept Render as a webhook destination, so that made the process more complicated for me.
My skills are in C++, Python, and SQL. I’m open to exploring other options, but I’d prefer to stay within these boundaries. I’ve worked with Node-RED before, but I’m not sure if there’s a way to run it continuously in the cloud without requiring something local.
Do you have any suggestions for a better way to manage this data flow? Thank you.