Configuring the Optimized Database Source block

Properties

Data Source:

The data source provider for the Optimized Database.

Click here for an example on setting up a Data Link source to SQL Server >>

Fields Table:

The table containing the field or tag names

Values Table:

The table containing the field values, timestamps and qualities.

Execution mode:

This value must always be set to Historical!

Imported timestamp reference:

Possible values for this property are:

Local – All timestamps will be in local time.
UTC – All timestamps will be in UTC time, taking into consideration Daylight Saving Time.

Blueprints executing in the Server Manager are unaffected by a changeover to Daylight Saving Time. However, blueprints containing this block must have the “Imported timestamp reference” values set to UTC.

Import Options:

The following values can be set for this option:

Use all data:

All available data will be imported from the values table
Use and hold last available value:

The last (latest) known value will be loaded for each selected field
Use only data in this time window:

Allows the user to specify a window start and end time for loading data. All data in the window will be loaded.
Use the latest data available:

Allows the user to specify a duration. All data from the current system time minus the duration will be loaded.

Window Start:

Sets the window start time for the "Use only data in this time window" option

Window End:

Sets the window end time for the "Use only data in this time window" option

Duration:

Sets the duration for the "Use the latest data available" option

Configuring Blueprint Execution Schedules:

Blueprint execution rates are determined by the individual source blocks contained in a blueprint and their respective configuration options.

You can use the First execute configuration options available on most source blocks to configure the timestamp for the first execution of the blueprint. For more information, see Configuring Blueprint Execution Schedules.

Select TAB

Select the fields you wish to import from the specified data set and set the data types. Five data types are supported:

String (S)
Double (D)
Integer (I)
Timestamp (T)
Quality (Q)

Convert between these data types by selecting the required fields from the list and clicking on the conversion buttons provided. Only valid conversions are supported.

Click Refresh to refresh the field list if property changes have been made.

Preview TAB

Provides a sample preview of the data set as read using the currently specified properties.

Return to top