Transparently accessing and changing data on a mainframe and in other databases

Profile

An enterprise has developed a Visual Basic customer management application that must combine mainframe VSAM data with iSeries data.

Sybase Products

The enterprise uses ASE/CIS, the DirectConnect for z/OS Option, ECDA Option for ODBC, and Server Option applications for VSAM data access.

NoteECDA Option for ODBC is a component of Enterprise Connect™ Data Access.

Scenario

Figure 3-2 illustrates this sample scenario.

Figure 3-2: Transparently accessing and changing data on a mainframe and in other databases

This figure is explained fully within the text.

As shown in Figure 3-2, a request originating at a Visual Basic Client is sent to ASE/CIS, which routes it to either the DirectConnect for z/OS Option or the ECDA Option for ODBC.

The DirectConnect for z/OS Option sends the request to a Server Option application on the mainframe. The Server Option application accesses the VSAM file. Data or a message is returned to the Visual Basic client.

The ECDA Option for ODBC sends the request to a Microsoft SQL Server database. Data or a message is returned to the Visual Basic client.