In order to use the j5 Wonderware Historian interface, a database connection to the Wonderware Historian database first needs to be set up within j5.
This can be done by configuring the Wonderware Historian instance as a j5-recognized database in j5 System Management Console. To do this, right-click the Database Configuration folder and select New Database Configuration, and enter the relevant Wonderware Historian database details.
The configured user should have database permissions within SQL Server to access the tables used by the historian. This requires at least SELECT permissions on the History, Live and Tag tables within the Runtime database. For "Summary History" aggregate queries, SELECT permissions are required for the AnalogSummaryHistory.
INSERT permissions are required if there is a need to write data from j5 to the historian. This requires the Autocommit On setting of the Wonderware Historian database connection is set to True.
-
For more information about permissions within SQL Server and Wonderware Historian, refer to the Wonderware Historian Concepts Guide.
-
This configuration also allows historian data to be queried using SQL Statements in IndustraForms. For more information about using SQL statements within IndustraForms, refer to IndustraForm Data Wizardry.