Multi-Database Access Driver
Direct Connect driver is a middleware component between (Undefined variable: MyVariables.Product) and its connecting database. It enables (Undefined variable: MyVariables.Product) to send data to and retrieve data from database storage, also enables you to configure and access multiple databases. This section provides the configuration, commands for multi-database access, table querying, transaction in multi-databases, driver environment variables and other important details for the Oracle, MSSQL and DB2 databases.
The component requirements for multiple data access are listed in the following table.
| Component | Version |
|---|---|
| TAFC | PB201312 |
| MSSQL | 2008 R2 or above |
| Oracle | 11g R2 or above |
| DB2 | V9.5 or above |
The (Undefined variable: MyVariables.Product) Oracle Direct Connect driver is a middleware component between (Undefined variable: MyVariables.Product)and Oracle database. It enables (Undefined variable: MyVariables.Product) to send to and retrieve data from Oracle database storage. The data is stored in Oracle server as either XML columns or BLOBs (Binary Large Objects) for internal or work files. This section provides details about the database configuration, commands, transactions and driver environment variables involved in multiple database access and table details.
The (Undefined variable: MyVariables.Product) Microsoft SQL Server Direct Connect driver is a middleware component between (Undefined variable: MyVariables.Product) and MSSQL server database. It enables (Undefined variable: MyVariables.Product) to send to and retrieve data from MSSQL server database storage. The data is stored in MSSQL server as either XML columns or BLOBs (Binary Large Objects) for internal or work files. This section provides details about the database configuration, commands, transactions and driver environment variables involved in multiple database access and table details.
The (Undefined variable: MyVariables.Product) DB2 Direct Connect driver is a middleware component between (Undefined variable: MyVariables.Product) and DB2 database. It enables (Undefined variable: MyVariables.Product) to send to and retrieve data from DB2 database storage. The data is stored in DB2 server as either XML columns or BLOBs (Binary Large Objects) for internal or work files. This section provides details about the database configuration, commands, transactions and driver environment variables involved in multiple database access and table details.
This section describes the use of Database Row Locks for relational support.
This section provides troubleshooting details for MSSQL, Oracle, and DB2 databases.
This section provides the additional details pertaining to the implementation of Oracle and MSSQL databases.
In this topic
