ok the reason I am asking all this is to see if you can put another broker in the middle that also reads the data and pushes it to a database instead of trying to read this tps old school non common database.
the broker in the middle can parse the data coming down the wire and push it to anything you want: mysql, postres, etc.
the json extraction approach is basically that but post ingestion into tps hence the 30 min wait. 30 min wait might not be ok in some instances, might be good for you.
do you have any python or some other scripting skills? or maybe node red can sit in the middle as broker and sniff the data coming. so you will (should) have identical data in tps and this other database.
1 Like
To be honest i only got my grafana working 2 weeks ago. I was intredused to grafana 2 years aga. and i could not understand the smtp exporter, the .yml file ext. to say i do not know how to code. i do follow tutorials.
i also had the idee of putting some thing in between. well if i can create my own encoders. i wane to try and put a middle man on the hardware ( just a thought) but i do not know were to start.
al most like a listning server.
1 Like
so there is smtp involved in the data generators?
1 Like
I am sorry for the delay, as the form prevented me from replay for 16H
No the is no smtp in the data generators.
i can make a small example on how i receive a raw data.
33521E120P01C138 This is what the Raw data looks like. In my DB there is like a pre define set of data as to what is what.
I can brake all of them down.
33521-----Radio code
E120 ------- Event Panic Received ( If R120 is received it means it has restore)
P01 ---------- Partition 1 ( Different Partition 1 up to 8)
U138 --------- User Remote Panic U= User C= Zone number)
1 Like
on the server to where the radioa connect via com, can you write for ex python code to read data from com?
Good day. I am busy with the developer of the Application and i did ask for piggyback of the encoder so i can send it to my own Database. im not sure yet what database to use…
mysql or postgres is fine imo
1 Like
I have sent a request to my dev and asked if it is possible to have a piggyback on the encoder to my own DB. i will wait and see when he responds back and i will update.
