OPC to SQL tags and values
Hello Sir,
Query is:
We want our Tags and values on SQL Server. Previously we were thinking to fetch it directly from SCADA, but later discussing with our ABB support we came to know that our Compct HMI has its own database, and thus cant be fetched directly on SQL server.
Thus need to use some Tool/software for fetching Data through OPC, and then feeding it on SQL alongwith values too.
So, can you please suggest me , if there is any such recommended/trustworthy tool for this purpose.
Also if possible , the download link for it.
Thanks in advance !!
Voted best answer
"We want our Tags and values on SQL Server."
Thats a pretty broad statement. How many tags ? What sort of data ( eg current values or history ) ? Do you want the data in an SQL database or do you just want to be able to pull data from 800xA using an SQL interface ?
Check the "System 800xA Configuration" manual( 3BDS011222 ) section 2 - Data access. The 800xA can supply real time data as either an OPC data source or an OLE-DB data source. Depending on your SQL database you may be able to access the data directly or you may need some interface layer to convert OLE-DB to ODBC.
If you want to retrieve and store process data using OPC then again, a quick google search will give you a list of possible solutions, like this one http://www.opcdatahub.com/Docs/dho-logging.html
You can also access history directly from 800xA using the included OPC-HDA interface
Be very careful before you decide to store large amounts of real time history in a "home-made" SQL database. The amount of data can rapidly become very large and a database design that works well for a small amount of data can become very inefficient when you try to store and retrieve a few years worth of data.
Answers
Matrikon have a component called OPC Client for ODBC.
Benefits:
- Great for logging data to, or taking data from a relational database
- Single piece of software to configure
- Connects to any OPC Server
- Completely user friendly, easy to use with drop down lists
Add new comment