Configuring the Discrete Tabular Database Source block

Properties

Data Source

Use the Data Link Wizard to setup a connection to the database. Show me how>>

Table

Select the table or view you wish to connect to from the drop-down list

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.

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.