OLE DB Connection Tab

Prerequisites

You have created an OLE DB source system. You can use the OLE DB source system to set up a connection to an OLE-DB-based data source.

OLE DB source systems can only be used in the query process.

To configure the connection settings, on the Plant Connectivity Management Console screen, select an OLE DB source system and click the OLE DB Connection tab.

Enter the necessary data on the OLE DB Connection tab using the following table:

Field	Description
Variant Representation	OLE DB supports some data types from the connected data source. PCo supports the following data types: Integer Boolean Date Double Float String Timestamp Decimal If PCo does not find any of the mentioned data types in the database table to be read, PCo is to represent the data as follows: Convert Data According to Data in First Row With this setting, PCo reads the first row of data and attempts to convert the data into one of the data types that are supported. Convert Data Into String With this setting, PCo attempts to convert the column values into strings. The system displays a message if conversion is not possible. This is the standard setting. Flag Columns as "Unsupported" With this setting, PCo sets the column values to `Unsupported`.
Convert Server Date and Time Values to UTC	This setting is only possible in conjunction with the setting Convert Data According to Data in First Row. This setting enables the conversion of date and time values to UTC so that they appear correctly in SAP MII. The SAP MII-PCo connection assumes any date or time value from the agent is in UTC; not all data sources return date and time values in UTC.
Server Time Zone	Specifies the time zone of the data server used to convert the local date and time values to UTC. This setting is only possible in conjunction with the setting Convert Data According to Data in First Row.

Field

Description

Variant Representation

OLE DB supports some data types from the connected data source. PCo supports the following data types:

If PCo does not find any of the mentioned data types in the database table to be read, PCo is to represent the data as follows:

Convert Data According to Data in First Row

With this setting, PCo reads the first row of data and attempts to convert the data into one of the data types that are supported.
Convert Data Into String

With this setting, PCo attempts to convert the column values into strings. The system displays a message if conversion is not possible.

This is the standard setting.
Flag Columns as "Unsupported"

With this setting, PCo sets the column values to Unsupported.

Convert Server Date and Time Values to UTC

This setting is only possible in conjunction with the setting Convert Data According to Data in First Row.

This setting enables the conversion of date and time values to UTC so that they appear correctly in SAP MII.

The SAP MII-PCo connection assumes any date or time value from the agent is in UTC; not all data sources return date and time values in UTC.

Server Time Zone

Specifies the time zone of the data server used to convert the local date and time values to UTC.

This setting is only possible in conjunction with the setting Convert Data According to Data in First Row.