Skip to main content

Connector

To configure the connector to AVEVA Historian – Summary Tables, from the Project Explorer select Connect, Connectors.

  1. Click Add

  2. Select AVEVA, AVEVA Historian – Summary Tables

  3. Click OK

image42.png

Primary Server

These settings define the connection to the Microsoft SQL Server database where the AVEVA Historian is configured.

  1. Select the Server Name as the machine name for the Historian.

  2. For Log on to the server, specify the proper authentication.

  3. Leave Database as Runtime.

  4. Click Test Connection to verify connectivity and return to the connector setup.

Secondary Server

These settings define the (optional) secondary AVEVA Historian server to connect to if a connection to the Primary Server fails.

Settings

The Settings button opens the Settings dialog that defines characteristics of the database that are used to retrieve data.

image43.png

Typically, these settings are defaulted correctly based SQL Server.

If queries timeout, increase the Client Wait Time.

The delimiter and timestamp settings are typically filled in automatically for the database and can be modified for other databases.

The Date/Time Storage settings define how timestamps are stored in the database. Using this setting the timestamps are manipulated when data is retrieved so that local timestamps are submitted in and returned.

Many databases require the Date format to be YYYY-MM-DD so that no interpretation needs to occur based on the Region settings of the Windows Operating System. It is recommended to always have this option checked.

In this section: