Using Ignition With Wonderware/Aveva Historian

What is the best way to directly connect Ignition 8.1 to a Wonderware Historian (WWH) so our engineers and technicians can drag and drop tags from WWH and view historical data. We have a firmly entrenched Wonderware System Platform installation and don’t want to move all that to Ignition - although that might not be a bad idea. I’ve seen several posts about migration but that isn’t what I’m looking for. We want to Ignition to co-exist with WWH and use it, not the internal Ignition historian. We don’t want to rebuild our data acquisition and historian infrastructure. We do want to use Ignition for building mobile screens in Perspective. Any advice?

I’m an absolute noob - been using Ignition about a week now, so this could be something I should already know, so sorry about that. I’m really trying to compare/evaluate how to access WWH: SQL JDBC? OPC-UA? OPC-HDA?

The WWH supports direct SQL access so just make a Microsoft SQL connection to it and write the queries you need to pull the historical trends.

You can use SQL bindings in perspective to get the data you need to feed the charting components.

The difficult part will be mapping tags you have created in Ignition (assuming you have made any) to the Wonderware Historian source.

If you have not made any tags yet. I would suggest you make a specific UDT to capture the data you need:

  1. OPC connection to actual PLC/Field devices.
  2. Tag name for the SQL query to the WWH
  3. SQL tag to grab the WWH data only when the date parameters change. Do not have it be polling all the time or it will flood your database connection with unnecessary queries!

You will find out quickly with Ignition there are many ways to implement a solution. Unlike Wonderware that really has only one path.

Brandon

Thank you for your reply! I’m pretty good at SQL, and I can certainly do that. But I’m looking for a solution where engineers and technicians can do more of a drag and drop of existing tags in something they already see in the Ignition Designer. Writing a query that exposes every single tag in my WWH is something I could do, but is there some other way that could expose my WWH tags automatically to my engineers and techs so they don’t need me to write a new query every time they need something.

Please expand on how they would use these tags.
For animation bindings?
To get historical data?

Yes and yes. I think initially we’d be creating tables and charts of historical data a lot more frequently than we’d be making new HMIs.

Unfortunately there is no “Out of the box” method to do this.

What I would do is make a custom screen that did the query to pull all the WWH tag names and gave your engineers the ability to make new tags for doing HMI bindings on the fly. You could even do queries to get the real-time values out of the WWH if you want.

If you structure your UDT correctly then it would be pretty straightforward to do. You may be better off though just creating all the UDT tags you need up front so that the tags are then available for engineers and operators to choose from to create tables and charts as needed.

FYI. What you are going to find is that it all really comes down to having tags before you can do much of anything else in Ignition.

Sounds like someone needs to write a WWH tag and history provider module…

[/ducks and runs]

2 Likes

Does WWH support OPC HDA access?

Not directly. I’m trying to get the Integration Objects OPC DA & HDA Interface
for databases up and running now. It is supposed to be able to do that.

I think using the OPC COM module (and/or whatever licensing makes HDA connections available) is your only real option to get historical data aside from writing your own queries.

Similarly, if you need realtime data, an OPC UA or OPC Classic connection are your best options.

Thank you Kevin! That confirms I’m on the right track for what I hope to accomplish.

Does WW put the data into a single ‘wide’ table?
As of 8.1. you might be able to use ‘DB Table Historian Provider’:
https://docs.inductiveautomation.com/display/DOC81/DB+Table+Historian+Provider

Thank you for your reply! I should probably build a few tag sets (for lack of a better term) using the SQL interface to WWH.

I’d like to thank everyone for their prompt replies and valuable suggestions! Kudos to the forum. :slight_smile: I’ve discovered that any flavor of OPC other than UA is windows only, and obsolete. So no need for me to look there any more. I plan to further explore wide queries with the DB Table Historian Provider (thanks @PGriffith, I’m sure I could get this to work), OPC UA (thanks @Kevin.Herron), and UDT (thanks @brandon1).

2 Likes

@claude.hager … did you ever finish this? It is exactly what I’m looking for, too … can you put it up in the Exchange?

Good morning! We did not, although we are still very interested in exposing Wonderware Historian as a Historical Tag Source by some means. Right now I’m generating wide queries w/ SQL and then parsing out the individual tags into memory tags. Obviously that is non-browsable by our engineers and techs. :frowning: I am continuing to look into these 3 options:

Please let me know what you find out.

I’m using the DB Table Historian approach … and I’ve hit a snag … when I bind to the WWHistorian, it says that the keycolumn must be of integer type. So I was going to use the wwTagKey column. But … the “table” History in the WW HIstorian has a requirement (InSQL) that I use a valid TagName list … so I need more complicated WHERE clause … not sure how to do that