TIBCO Scribe® Online Connector For OLE DB

The TIBCO Scribe® Online OLE DB Connector provides seamless integration to a variety of systems and data sources with OLE DB.

Note: Object Linking and Embedding Database (OLE DB) Connections are only available with On schedule and On event apps and require a Connect on-premise agent.

Object Linking and Embedding Database (OLE DB) is an API designed by Microsoft that provides universal access to data of many types and formats. OLE DB connects to data sources using an OLE DB Provider, which is similar to an ODBC driver; it is a component written by an applications vendor or a third-party that allows OLE DB to communicate with a datastore.

Note: The OLE DB Providers displayed in the Providers list are those installed on the same computer as the Connect on-premise agent.

Although TIBCO Cloud™ Integration - Connect can support OLE DB Providers that follow ODBC and SQL standards, not all Providers follow these standards. In testing, TIBCO has found that there are caveats when creating a Connection for many OLE DB Providers.

Tip: Before creating an OLE DB Connection, read the Working With TIBCO Cloud™ Integration - Connect ODBC Connections Knowledge Base article for information about the OLE DB Provider you want to use.

For information about the available Providers and their parameters, see your System Administrator.

Selecting An Agent Type For OLE DB

Refer to TIBCO Cloud™ Integration - Connect Agents for information on available agent types and how to select the best agent for your app.

Connecting To OLE DB

Note: Best practice is to create Connections with credentials that limit permissions in the target system, following the principle of least privilege. Using Administrator level credentials in a Connection provides Administrator level access to the target system for TIBCO Cloud™ Integration - Connect users. Depending on the entities supported, a TIBCO Cloud™ Integration - Connect user could alter user accounts in the target system.

Select Connections from the menu.
From the Connections page select Create to open the Create a connection dialog.
Select the Connector from the list to open the Connection dialog, and then enter the following information for this Connection:
- Name — This can be any meaningful name, up to 25 characters.
- Alias — An alias for this Connection name. The alias is generated from the Connection name, and can be up to 25 characters. The Connection alias can include letters, numbers, and underscores. Spaces and special characters are not accepted. You can change the alias. For more information, see Connection Alias.
- Provider — From the Provider list, select the OLE DB provider you want to use. You will only see Providers that are available from the computer where the Connect on-premise agent is installed.
  Note: While the Microsoft OLE DB Provider for ODBC Drivers may be installed at your site, Microsoft no longer supports this driver. If needed, create an ODBC Connection using an appropriate SQL Driver.
- Server — The Server you want to access. For SQL Server providers, this may be the same as the Server name for a SQL Server connection. See TIBCO Scribe® Online Connector For Microsoft SQL Server.
- Database Name — The datastore you want to access.
  Note: Depending on your Provider, you may not need to specify the Database name.
- Authentication — Select:
  - Application (default) — Select to use the login credentials for the OLE DB application. If set to Application, the User name and Password are required.
  - Windows — Select if using a Windows user account to authenticate the database connection. Depending on the OLE DB provider or driver, you may need to include additional parameters (for example, for Microsoft SQL Server, include TRUSTED_CONNECTION=yes; in the Additional parameters text box).
    For information about which authentication mode to use or required connection parameters, see your System Administrator or the OLE DB documentation for your driver or provider.
- User Name/Password —The User name and password for this Server and Database.
- Additional Parameters — (Optional). Some OLE DB connections require additional connection parameters. For more information, see your System Administrator.
Select Test to ensure that the agent can connect to your database. Be sure to test the Connection against all agents that use this Connection. See Testing Connections.
Select OK/Save to save the Connection.

Metadata Notes

Naming

Connection metadata must have unique entity, relationship, and field names. If your Connection metadata has duplicate names, review the source system to determine if the duplicates can be renamed.

TIBCO Cloud™ Integration - Connect API Considerations

To create Connections with the TIBCO Cloud™ Integration - Connect API, the OLE DB Connector requires the following information:

Connector Name	ADO OLEDB
Connector ID	FA4DEEDF-8451-41ED-8551-1B3C8B4ED146

TIBCO Cloud™ Integration - Connect Connection Properties

In addition, this Connector uses the Connection properties shown in the following table.

Note: Connection property names are case-sensitive.

Name	Data Type	Required	Secured
Provider	Drop-down	Yes	No
Server	String	Yes	No
DatabaseName	String	No	No
Authentication	Drop-down	Yes	No
User Name	String	No	No
Password	String	No	Yes
Additional Parameters	String	No	No

License Agreement

The TIBCO End User License Agreement for the OLE DB Connector describes TIBCO and your legal obligations and requirements. TIBCO suggests that you read the End User License Agreement.

More Information

For additional information on this Connector, refer to the Knowledge Base and Discussions in the TIBCO Community.