Multiple Database Access Driver

Direct Connect driver is a middleware component between Temenos Transact and its connecting database. It enables Temenos Transact 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 multiple database access, table querying, transaction in multiple 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

Oracle

The Temenos Transact Oracle Direct Connect driver is a middleware component between Temenos Transactand Oracle database. It enables Temenos Transact 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.

MSSQL

The Temenos Transact Microsoft SQL Server Direct Connect driver is a middleware component between Temenos Transact and MSSQL server database. It enables Temenos Transact 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.

DB2

The Temenos Transact DB2 Direct Connect driver is a middleware component between Temenos Transact and DB2 database. It enables Temenos Transact 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.

Database Troubleshooting

This section provides troubleshooting details for MSSQL, Oracle, and DB2 databases.

Appendix

This section provides the additional details pertaining to the implementation of Oracle and MSSQL databases.