Enterprise RTView® 
User Guide

Viewing History Data

Data saved out of the Historian to the history database can be viewed from an Enterprise RTView display if you are licensed for the SQL data source. For step-by-step instructions on viewing and configuring historical data, see Examples>Archiving Data. NOTE: The SQL data source may not be licensed in your Enterprise RTView installation.

To attach an object to historical data you can either:

  • Enable the valueHistoryFlag object property, or
  • Create an SQL data attachment.

If you are using a direct JDBC connection or a password protected ODBC-JDBC bridge connection to communicate with the history database, you will need to configure the history database in the Display Builder. NOTE: The name of the history database must match the Data Source Name specified when you registered your database with ODBC, as well as the Historian Database Name specified in the Historian GUI. To configure the history database in the Display Builder, select Tools>Options>SQL and add a database with the same configuration options used in the Historian. See the SQL Application Options page in the Data Sources section of this documentation for more information.
 
Object Property - valueHistoryFlag   Data Attachment - SQL
The trend graph on the Graphs tab of the Object Palette (class name: obj_trendgraph02) features a trace*ValueHistoryFlag property for each trace. If you select this property, Enterprise RTView will attempt to connect to the history database and load initial data from the Historian for the corresponding trace any time you open a display containing that graph. Only data within the timeRange set on the graph will be loaded and the graph will update as live data becomes available.

To set up a trace to load from the history database, you must have a corresponding object in a history configuration file that the Historian is using. The data attachment in the configuration file must exactly match the data attachment for your trace. The data must not be stored in a user defined table.  Only data stored in the numeric table (HISTORY or the table name you specified) will be used to load historical data into your trace.

 

   Any object in Enterprise RTView can display historical data using an SQL data attachment.

Refer to the History Tables in Historian>Database Setup to find the names of tables and columns in the history database for use in data attachments.

 


 
   

 
Enterprise RTView contains components licensed under the Apache License Version 2.0.

 

Treemap Algorithms v1.0  is used without modifications and licensed by MPL Version 1.1. Copyright © 2001 University of Maryland, College Park, MD

 

Datejs is licensed under MIT. Copyright © Coolite Inc.

 

JCalendar 1.3.2 is licensed under LGPL. Copyright © Kai Toedter.

 

jQuery is licensed under MIT. Copyright © John Resig,

 
JMS, JMX and Java are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. They are mentioned in this document for identification purposes only. 

 
SL, SL-GMS, GMS, Enterprise RTView, SL Corporation, and the SL logo are trademarks or registered trademarks of Sherrill-Lubinski Corporation in the United States and other countries. Copyright © 1998-2009 Sherrill-Lubinski Corporation. All Rights Reserved.