When creating OLE DB Connections in TIBCO Scribe® Online, keep in mind the following:

All OLE DB Providers installed on the computer where the Agent is installed display in the OLE DB Provider drop-down list. However, not all Providers conform to the SQL and ODBC standards that allow them to function correctly as TIBCO Scribe® Online Connections.

The OLE DB Provider must be installed on the same computer as the TIBCO Scribe® Online Agent. Mapped drives do not work.

OLE DB -- Windows Authentication for SQL Connections:

• The following statement is required in the additional Parameters field :

              TRUSTED_CONNECTION=yes;

•  If the Agent is not installed on the same computer as the database, you must provide a user name and password. The user name and password are not required when the database is on the same computer as the Agent and running under the same user.

OLE DB -- PostgreSQL Provider:

• If you specify a column as a bit data type, the column displays as String(4000) data type in the TIBCO Scribe® Online Map pages.
• If you specify a column as an array data type, the column displays as an Object data type in the TIBCO Scribe® Online Map pages.
• For target Connections, PostgreSQL Connections support Insert operations. Update and Delete operations may not work.