Skip to content

RT Datalogger and DB type

Alberto Vietri PxC ItalyAlberto Vietri PxC Italy
edited March 2020 in PLCnext Technology & PLCnext Controls

Hi,

I am using the RT datalogger that store data in a sqlite database, is possibile to store data in another format, like mySQL? I want to use Grafana locally, on the controller, i have intalled it with binaries, but seems that Grafana doesn't accept sqlite database as source database.

I am looking for something to convert the sqlite database but seems a complicated way.

Do you have other suggestions?

Thanks in advance

Comments

  • Martin - PLCnext Technology TeamMartin - PLCnext Technology Team

    Hi Alberto,

    Can Grafana get historical data from an OPC UA server?

    This video demonstrates how to access data from the RT Datalogger via OPC UA using one particular OPC UA client, but the same should be possible from any good OPC UA client.

     

  • Frank Phoenix Contact Deutschland SupportFrank Phoenix Contact Deutschland Support

    Hi Alberto,

    I've spent a few minutes in google and found a few tools (partly commercial) who can do the job.

    As one (and there are many alternatives) I've found a small python script which seems also quite easy to handle.
    I've never used it, but may work for you...

    Also you might try the Sqlite browser, this is an open source tool which can export a sqlite db into a sql compatible format.
    I hope that mySQL can handle it, just give it a try.

    Cu

    Frank

  • Alberto Vietri PxC ItalyAlberto Vietri PxC Italy

    Hi Martin,

    I have seen and tested the reading of RT datalogger via an OPC UA Client, unfortunelly seems that Grafana doesn' accept data from OPC UA, i'll look for other solutions based on OPC UA.

     

    Hi Frank,

    the pyhton script that you have found seems quite simple, I too have been looking for a conversion tool but my intent is to have a simple application, with few steps. The RT Datalogger is quite simple, as is the Grafana installation and its usage, it's a shame to have to add more complicated steps. I'll try the python script and at the same time I'll look for an alternative to Grafana that handles sqlite source.

    Thanks both

  • m256m256
    Hello everybody,

    Maybe too late for Alberto but could be useful for someone else:
    https://grafana.com/grafana/plugins/frser-sqlite-datasource/?tab=installation

    (I haven't personally tested it yet)

    Bye,
    Marcello
Sign In or Register to comment.