TIBCO Scribe® Online Connector For ODBC

ODBC Connections can provide the power and flexibility that you need to integrate data with systems for which TIBCO Cloud™ Integration - Connect does not have a Connector. However, TIBCO does not test all ODBC drivers and not all vendors implement their drivers in such a way that TIBCO Cloud™ Integration - Connect can work with them.

Note: ODBC Connections are only available with On schedule or On event apps and require a Connect on-premise agent.

Warning: Although TIBCO Cloud™ Integration - Connect supports data sources that follow ODBC and SQL standards, not all data sources follow these standards. Best practice is to thoroughly test your particular ODBC driver with TIBCO Cloud™ Integration - Connect. At minimum you should test the following: the ODBC Connection between TIBCO Cloud™ Integration - Connect and the database, creating a flow, reading data from the database, and writing data to the database.

Setup Considerations

Your ODBC driver must be fully compliant with the ODBC 3.5 standard.
To use an ODBC driver as a Connection, it must be installed on the same computer as the Connect on-premise agent.
The driver you select for your ODBC Connection depends on the operating system of the computer where the Connect on-premise agent is installed:
- For a 32-bit (x86) operating system, use 32-bit drivers.
- For a 64-bit (x64) operating system, use 64-bit drivers.
Only System DSNs can be used to create ODBC Connections. TIBCO Cloud™ Integration - Connect does not currently support Connections with User and File DSNs.

For information about the available ODBC DSNs and parameters, see your System Administrator or the ODBC driver documentation provided by the OEM.

Tip: Before creating an ODBC Connection, read the Working With ODBC Connections KB article for information about the ODBC driver you want to use.

Selecting An Agent Type For ODBC

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 ODBC

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.
- DSN — The Data Source Name for this Connection. You can find or add an ODBC System DSN from the ODBC Data Source Administrator on the computer where the Connect on-premise agent is installed. While the ODBC Data Source Administrator displays all available ODBC Data Sources; TIBCO cannot guarantee that a specific ODBC driver will work with TIBCO Cloud™ Integration - Connect.
- Authentication — Select:
  - Application (default) — Select to use the login credentials for the ODBC 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.
    Note: For information about which authentication mode to use, see your System Administrator.
- User Name/Password — The user name and password to connect to this DSN.
- Select Tables For Schema — Optionally, to process the data in tables associated with a single schema for this ODBC Connection, enter the schema name. If left blank, TIBCO Cloud™ Integration - Connect uses all schemas for this Connection.
  Tip: If you specify a schema, reset metadata for this Connection after you create or edit it. See Resetting Metadata.
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 ODBC Connector requires the following information:

Connector Name	ODBC
Connector ID	8936AF41-6992-4D94-8137-C8732D0311E7

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	Usage
Dsn	String	Yes	No
TrustedConnection	String	Yes	No	Supported values: false = application true = windows
UserName	String	No	No
Password	String	No	Yes
SchemaName	String	No	No

License Agreement

The TIBCO End User License Agreement for the ODBC 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.