Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

About This Book [Table of Contents] Chapter 2: Introducing ClearConnect

Installation and Reference Guide ClearConnect 1.3

[-] Chapter 1: Understanding Enterprise Connect

Chapter 1

Understanding Enterprise Connect

This chapter provides an overview of the Enterprise Connect product line, including how ClearConnect relates to other Enterprise Connect products.

This chapter includes the following topics:

What is Enterprise Connect?

Enterprise Connect is a set of Sybase products that provides a common, enterprise-wide architecture that supports the development of distributed computing applications.
Enterprise Connect products provide the following services:

Enterprise Connect and Previous Sybase Products

Enterprise Connect refers to the new generation of Sybase middleware, as well as its predecessors. The following table maps Enterprise Connect products to their corresponding predecessors:

Table 1-1: Enterprise Connect products and corresponding predecessors

Enterprise Connect

Sybase Net-Gateway

MDI Database Gateway

ClearConnect

No predecessor

No predecessor

DirectConnect

Net-Gateway

Database Gateway

  • Access Services
  • (dynamic SQL access within Net-Gateway)
  • (dynamic SQL access within Database Gateway)
  • Transaction Router Service (TRS)
  • Mainframe Server Gateway (MSG)
  • n/a
  • Mainframe Client Connect (MCC)
  • Mainframe Client Gateway (MCG)
  • Database Gateway Access Server
  • DirectConnect Configuration Tool
  • n/a
  • Gateway Manager

Open ServerConnect

Open Server/Mainframe

MDI Access Server (RSPs)

Open ClientConnect

Open Client/Mainframe

MDI Access Server (CSAs)

MainframeConnect for DB2/MVS-CICS

OmniSQL Access Module(TM) for DB2

MDI Access Server (DB2)

Enterprise Connect Product Overview

This section explains the following products and their components, as well as their predecessor products:

ClearConnect

ClearConnect is a Windows-based ODBC (Open Database Connectivity) driver that supports direct client-to-host access to IBM Database 2 (DB2) data.

ClearConnect uses Distributed Relational Database Architecture (DRDA) for connectivity and runs on the client, allowing client applications to connect to any DRDA-enabled DB2. ClearConnect accesses the following data:

With ClearConnect, client applications, such as Powerbuilder, Microsoft Access, and Visual Basic, and other ODBC applications, can directly query and update DB2 databases.

ClearConnect has the following capabilities:

ClearConnect provides a point-to-point solution for project teams and workgroups requiring access to DB2 data. As projects grow and client volume increases, ClearConnect provides an easy migration to a larger-scale solution, such as DirectConnect for DB2/MVS.

Open ClientConnect

Open ClientConnect is a programming environment that lets you create mainframe applications that access LAN data residing on a Sybase SQL Server or any other supported data source. It allows you to treat the mainframe as just another node on a LAN.

Open ClientConnect uses the following APIs:

The following table provides migration information about the Open ClientConnect predecessor products.

Table 1-2: Open ClientConnect predecessor

Product

Migration information

Open Client/
Mainframe

Open ClientConnect replaces Open Client/Mainframe.

If you still use Open Client/Mainframe at your site, you cannot customize the code pages; that functionality is available only with Open ClientConnect, releases 3.1 and later.

MDI Access Server

Open ClientConnect replaces MDI Access Server (CSAs).

Open ServerConnect

Open ServerConnect is a programming environment that lets you create mainframe transactions that are accessible to Sybase client applications. To provide this access, Open ServerConnect uses the following basic interfaces:

These transactions provide access to virtually any MVS data source and are used for a variety of functions, including:

LAN-side client applications access Open ServerConnect transactions directly through DirectConnect or indirectly through OmniConnect or a Sybase SQL Server remote procedure call (RPC).

The following table provides migration information about the Open ServerConnect predecessor products.

Table 1-3: Open ServerConnect predecessor

Product

Migration information

Open Server/
Mainframe

Open ServerConnect replaces Open Server/Mainframe.

If you still use Open Server/Mainframe at your site, cursor processing is unavailable. Cursor processing is available only with Open ServerConnect, releases 3.1 and later.

MDI Access Server

Open ServerConnect replaces MDI Access Server (RSPs).

DirectConnect

DirectConnect is Open Server-based software that supports
DB-Library, CT-Library, and Open Database Connectivity (ODBC) application programming interfaces (APIs).

DirectConnect serves as a fundamental building block for database middleware applications. DirectConnect products are local area network (LAN)-based middleware gateways and servers that provide access to non-Sybase data and applications.

DirectConnect provides the following middleware services for decision support and online transaction processing (OLTP) applications:

The following table provides migration information about the DirectConnect predecessor products.

Table 1-4: DirectConnect predecessors

Product

Migration information

Net-Gateway

DirectConnect and its TRS and MCC components replace Net-Gateway and its MSG and MCG components.

Net-Gateway 3.0.1 provides the same functionality as DirectConnect using TRS and MCC, if Open ServerConnect (or Open Server/Mainframe) and Open ClientConnect (or Open Client/Mainframe) reside on the mainframe. Specifically, Net-Gateway 3.0.1 routes requests:

  • from the LAN to the mainframe (using MSG)
  • from the mainframe to the LAN (using MCG)

Database Gateway

DirectConnect replaces the Database Gateway.

DirectConnect Components

This section explains the components of DirectConnect: Access Services, Transaction Router Service, and Mainframe Client Connect.

Access Services

An access service is a logical server application, used with an access service library, to which clients connect. Each DirectConnect server can have multiple access services.

For more information about access services and access service libraries, see the DirectCONNECT for DB2/MVS Access Service Guide.

Transaction Router Service (TRS)

TRS, a component of DirectConnect, is used when the mainframe acts as a server. It routes requests from remote clients to Open ServerConnect transactions. Optionally, it can also route requests to MainframeConnect for DB2 (or OmniSQL Access Module for DB2), and return results to the clients. TRS is a required component if you are using SNA networks.

The following table provides migration information about the TRS predecessor product.

Table 1-5: Transaction Router Service predecessor

Product

Migration information

Mainframe Server Gateway (MSG)

DirectConnect and its TRS component replace Net-Gateway and its MSG component.

Net-Gateway 3.0.1 and MSG provide the same functionality as TRS. Specifically, MSG is available to route requests from the LAN using Open ServerConnect (or Open Server/Mainframe) to the mainframe.

Mainframe Client Connect (MCC)

MCC, a component of DirectConnect, is used when the mainframe acts as a client. It is a LAN-based program that lets mainframe Open ClientConnect applications connect to LAN servers. It performs data and protocol translation between SNA/LU6.2 (APPC) and TCP/IP with the LAN network protocols. When accessing through SNA networks, MCC is required.

The following table provides migration information about the MCC predecessor products.

Table 1-6: Mainframe Client Connect predecessors

Product

Migration information

Mainframe Client Gateway (MCG)

DirectConnect and its MCC component replace Net-Gateway and its MCG component.

Net-Gateway 3.0.1 and MCG provide the same functionality as MCC. Specifically, MCG is available to route requests from the mainframe using Open ClientConnect (or Open Client/Mainframe) to the LAN.

Database Gateway Access Server

DirectConnect and MCC replace the Database Gateway Access Server.

DirectConnect Configuration Tool

DirectConnect Configuration Tool is an Open Client-based graphical user interface (GUI) systems management tool for administering data accessible through DirectConnect. DirectConnect Configuration Tool runs only on Windows 3.1, Windows 95, or Windows NT. It provides the following capabilities:

MainframeConnect

MainframeConnect is mainframe software that works with DirectConnect or Net-Gateway 3.0.1 to provide access to mainframe data. It performs the following functions:

Client applications access MainframeConnect directly through an Access Service or TRS.

Client applications access MainframeConnect indirectly through OmniConnect or a Sybase SQL Server remote procedure call (RPC).

Note: MainframeConnect is available only for MVS-CICS environments. For IMS TM and native MVS environments, use OmniSQL Access Module for DB2 for IMS and MVS.

The following table provides migration information about the MainframeConnect predecessor product

Table 1-7: MainframeConnect predecessors

Product

Migration information

OmniSQL Access Module for DB2 CICS

MainframeConnect for DB2/MVS-CICS replaces OmniSQL Access Module for DB2 CICS. It does not replace OmniSQL Access Module for DB2 for IMS and MVS.

You can use either Net-Gateway MSG 3.0.1 or TRS with MainframeConnect for DB2/MVS-CICS.

MDI Access Server

MainframeConnect for DB2/MVS-CICS replaces
MDI Access Server.

Enterprise Connect Processing Environment

The Enterprise Connect products enable desktop computer and workstation users to communicate with mainframes in a client/server environment. The Enterprise Connect processing environment consists of several hardware and software components, such as the following:

Hardware/
software

Components

Hardware

  • One or more SQL Server or Open Server platforms
  • One or more platforms running DirectConnect
  • One or more IBM mainframes

Software from other vendors

  • Communications software
  • LU6.2 support
  • IBM TCP/IP support
  • Interlink TCP/IP support
  • CICS/MVS
  • IMS TM
  • VTAM and NCP
  • Database management systems on remote servers
  • MVS

Sybase software

  • ClearConnect
  • Open ClientConnect (or Open Client/Mainframe)
  • SQL Server
  • DirectConnect (or Net-Gateway)
  • Open Server
  • Open ServerConnect (or Open Server/Mainframe)
  • MainframeConnect for DB2 (or OmniSQL Access Module for DB2)

Note: Not all these software products are required at your site.

Products Used with Enterprise Connect

This section lists and briefly explains the related Sybase and IBM products.

Related Sybase Products

Enterprise Connect can be used with most Sybase products to connect mainframe applications with remote clients and servers.
The products in Table 1-8: Related Sybase products are frequently used as clients and/or servers with the Enterprise Connect set.

You need Sybase, IBM, and vendor communications documentation to configure, install, and manage Enterprise Connect products. You may need additional IBM and vendor manuals for your particular configuration. Be sure you have the necessary IBM manuals on hand before you begin to configure TCP, IMS TM or APPC MVS, as well as the Open ClientConnect and Open ServerConnect Messages and Codes guide for your mainframe products.

Table 1-8: Related Sybase products

Product

Description

SQL Server(TM)

With SQL Server acting as a server, clients using Open ClientConnect can send requests to a named SQL Server through Mainframe Client Connect.

SQL Server, the Sybase RDBMS, can act as a client or server. Networked clients can call SQL Server stored procedures that send requests to Open ServerConnect or MainframeConnect for DB2 (or OmniSQL Access Module for DB2) on the mainframe. The DirectConnect administrator can configure the TRS to require all client requests to be routed through SQL Server.

OmniCONNECT(TM)

OmniConnect translates SQL statements that DB2 cannot read or process into statements that DB2 can process. OmniSQL Access Module for DB2 clients can route requests through OmniConnect for SQL translation. Sites that need to run the same applications without modifications against both SQL Server and DB2 can use OmniConnect as a server.

Open Client(TM)

Open Client is a Sybase connectivity product that provides customer client applications, third-party products, and other Sybase products with the interfaces needed to communicate with Sybase servers and Open Server applications, including Open ServerConnect and OmniSQL Access Module for DB2 and MainframeConnect.

Open Server(TM)

Open Server provides the tools and interfaces needed to create a custom server (called an Open Server application).

Open ServerConnect uses Open Server architecture to allow the mainframe to act as a server.

Open ClientConnect clients can send requests to Open Server applications on the local area network (LAN) through Mainframe Client Connect, or directly through Intersystem Communication (ISC) if requests are being sent to Open ServerConnect in a separate region.

Replication Server(R)

Replication Server keeps copies of data up-to-date at multiple sites so that clients can access local data instead of remote, centralized databases.

Replication Agent(TM)

Replication Agent is a functional component of the replication model that conveys updates made to primary data sources to a Replication Server.

Related IBM Products

The Enterprise Connect set uses a number of IBM mainframe software products to allow mainframes to act as clients and servers. The most important of these products are listed in Table 1-9: Related IBM products.

Table 1-9: Related IBM products

Product

Description

APPC/LU6.2
(Advanced Program-to-Program Communication facility, which is a Logical Unit Type 6.2.)

A program-to-program communication protocol.
Open ServerConnect, Open ClientConnect, DB2 Access Module, and MainframeConnect for DB2 can all use APPC to communicate with DirectConnect.

C/370

An application programming language. Open Client Client-Library is available for C.

CICS
(Customer Information Control System)

A transaction monitor on the mainframe.
Open ServerConnect, Open ClientConnect, and MainframeConnect for DB2 are all available for CICS.

DB2 (Database 2)

A relational database on the mainframe that uses SQL. Enterprise Connect clients can send requests to DB2.

IMS(TM) TM
(Information Management System
Transaction Manager)

A transaction monitor and data communication system on the mainframe. Open ServerConnect, Open ClientConnect, and the OmniSQL Access Module for DB2 are all available for IMS(TM) TM.

OS PL/I Version II

An application programming language. Open Client Client-Library and Open Server Gateway-Library are both available for PL/I.

TCP/IP
(Transmission Control Protocol/Internet Protocol)

A communication protocol in general use. The following can use TCP/IP to communicate through DirectConnect:

  • Open ServerConnect
  • OmniSQL Access Module for DB2
  • MainframeConnect for DB2

VS COBOL II

An application programming language. Open Client Client-Library and Open Server Gateway-Library are both available for COBOL.

VTAM
(Virtual Telecommunications Access Method)

A mainframe access method used with SNA. Mainframe-based Enterprise Connect products run in a VTAM environment.


About This Book [Table of Contents] Chapter 2: Introducing ClearConnect