| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Enterprise Connect 12.0 Integrated Product Sets Overview Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2 Enterprise Connect Data Access |
Chapter 2
This chapter describes Enterprise Connect Data Access components.
Enterprise Connect Data Access is the Enterprise data solution for gaining transparent access to heterogeneous databases. These components allow applications to interact with non-Sybase databases, such as Oracle, Informix, Microsoft SQL Server, AS/400, DB2/DRDA, as well as Sybase Adaptive Server Enterprise and Sybase Adaptive Server Anywhere.
Enterprise Connect Data Access includes:
DirectConnect, which works stand-alone or behind ASE or Replication Server to provide dynamic access to Oracle, Informix, Microsoft SQL Server, SQL Anywhere®, AS/400, and DB2/DRDA, as well as to several ODBC-compliant databases
Sybase Adaptive Server Enterprise (ASE) with restricted license for Component Integration Services (CIS) (formerly OmniConnect) for a single view of distributed and heterogeneous data sources.
jConnect for JDBC, which lets you create custom client applications written in Java
Open Client, which lets you create client applications written in C++
Open Server, which lets you create a custom server application
DirectConnect is a Sybase product that provides basic connectivity to non-Sybase data sources. In particular, it provides access management, copy management, and remote systems management.
DirectConnect data access servers provide connectivity between LAN-based clients and enterprise data servers. You can use a DirectConnect server on its own to connect directly to a single, non-Sybase data server. Or, you can combine DirectConnect servers with other Sybase products such as ASE/CIS or Adaptive Server to provide a Transact-SQL interface that allows you to access, move, and replicate data in a heterogeneous environment.
DirectConnect consists of a server and one or more access service libraries, which have specific sets of configuration properties. The server provides the framework in which the service libraries operate. Each access service library accesses data from a particular target database, such as AS/400, DB2, Informix, Oracle, Microsoft SQL Server, ODBC-compliant and DRDA-compliant databases, and others.
Enterprise Connect Data Access includes these DirectConnect servers:
DirectConnect Anywhere(TM) - provides connectivity to supported ODBC-compliant data servers.
DirectConnect for AS/400 - provides connectivity to the AS/400 mainframe environment.
DirectConnect for DRDA - provides connectivity to DRDA-compliant databases, that is, DB2/AS400/Universal Databases (UDBs)
DirectConnect for Informix - provides connectivity to Informix database servers.
DirectConnect for Microsoft SQL Server - provides connectivity to Microsoft SQL Server databases.
DirectConnect for Oracle - provides connectivity to Oracle database servers.
You can use the DirectConnect plug-in for Sybase Central, or DirectConnect Manager, to configure, manage, and control your data access environment.
DirectConnect Manager is a Sybase Central-based graphical user interface (GUI) systems management tool for administering data accessible through DirectConnect. It runs within the Sybase systems management framework, Sybase Central. DirectConnect Manager runs on Windows 98 or Windows NT.
With DirectConnect Manager you can configure, manage, troubleshoot, and control your data access environment from Sybase Central. DirectConnect Manager displays a consolidated view of all DirectConnect servers across your enterprise.
With DirectConnect Manager, you can:
List and terminate user threads on any DirectConnect server
Manage multiple servers with the same name
Display status information for all distributed DirectConnect servers simultaneously
Adaptive Server Enterprise is provided with Enterprise Connect Data Access for the Component Integration Services (CIS) functionality (ASE/ CIS). ASE/ CIS lets client applications view and change data on multiple, heterogeneous data servers as if it were Sybase data. ASE/ CIS performs datatype transformations and enables heterogeneous joins.
When included in Enterprise Connect, 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 RPCs (remote procedure calls) in database systems such as Adaptive Server, Oracle, and DB2.
Using Component Integration Services, you can:
Access tables in remote servers as if the tables were local.
Perform joins between tables in multiple remote, heterogeneous servers. For example, it is possible to join tables between an Oracle database management system (DBMS) and an Adaptive Server, and between tables in multiple Adaptive Servers.
Transfer the contents of one table into a new table on any supported remote server by means of 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.
jConnect is Sybase's high-performance JDBC driver that works with both Sun and Microsoft virtual machines. jConnect provides native access to all Sybase database products, including Adaptive Server, Replication Server, and servers based on Open Server. From Adaptive Server, jConnect can access more than 25 enterprise and legacy database servers. It can directly access Oracle, AS/400, and Informix databases when paired with the appropriate DirectConnect software.
jConnect is both:
a net-protocol/all-Java driver within a three-tier environment
a native-protocol/all-Java driver within a two-tier environment
The protocol used by jConnect is TDS 5.0 (Tabular Data Stream, version 5), the native protocol for Adaptive Server and Open Server applications. jConnect implements the JDBC standard to provide optimal connectivity to the complete family of Sybase products, allowing access to over 25 enterprise and legacy systems, including:
Adaptive Server Enterprise
Enterprise Application Server(TM)
DirectConnect
Adaptive Server Anywhere
Adaptive Server® IQ (formerly Sybase IQ)
Replication Server
ASE/CIS (formerly OmniConnect)
In addition, jConnect for JDBC can access Oracle, AS/400, and other data sources using Sybase DirectConnect.
Sybase provides two families of products to enable customers to write client and server application programs. They are:
Open Client
Open Server
Open Client provides the interfaces that client applications, third-party products, and other Sybase products need to communicate with Adaptive Server and Open Server applications. Open Client provides runtime libraries and additional tools you need to develop custom client applications. Open Client network services support specific protocols such as TCP/IP and DECnet.
Open Client provides customer applications, third-party products, and other Sybase products with the interfaces needed to communicate with ASE and Open Server. Open Client can be thought of as comprising two components, programming interfaces and network services.
Open Client provides two core programming interfaces for writing client applications: Client-Library and DB-Library.
The Client-Library interface supports server-managed cursors and other new features that were added to the System 10 product line.
DB-Library provides support for older Open Client applications, and is a completely separate programming interface from Client-Library.
Client-Library programs also depend on CS-Library, which provides routines that are used in both Client-Library and Server-Library applications. Client-Library applications can also use routines from Bulk-Library to facilitate high-speed data transfer.
Open Client network services include Sybase Net-Library, which provides support for specific network protocols such as TCP/IP and DECnet. The Net-Library interface is invisible to application programmers. However, on some platforms an application may need a different Net-Library driver for different system network configurations. Depending on your host platform, the Net-Library driver is specified either by the system's Sybase configuration, or when you compile and link your programs.
Open Server provides the libraries, tools, and interfaces you need to create a custom server application. An Open Server application can be any type of server: it can perform calculations, provide access to real-time data, or interface with e-mail applications. It can communicate directly with Sybase and non-Sybase protocols. Replication Server and the DirectConnect gateways are Open Server applications.
Open Server provides the tools and interfaces needed to create custom servers. Like Open Client, Open Server consists of a programming interfaces component and a network services component.
The core programming interface for creating Open Server applications is Server-Library. Server-Library programs depend on Client/Server-Library (CS-Library for short). Gateway Server-Library applications can also use routines from Client-Library and Bulk-Library. Client-Library, CS-Library and Bulk-Library are all included in the Open Server product.
Open Server network services are transparent.
|
|