Configuring the Discrete Optimized DB 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.

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

Create Index

If enabled, the source will create a new unique index for every row of data read from the source. The index will be incremented on every execute. The starting value is determined by the Index Start Value property.

Index Starting value

The starting value for the index if the Create Index property is enabled.

Index Field

If the Create Index property is disabled, select a field from the data source to use as the index field. Indexes do not have to be unique.

Select TAB

Select the fields you wish to import from the specified data set and set the data types. Five data types are supported and interpreted as either Discrete or Continuous when read:

String (S) - Discrete
Double (D) - Continuous
Integer (I) - Continuous or Discrete (Conversion allowed)
Timestamp (T) - Timestamp or Discrete (Conversion allowed)
Quality (Q) - Discrete or Continuous (Conversion allowed)

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