Accessing and changing data on the mainframe through an enterprise portal on the Web

Profile

A Web-based business—with 20 locations where product orders can be accessed and updated—needs to access orders and customer information stored in VSAM files and in DB2 on the mainframe. The business relies heavily on stored procedures and cannot use dynamic SQL to access mainframe data.

Sybase products

The business uses EAServer, the DirectConnect for z/OS Option, the Server Option, and the DB2 UDB Option for CICS.

Scenario

Figure 3-4 illustrates this sample scenario.

Figure 3-4: Accessing and changing data on the mainframe through an enterprise portal on the Web

This figure is explained fully within the text.

As shown in Figure 3-4, a request originates at a Web browser, is routed through a Web server and EAServer, then to the DirectConnect for z/OS Option in the gateway. The DirectConnect for z/OS Option then sends the request either to the DB2 Option for CICS (for DB2 UDB data) or a Server Option application (for VSAM data) on the mainframe. Data or a message are returned to the Web browser.