|
Sybase Enterprise Data Studio Feature Guide
|
Enterprise Connect
The Enterprise Connect option provides all the connectivity tools you need to access and move data in a heterogeneous environment. The Enterprise Connect option combines the replication features of the Adaptive Server Enterprise Replication option with the ability to access and replicate to a variety of LAN-based, non-Sybase data sources.
Using the Enterprise Connect option, you can maintain a corporate overview of distributed operations, even when distributed business units run on a variety of hardware and database management system (DBMS) platforms. Enterprise Connect is database-independent middleware; it allows LAN-based clients to see a consistent picture of enterprise data no matter what the data source.
With the Enterprise Connect option, you can:
- Perform two-way replication between Informix, Oracle, and Adaptive Server Anywhere databases
- Connect to AS/400, Informix, Microsoft SQL Server, Oracle, and Adaptive Server Anywhere databases using the appropriate DirectConnect software, either directly or in conjunction with OmniConnect
- Connect to several ODBC-compliant databases using DirectConnect Anywhere and an appropriate ODBC driver, either directly or in conjunction with OmniConnect
- Create custom client applications written in Java using jConnect for JDBC or in C++ using Open Client libraries
- Create custom Open Server applications
- Share data efficiently throughout your organization by moving it in bulk between data sources using the DirectConnect transfer facility
- Create and distribute custom reports
- Manage your replication system and your DirectConnect servers using the Sybase Central graphical interface
Table 1-4 lists the server and PC-client components that you can install from the Enterprise Connect option. See Appendix A for a description of each component.
Table 1-4: Enterprise Connect option componentsEnterprise Connect |
|---|
Server Components |
Replication Server |
Replication Agents for Informix, Oracle, and Adaptive Server Anywhere |
OmniConnect |
DirectConnect Anywhere and DirectConnect for AS/400, Informix, Microsoft SQL Server, and Oracle |
ESQL/C and ESQL/COBOL |
jConnect for JDBC |
Language Modules for Adaptive Server Enterprise, DirectConnect, and Replication Server |
Adaptive Server Enterprise Monitor Server, Monitor Client Liberary, and Monitor Historical Server |
Open Client |
Open Server |
Sybase Character Sets |
PC-Client Components |
jConnect for JDBC |
Language Modules |
Monitor Client Library |
ODBC Driver for Adaptive Server Enterprise |
ODBC Driver for DirectConnect |
Open Client and Open Client Runtime for Windows 95 and Windows NT |
SQL Advantage |
Sybase Central viewer |
Sybase Central plug-ins for Adaptive Server Enterprise, DirectConnect, and Replication Server |
Sybase Character Sets |