Overview

For database tables containing timestamped records, XLReporter provides specialized connectors that provide all the functionality usually found in a historian such as aggregating and tag browsing without the user needing to formulate SQL statements.

In Data Connectors, expand the Database (time series:

As a pre-requisite for this connector, there needs to be a column (s) representing the data and time.

Normally, time series data is recorded in a wide format where each column represents the process data or in a narrow format where the process data is recorded in a single column.