SQL Query From Rockwell Control / CompactLogix CPU

[AF52]

Good Evening,

I'm loading a recipe into a Rockwell ControlLogix or CompactLogix CPU via Excel, this is all working fine. Is there anyway I can check the "Batch_Number" tag against a SQL database to see if its been used previously?
So, in summary, can I query a SQL database direct from my CPU? and if so please can you assist me.

Thanks in advance,
AF52.

 

[parky]

I don't know of a way to use a compact logix to query a DB, not unless it has some form of PC card with one of the most popular laguages on it.
Can you not use Excel to do the query, for example if you are sending a recipe via Excel is the batch number in Excel before you send it. Excel VBa can query SQL databases.

 

[AF52]

Thanks for the quick reply.
Yes I can do that with the initial query in Excel. The only drawback to that is if the same recipe is selected to run again at the end of the batch. I have code in place to increment the batch number, but I want to check it against the database for a secondary check.

 

[parky]

I see your problem, all our batch numbers were uniqueue for example we took the recipe name then the date & then an incremental number i.e. BSB22C
050922 001 (without spaces) so until 050922 (Year 2122) it would not repeat, midnight every day the incremental number was zeroed so would never repeat.

 

[drbitboy]

What type of SQL (MSSQL, MySQL, Postgres, etc.).

It would be involved, but fairly straightforward, to set up an API to wrap the details of the SQL call, so the CompactLogix would use a very simple and limited query/response interface (e.g. Modbus, for which there is an existing Logix AOI, IIRC, or a web API, or OPC, or even E/IP).

The details would depend on your network configuration, but someone with experience could gin up a Python prototype in a couple of hours or so.

But I would wait for more members to see this thread before generating a bespoke solution; this sounds like a problem that has been solved before.

 

[drbitboy]

Try searching for the terms "logix sql query" in the search bar above.


e.g. http://www.plctalk.net/qanda/showthread.php?p=799430#post799430

 

[ASF]

The simple way to do this would be with a tManager module from Softing. They're a Rockwell encompass partner - I've used their Control Logix variant before and it was very straightforward.

Not exactly what you were asking, of course, and they're not cheap - but it would definitely get the job done.

 

[parky]

Not looked into it deeply but a google seach found these
https://www.oldi.com/kbattach/WebDocuments/Brochures/Softing eATM-CLX.pdf

https://coralogix.com/docs/querying-coralogix-with-sql/

There are OPC servers (perhaps Kepware) that will log data to SQL, it might be able to run queries but never tried it.
What ever you do it will need some sort of interface be it a PC, PLC card etc.
So why use Excel if you are going to interface with a DB then why not download recipes from SQL.