Hi,
We are developing energy management platform and we have decided to use IotaWatt.
As per IotaWatt, it has only 3 data uploader options (EmonCMS, InfluxDB, PVOutput). My question is that how can I download or access the live data from IotaWatt to our company database? Is there any option for that? or how can we see our company database name in ‘Data Uploader’ section?
Thanks
You would need to be more specific about what data you want to transfer to your company database,the granularity needed, and the database technology that you use. IoTaWatt maintains internal datalogs at 5 second granularity. To transfer that you would probably need an uploader. If you only want say 1 minute or less data, you could pull it using the query api.
IoTaWatt is open source, so you could add an uploader for your specific needs. There is a base class (C++) that facilitates that.
I use the Query API to pull my data at the 5 sec interval and import to my local SQL Server. I use a batch job that runs every 5 mins which pulls 60 records and does not cause any noticeable strain on the system. The Query API is very straight forward
Here’s a snap from my log - shows most of the Query I’m using
I added a little bit of code around the core query to check dates between IotaWatt data and the database and do multiple runs of 360 records (you can limit the number of records pulled per query) within the 5 mins if things get behind. This happened once when I lost connection for a day but this caught the data up in short order. Works great and have been running for over 1.5yrs with no issues.
I must say, 5sec granularity is really way more than is needed - but I’m too lazy to change my code at this point.
1 Like