kmhsystems
Member
Anyone have an example how to do this? OPC server I assume but have never done this. What would I need.
Thanks for any help.
Thanks for any help.
ControlLogix Read/Write to SQL
- Thread starter kmhsystems
- Start date
You can't do this directly from the PLC, you need something to handle the exchange.
A hardware solution like this is a rack module:
http://www.softing.us/product/1/eatm-tmanager/
Or if you have some type of SCADA software you typically can write a script to connect to the database through an ODBC connection and do what you need.
There are plenty of dedicated software solutions as well. Kepware, FT Transaction Manager, Ignition SQL Bridge...etc
A hardware solution like this is a rack module:
http://www.softing.us/product/1/eatm-tmanager/
Or if you have some type of SCADA software you typically can write a script to connect to the database through an ODBC connection and do what you need.
There are plenty of dedicated software solutions as well. Kepware, FT Transaction Manager, Ignition SQL Bridge...etc
curlyandshemp
Lifetime Supporting Member
Inductive Automation's Ignition
JordanCClark
Lifetime Supporting Member
Before this thread goes to a Wonderwave v. Ignition. v. Citech. v. [Insert Name Here] comparison (and possible fisticuffs 
), take a look at this thread. Especially my two posts at #20 and #21. Not because I have a vested interest in any of the packages mentioned, I just write good stuff.
And, if this is the KMH I'm thinking of (based on location), will this be a turnkey system? If so, then my last post there will definitely be geared toward your customer as well.
), take a look at this thread. Especially my two posts at #20 and #21. Not because I have a vested interest in any of the packages mentioned, I just write good stuff. And, if this is the KMH I'm thinking of (based on location), will this be a turnkey system? If so, then my last post there will definitely be geared toward your customer as well.
phuz
Member
Yes you can. In fact I was just going to create a new thread for this asking if anyone had any progress in doing this on their own?
There is a company that sells a package (including AOI) that does this.
http://www.sql4automation.com/en/fe...ase-connector-plc-rockwell-allen-bradley.html
JordanCClark
Lifetime Supporting Member
There's an appliance that sits between the PLC and the database. Still a neat idea, though.
EDIT: I'm gonna retract that for a moment. There's some conflicting stuff I'm seeing. I'll take a closer look...
Last edited:
TheWaterboy
Lifetime Supporting Member + Moderator
Kepware Datalogger
phuz
Member
Yeah, I think you are right.
Initially I thought this was just an AOI that wrote direct to the SQL DB, which I thought was awesome. This software is doing nothing more than the software I have already written.....acting as a gateway between PLC and SQL.
JordanCClark
Lifetime Supporting Member
Okay, after reading the manual, the SQL is handles by a connector installed on a PC. The PLC talks to the connector, the connector talks to the database. You can also buy an appliance (that's where my confusion was coming in) with the connector pre-installed.
EDIT: Phuz, you were too quick for me!
EDIT: Phuz, you were too quick for me!
TheWaterboy
Lifetime Supporting Member + Moderator
I saw a company at AF that made an I/O module for just this purpose. It was pricey... Cant recall the name though...
Edit: Paully got it,. Softing
Edit: Paully got it,. Softing
I went through this process a while back, and ended up narrowing it down to the Softing eATM module, or Inductive SQL Bridge. I quoted both and it looks like we'll be going with the eATM module, but things aren't moving hugely fast there at the moment.
Archie
Member
I recently received a note from a long time AdvancedHMI user telling me how he developed an AdvancedHMI application that reads data from a ControlLogix and stores it to a SQL Server. There is nothing spectacular about doing this except that he has it running on the Raspberry Pi Zero (the $5 computer)!
JordanCClark
Lifetime Supporting Member
Gotta say, that's just cool! And kinda jealous he got his hands on a Pi Zero.
Similar Topics
Hello,
I inherited a control system one of my predecessors thought it was a good idea to put logic for cant optimization and Kinetix motion...
Hello, I am currently converting a project from PLC5 to ControlLogix. I have migrated the program from Logix5 to Logix5000 and any Block Transfer...
When using multiple controller systems I used to using either produced/consumed tags or messaging functions to transfer data between controllers...
I am sure there are people out there who use Excel to transfer data to and from a ControlLogix using DDE via custom VBA code. For those of you...
Hi all, I need to write program to read/write data between SLC500 and Controllogix via enthernet, For my knoledge, it can use MSG instruction, but...