Owning my own (HA) data

Hi All,

I work in Business Intelligence and own a home with just a few HA devices. I want to get to a point where I own my own data. Generally speaking, is there any recommendations in this regard?

For my setup specifically, this is what I want (at this moment):

• Thermostat (Emerson Sensi) - ideally, I want to store the room temperature, heat/cool state, thermostat temperature (cool to 25c, heat to 19c, etc.), run times, start/stop datetimestamps ets. (anything that I can get really)
• SmartLife Temperature sensor - temperature/humidity data throughout the day (hourly?)
• SmartLife Smart Plug - electricity usage, on/off, datetimestamps, etc.
• DLink Smart Camera - video footage, datetime stamps of activity (if any)
• Ring Video Doorbell - video footage, datetimestamps of activity
• Alexa devices - datetimestamps of routines run, and any other data I can get my hands on

I have a virtual server (hypervisor) with several Linux VM's. I have some coding/scripting skills in Python and other languages. I also have some reporting infrastructure (db server, gateway, power BI licenses, etc.) and want to run my own analyses on these data eventually.

I know this has become a novel, but I'm aware that its hard to get video out of Ring and DLink, so if someone has gotten it working GREAT! but I'm not holding my breath. I also think that the sensi might have something but I'm sure it's limited.

Does anyone have any thoughts?

Submitted by roblu001

Comment Below