ASE is provided with ECDA for the CIS functionality. 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 ASE. If you
have purchased a full ASE license with the CIS option, you are licensed
for local data storage within ASE.
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 ASE, Oracle, Microsoft SQL Server, 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.
