DirectConnect for Oracle provides Open Client™ access to Oracle databases. It operates in conjunction with the Component Integration Services feature of Adaptive Server Enterprise called ASE/CIS or as a standalone gateway.
When used with Adaptive Server Enterprise, DirectConnect for Oracle transforms the Transact-SQL generated by Adaptive Server Enterprise to Oracle's native SQL. DirectConnect for Oracle also handles datatype mapping between Sybase datatypes and Oracle datatypes. DirectConnect for Oracle provides many of the features of a distributed database system when used in combination with Adaptive Server Enterprise. This combination enables location transparency, distributed query optimization, copy transparency, transaction transparency, and distributed joins.
When used with Adaptive Server Enterprise, you can join Oracle tables with Sybase Adaptive Server, DB2, or other tables. Access to these objects through Adaptive Server Enterprise is transparent to the application. Direct Connect for Oracle now supports full, two-phase commit transaction management.
In standalone mode, DirectConnect for Oracle provides client applications with an Open Client interface to Oracle databases. To the client it appears as an Open Server™ application that understands Oracle SQL.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
