I have several sensors reporting data through a cellular router to Soracom. The sensor data is rather basic: temp, humidity and particulate matter. I would like to have a website (other than Soracom) that a client can log into their client portal and visually see just their sensor data. I would also like to have the ability for the customer to create a report based on a selected date range that would generate a pdf report of the data collected over that time period. The pdf report would be a template that pulls data from a database or wherever the data is stored.
Here is my issue - I don't know how to get the data that is currently being reported to Soracom to the the finish line of generating a report. For my own personal use I have built a visualization dashboard within Soracom for me to monitor (uses a stripped down version of Grafana) but now I need to have the ability for a client to see their data and generate a report, preferably without giving them access to Soracom. Do I need a web developer to do this through API? Do I need to send it to AWS or another location? Do I need to set up a database? SQL or NoSQL? Do I even need Soracom? I just don't know what my next step is to make this happen.
This post is not intended to be a search for a specific person to actually do this but rather for guidance on what my next step of research should be about. If anyone has any ideas on the best way to get the data from the sensors in the field to a client portal on a website I would be very interested in your thoughts.
Thank you for you time,