Jump to content

Remote SQL Query


Recommended Posts

  • MVP 2014

Hi Neels,

UniStream is only an SQL client.  I'm not aware of situations where an SQL client can respond to requests.  I have done some quick google searches and there are situaitons where two SQL systems are set up as master and slave where they can request data from each other, but in those cases both master and slave are both SQL servers, and the purpose is to keep backup copies of data.

Just another thought, if the customer installed MQTT broker and client software on their SQL server, they should (?) be able to set up the MQTT client as a subscriber to the MQTT data, and it would push new data to the SQL databse.  The PLC would only publish data as it was relevant, which would optimise the data flow to the main SQL database.  There should be controllability on the update rate at both the subscriber end as well as the publisher end. 

Going back to the idea of the UniStream connecting directly to the main SQL databse, It is possible to set the PLC to only push data to the SQL server on change of state.  Maybe the server could send an SNMP packet to the UniStream that would trigger an SQL push?

As I said, just some thoughts, based on general principles and completely un-tested...



  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...