Home

	Expand Search

Sybase Enterprise Data Studio Feature Guide

Chapter 1: Enterprise Data Studio:An Overview

Five Options

Enterprise Connect

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 components

Enterprise 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