Wonderware (AVEVA) historian to Canary? Options?

Forum / Questions & Answers

SCADA/Automation Dude
drickerson
3 yrs ago
5replies

I've been tasked with collecting Wonderware Galaxy Objects' process values into Canary via a Wonderware/AVEVA historian data source.

I know the AVEVA historian has a SQL interface, but I suspect that the throughput of current value SQL queries through a linked server wrapper will have bandwidth limitations.

Has anyone here connected to a Wonderware Galaxy before?
What methods have you seen utilized?
Has there been a neat API trick utilized perhaps?
I'm looking for a bag of tricks to try.

Thanks,

- smason
- 3 yrs ago
- Reported - view
Hi drickerson

I reached out to one of our partners who has worked with WW and according to him, WW has a product called OI Gateway that exposes Galaxy Tags via OPC. That will be all the values, but not the Metadata like TrendLo, TrendHi, Description and EngUnits. You would also have to create tags manually should more tags gets added in the Galaxy.

Hope this helps.
- Digital Solutions Manager
  
  salah_munis
  
  3 days ago
  
  Reported - view
  Yes, that approach works when an InTouch for System Platform or a Galaxy is in place. I am trying to check how Canary (as a Tier-2 Historian) can interface with WW Historian (as the Tier-1 Historian) when the OI Gateway is not an option. The OI Gateway exposes Galaxy tags, but not the WW Historian history data.
  
  Using the SQL Collector is possible, but it requires setting up a queue table in WW Historian and populating it with historical records. That means adding triggers inside WW Historian and then maintaining that logic. I am also not sure how well that approach would scale in terms of performance, especially with high-frequency live history being written.
  
  Does the Canary SQL Collector support querying a table directly without purging it? Or are there any other practical methods of interfacing with WW Historian for Tier-2 replication?
- smason
  
  2 days ago
  
  Reported - view
  Hi ,
  
  We use a queue table so we can avoid interfering with production tables which may introduce other issues. Currently, there is no logic within the Collector to not clean up what it has processed.
  
  Our main ways for collecting data are through OPC (DA or UA) and MQTT. Is it possible to get the data without having to go through WW?
- SCADA/Automation Dude
- drickerson
- 3 yrs ago
- Reported - view
I discovered that more recent (2020?) versions of Wonderware Appserver now have an OPC UA service that exposes all of the WW objects and current values.

Do you have any tools that scan OPC UA sources for changes to automatically allow for auto-tag construction?

Manually tagging/instancing a large object set sounds very intensive.
- yudong_zhang
- 1 yr ago
- Reported - view
Hi, I'm almost in the same exact situation as you were. We have different versions of WW (2020 & 2017) at one of our sites, I would like to bring the data into Canary.

I'm wondering if you managed to use the OPC UA service to bridge the connection between WW and Canary? if so, do you mind sharing any insight?

Thank!