Adaptive Server is provided with ECDA for the Component Integration Services functionality (ASE/CIS). With ASE/CIS your client applications can view and change data on multiple, heterogeneous data servers as if it were single-source data. ASE/CIS performs datatype transformations and enables heterogeneous joins.
When included in ECDA, the ASE/CIS license
does not include support for local data storage within Adaptive
Server. If you have purchased a full Adaptive Server license with
the CIS option, you are licensed for local data storage within Adaptive
Server.
ASE/CIS allows users to access both Sybase and non-Sybase databases on different servers. These external data sources include host data files and tables, views, and remote procedure calls (RPCs) in database systems such as Adaptive Server, Oracle, and DB2 UDB.
Using ASE/CIS, you can:
Access tables and views that reside on remote servers as if they were local objects.
Perform joins between tables in multiple remote, heterogeneous servers. For example, it is possible to join tables between an Oracle DBMS and DB2 UDB, and between tables in multiple DB2 UDB database servers.
Create stored procedures that work with distributed heterogeneous data.
Transfer the contents of one table into a new table on any supported remote server using a select into statement.
Provide applications, such as PowerBuilder®, Microsoft Access, and DataEase, with transparent access to heterogeneous data.
Maintain referential integrity across heterogeneous data sources.
Access native remote server capabilities using the Component Integration Services passthrough mode.
Map RPCs into proxy table structures and perform operations on them as though they were local tables.
The ASE ODBC and OLE DB drivers let your ODBC and OLE DB client applications work with ASE/CIS.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
