martinav (Customer) asked a question.

May 20, 2021 at 7:11 PM
Getting data from BRX to my server... many workable possibilities.

Well, my program is working, despite it being a little not quite perfect. To really put the finishing touches on this, I would really like to find a way to push my data from the BRX to my server. I will be accessing the data through power automate. There are MANY avenues to do this, so I am not focused on one specific way. The only method I know I can do is via the FTPPUT/FTPGET instructions. However, on the server side, my way to get to the data automatically would take too long to be practical. So, I would love to find a way to use some other method that could push my data directly into an SQL table, or Sharepoint, etc. But, I'm not limited to those destinations. They are just two that would work very well on the server side.

 

Has anyone done this or something similar?? I would be very interested to know how you did it.

 

Thanks!

 

Rod

  • 10 answers
  • 578 views

  • Garry (Customer)

    Hi martinav,

    I recently did a post using Node-RED to store information into a SQL database table directly.

    https://accautomation.ca/node-red-sql-database-log-modbus-logging/

    This uses Modbus TCP (Click PLC) and Modbus RTU (Solo Temperature Controller) from Node-RED.

    SQLite database is used for storage.

    On the BRX controller, you could use Modbus TCP or MQTT with an external broker.

    Here is a link to the entire series.

    https://accautomation.ca/series/node-red-iot-enabling-software/

     

    As you mentioned above FTPPUT/FTPGET instructions can also be used.

    https://accautomation.ca/brx-do-more-plc-ftp-client-get-put/

     

    I hope this helps you out.

    Regards,

    Garry

     

    https://accautomation.ca/series/brx-do-more-plc/

    Expand Post

  • martinav (Customer)

    On sweet!!! I'll go there...

  • martinav (Customer)

    Oh wow... thats very involved. I'm good on the SQL side. Looks like a ton of stuff to sort out to connect to modbus. It looks like Node-RED is open source??? No licensing fees?

     

    I would also need to install this on Windows Server. Looks like I have a lot to figure out with this.

     

    Rod

    • Garry (Customer)

      Node-RED is open-sourced. No Fees. The example shows reading and writing using Node-RED Modbus TCP and RTU. (Yes it looks involved, but just study the flow.)

      The series will take you through installing Node-RED on windows, Modbus Communication, Dashboard User Interface, Logging to a SQL Database, and finally viewing the data on a spreadsheet. (Still to be released)

      Regards,

      Garry

       

       

      Expand Post

  • HOST_BobO (AutomationDirect)

    You could also use HTTPCMD to send commands to a REST API interface on SQL.​

  • martinav (Customer)

    I'm definitely fine with JSON. I am looking for a little less complex method of transport between PLC and SQL. I like the idea of not being tied to modbus also. Modbus seems to have some complications, such as text. I will look into node-red and HTTP node and see how far i get.

     

    Thanks!

    Rod

  • martinav (Customer)

    Trying to get Node-Red docker installed on my server. Sent a request to IT. I messed with it a bit on my server at home. Seems usable.

 

Did this information resolve your issue?