ODBC and Other Middleware Connections
Open Database Connectivity (ODBC) provides a means of connecting to data sources. ODBC is a standard generic interface layer to SQL-type data sources. In cases where the integration platform does not have a physical or native API to data, ODBC can often provide that connection. Windows and Linux systems support ODBC.
ODBC drivers are normally supplied by the vendor whose data is source or target or in the aftermarket of add-on tools. ODBC drivers are available for a wide set of data sources.
Driver Installation
After acquiring the ODBC driver for your source, you must go through an installation step (called ODBC Administration in Windows) to set the driver for your environment.
When the integration platform uses ODBC to connect to a source or target, it acts as a client through the ODBC driver.
Contact Support for information about ODBC driver vendors.
Text Box to Enter Driver Options
The text box is used to enter the following:
• DriverOptions
• Messages in the Log Message
• Constraint DDL information
• Primary key information
The text box is a simple text editor where you type commands.
See Also: