Sign in

Data Source - Wonderware Historian

Wonderware Historian is a high-performance real-time database for historical information. It combines the power and flexibility of a standard SQL relational database with the speed and compression of a true process Historian, integrating the office and enterprise with the factory floor or any industrial operation.

To create a connection to the Wonderware Historian Data Source: Right-click on the Data Sources group, then click “Wonderware”, and then select “Historian”.

DataSources-ConnectWWHistorian.png

To successfully retrieve data from a Wonderware Historian data source, the following properties need to be set.

DataSources-SetWWProperties.png

  • Name (String)
 Name to identify the data source.
  • Server (String)
 Location of the Wonderware Historian Runtime Database (Server Name or IP Address).
  • Database (String)
 Name of the Runtime database, default Runtime.
  • Username (String)
 Oracle authentication username. If left blank, Windows authentication will be used.
  • Password (String)
 Oracle authentication password. If left blank, Windows authentication will be used.
  • Maximum Concurrent (Int)
 Maximum pooling count size for the Oracle connection, default 100.
   
Note: This connector supports Wonderware Historians versions earlier than the 2017 release.

It is also required to install the relevant Historian Toolkit to connect to a Wonderware Historian.

Wonderware Historian 2017

Wonderware Historian is a high-performance real-time database for historical information. It combines the power and flexibility of a standard SQL relational database with the speed and compression of a true process Historian, integrating the office and enterprise with the factory floor or any industrial operation.

This is the latest version of their Historian that changed the way that data is retrieved from the Historian back end, thus the need for a completely separate connector.

If a Flow project exists with measures configured with the previous version of the Wonderware Data Source, and the Wonderware Historian had been upgraded to the 2017 version, the old data source can be migrated to the new connector by a right-click command on the connector and select the “Migrate” option.

All Wonderware Historian 2017 data sources will be available for selection to migrate to.

DataSources-MigrateWWHistorian.png

To create a connection to the Wonderware Historian Data Source. Right-click on the Data Sources group, then click “Wonderware”, and then select “Historian 2017”.

DataSources-Historian2017.png

To successfully retrieve data from a Wonderware Historian 2017 data source, the following properties need to be set.

DataSources-Historian2017Properties.png

  • Name (String)
 Name to identify the data source.
  • Server (String)
 Location of the Wonderware Historian Runtime Database (Server Name or IP Address).
  • Database (String)
 Name of the Runtime database, default Runtime.
  • Username (String)
 Oracle authentication username. If left blank, Windows authentication will be used.
  • Password (String)
 Oracle authentication password. If left blank, Windows authentication will be used.
  • Delink From Template
 Maximum Concurrent (Int.
   
Note: This connector supports Wonderware Historian's versions 2017 and up. It is also required to install the relevant Historian Toolkit to connect to a Wonderware Historian. (2017 SDK). Flow does have an option to convert the “old” Wonderware connector to the 2017 version if an upgrade had been preformed on the Historian. Right click on the old connector to convert it to the new 2017 version.