Configuring the Tabular Database Source block

Properties

NOTE:When you use the Tabular Source block to read data in from a table that contains a DATETIME2 field you must use the “SQL Server Native Client” OLE DB provider for it to be recognized as timestamps. The “Microsoft OLE DB Provider for SQL Server” and “… for ODBC Drivers” will not work (not support by Microsoft) and will recognize DATETIME2 as string.

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

Execution Mode

Select the execution mode:

  • Historical

Execute the block in historical mode.  All data will be read from the database using the time window provided on the property sheet.

  • Real-time

Execute the block in real-time mode.

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 CSense Runtime 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.

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.

Timestamps TAB

Specify the following properties for timestamping options when reading time series data:

Create timestamp

Allow Architect to create a timestamp when importing data

  • Sampling Period:  The sampling frequency required when create timestamp is selected (in seconds).

Default timestamp field

Select a timestamp from the data source provider to be used as the master (or execution) timestamp.  Fields must have the Timestamp data type to appear in this list

Specify individual timestamps by mapping the available timestamps from the Date/Time fields column onto the fields listed in the Configured Fields column.  Fields not mapped use the default timestamp specified.

Quality TAB

Specify the following properties for Quality options when configuring the data source:

Default quality field:

Use a quality field from the data as the master quality reference for all fields.  Individual fields can be mapped to override the default quality setting by mapping fields from the Quality fields list to the Configured fields list.

All quality is good:

All quality is read as good quality data.

Preview TAB

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

Summary TAB

The summary TAB provides an overview of the various timestamp, quality, value, field name and data types configured for each field that will be read from the data source.

Return to top


Related topics:

  

CSense 2023- Last updated: June 24,2025