Database2RuntimeData integration properties

ConnectionString

The parameters used to connect to the source database.

Example

SQL: DataSource=ServerName;InitialCatalog=DatabaseName;IntegratedSecurity=SSPI

Oracle: User ID = XXX;Password = XXX; Data Source = XXX

DatabaseType

The type of database the workflow integration connects to.

SQL, Oracle

PollInterval

The frequency at which AVEVA™ Production Management polls the external system.

Set this property to a value (in seconds) greater than the scan rate, which is the time it takes for data to make a round trip from request to reply.

The speed and activity of the network and system can restrict the poll interval. Alter the property setting with consideration of system performance maintenance.

While you debug, you may want to update this value to 1 day, for example, 1.00:00:00, so you can continue to manually trigger the integration.

<hh:mm:ss> Minimum is 1 second (00:00:01). Maximum is 23 hours, fifty-nine minutes, fifty-nine seconds (23:59:59)

SourceCulture

The regional language associated with the source field data.

Use this setting when the data in the File is from a different culture to the one used by the server.

Any supported regional setting

DataQuery

The data query that defines the next segment of data from the database table.

Example

select Value, Quality, DateTime from ConnectorTable where Variable = @TagName and DateTime >= @TagLastSample AND DateTime < @TimeHorizon

An @tag is a placeholder. Each time the data query is performed, the @tags are replaced by real data.

DataQueryCommandType

The type of query command.

Text, StoredProcedure

DataQueryFieldMappings

The Value, Quality, and DateTime fields to any columns in the source database to map.

DataQueryParameters

The parameters in the data query.

For example, the parameters @TagName, @LastSampleTime, and @TimeHorizon. Specify each parameter name and ParameterValueType.

StreamInitializationQuery

A query that determines the value to insert into the stream when initialized from an inactive and empty state.

StreamInitializationQueryCommandType

The database query that obtains the initial historical data required as a starting point for population of the streams.

StreamInitializationQueryFieldMappings

The Value, Quality, and DateTime fields to any columns in the source database to map, for the initialization query only.

StreamInitializationQueryParameters

The parameters for the stream initialization query.

TimeHorizonQuery

The time horizon determines the time border on what the current database read is, so it does not overlap with the previous read from the database.

TimeHorizonQueryCommandType

The command type of the time horizon query.

TimeHorizonQueryParameters

The parameters for the time horizon query.