DirectConnect for Oracle provides Open Client access to Oracle databases. It operates in conjunction with the Adaptive Server Enterprise Component Integration Services feature (ASE/CIS) and as a standalone gateway. This combination offers clients a Transact-SQL® interface to external Oracle data.
When used with Adaptive Server, DirectConnect for Oracle transforms the Transact-SQL generated by Adaptive Server 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. This combination allows location transparency, distributed query optimization, copy transparency, transaction transparency, and distributed joins.
Using Adaptive Server, you can join Oracle tables with tables in Adaptive Server, DB2 UDB, or other database servers. Access to these objects through Adaptive Server is transparent to the application.
In standalone mode, DirectConnect for Oracle provides client applications with an Open Client interface to Oracle databases. To the client, DirectConnect for Oracle appears as an Open Server application that understands Oracle SQL.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
