I would like to send data from tags on the PLC to an SQL database using a stand alone application well suited to handle this solely.
Currently I use Wonderware's bind list to link tags to Fields in the SQL database. I would like to find something that stands on its own and does the same thing. I don't like tying up the Wonderware appliction with this communication transfer if I don't have to. It not only slows the Wonderware application, but adds to its complexity. Does any one have any ideas?

 

If your SQL app can accept ActiveX, check out SMRX at "www.sapia-inc.com":http://www.sapia-inc.com

 

You could look at Webdock "www.webdock.com":http://www.webdock.com or RSSQL from Rockwell. I have tried webdock and it is a nice option, RSSQL will give you the ability to write back to the PLC.

 

People also use InControl to get data out and/or into the plc to a DB. Because InControl is an ActiveX container, a normal ADO can be used. You can then use the properties to do any manupilation. So InControl can get the data out of ther PLC and from there you are free. Because you use Wonderware, the changes are good that you already have a InControl license.
Let me know then I can send you a Example app.

 

Two thoughts....
1) RSSQL (as the other fella suggested) is a 'quick' solution. It's starting list is $1500 and even though Rockwell makes it, all you'd need is an OPC Server to go between RSSQL and your brand of PLC. This way you can pump data into and out of your database/PLC's.

2) Another method is OPC Automation. I've used this to talk w/ AB controllers via RSLinx. It's object model/dll interface comes with most RSLinx packages. This way you can interface w/ your database in VB/VBA/C++ and customize as you choose. Cheapest RSLinx supporting this is $400.

 

WebDock's DataPort software is free for the 150 data point version.

 

Two thoughts....
1) RSSQL (as the other fella suggested) is a 'quick' solution. It's starting list is $1500 and even though Rockwell makes it, all you'd need is an OPC Server to go between RSSQL and your brand of PLC. This way you can pump data into and out of your database/PLC's.

2) Another method is OPC Automation. I've used this to talk w/ AB controllers via RSLinx. It's object model/dll interface comes with most RSLinx packages. This way you can interface w/ your database in VB/VBA/C++ and customize as you choose. Cheapest RSLinx supporting this is $400.

Hi Anonymous, could you send me an e _ma_il to naborcuestas at gmail. Wondering if you could share information on OPC Automation method to write to database. Thanks