Skip to main content

Connector

To configure the connector, from the Project Explorer select Connect, Connectors.

  1. Click Add

  2. Select Database (time series), Historical values (narrow)

  3. Click OK

    image3.png

Primary Database

This defines a connection to the database where the report data is located. A browse button […] is provided to define. If there are issues connecting to the database, please refer to the section in the Database Connectors document on the specific database.

Table

The table or view that contains the data. Note, only one table or view may be selected so if the data is in multiple tables a view will be required in the database to join tables together into a single entity.

Rows

The column that contains the timestamp for each record. If the date and time are in the same columns, check Date includes Time.

Columns

This setting depends on whether the narrow Table contains a tag name or tag index column.

  • Tag Name

    Set the Columns to the name of the column representing the tag name and uncheck Tags in a Separate Table

  • Tag Index

    Set the Columns to the name of the column representing the tag index and check Tags in a Separate Table. Click the button to open the Tag Table Settings.

    image4.png

Select the Table and the Columns that provide the relationship between the tag Name and Index.

Values

The column that contains the values e.g., Value.

Settings

See the Historical Values (wide) section for more information.

In this section: