Hi all,
I have a customer who wants a recipe management system integrated on one of their production lines, and they would like it set up in their existing SQL databases. SQL is a fairly new beast to me, but thanks to their very helpful IT guys I'm learning as much as I can
Just wondering what people's thoughts are on the best way to get the data back and forth? Their setup is currently:
- ControlLogix PLC's as central line control PLC's, with ENBT for communication
- CompactLogix PLC's on individual machines
- FTView SE Network Distributed SCADA system
- FTView SE Historian
I don't need to be logging and timestamping values, basically all I need to do is set up a recipe structure to have things like:
Recipe Name (string)
Product 1...n weight
Conveyor 1...n speed
Temperature SP
Weight SP
etc.
They'll need to be able to view, create and modify recipe data using the FTView SE system. Then I just need to be able to call for "recipe ABC" and have all the recipe parameters be loaded from the SQL database into the CLX to run the day's production. A couple of the parameters may need to be loaded into individual machine PLC's, but worst case I can just send setpoint information via comms from the central Control Logix.
Is it possible to do this using the existing FTView SE setup? Can FTView SE natively go to and from an SQL database, or do I need to use something like Transaction Manager?
Any suggestions or experiences are appreciated. As they've gone to great effort to keep everything as AB so far, they're going to want to keep it that way here. But to be honest I'll probably be able to sell a different solution to them as long as I can promise it's bullet proof.
Thanks!
I have a customer who wants a recipe management system integrated on one of their production lines, and they would like it set up in their existing SQL databases. SQL is a fairly new beast to me, but thanks to their very helpful IT guys I'm learning as much as I can
Just wondering what people's thoughts are on the best way to get the data back and forth? Their setup is currently:
- ControlLogix PLC's as central line control PLC's, with ENBT for communication
- CompactLogix PLC's on individual machines
- FTView SE Network Distributed SCADA system
- FTView SE Historian
I don't need to be logging and timestamping values, basically all I need to do is set up a recipe structure to have things like:
Recipe Name (string)
Product 1...n weight
Conveyor 1...n speed
Temperature SP
Weight SP
etc.
They'll need to be able to view, create and modify recipe data using the FTView SE system. Then I just need to be able to call for "recipe ABC" and have all the recipe parameters be loaded from the SQL database into the CLX to run the day's production. A couple of the parameters may need to be loaded into individual machine PLC's, but worst case I can just send setpoint information via comms from the central Control Logix.
Is it possible to do this using the existing FTView SE setup? Can FTView SE natively go to and from an SQL database, or do I need to use something like Transaction Manager?
Any suggestions or experiences are appreciated. As they've gone to great effort to keep everything as AB so far, they're going to want to keep it that way here. But to be honest I'll probably be able to sell a different solution to them as long as I can promise it's bullet proof.
Thanks!