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 Integration and Migration Solutions and require an 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 TIBCO Scribe® Online Agent.

Although TIBCO Scribe® Online 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 Scribe® Online 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 Scribe® Online Agents for information on available Agent types and how to select the best Agent for your Solution.

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 Scribe® Online users. Depending on the entities supported, a TIBCO Scribe® Online user could alter user accounts in the target system.

  1. Select More > Connections from the menu.
  2. From the Connections page select Add to open the Add a New Connection dialog.
  3. Select the Connector from the drop-down list in the Connection Type field, 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 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).

        Note: 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.
  4. 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.
  5. Select OK 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 Scribe® Online API Considerations

To create Connections with the TIBCO Scribe® Online API, the OLE DB Connector requires the following information:

Connector Name

ADO OLEDB

Connector ID

FA4DEEDF-8451-41ED-8551-1B3C8B4ED146

TIBCO Scribe® Online 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 Scribe® Online 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.