An enterprise has developed a Visual Basic customer management application that must combine mainframe VSAM data with iSeries data.
The enterprise uses ASE/CIS, the DirectConnect for z/OS Option, ECDA Option for ODBC, and Server Option applications for VSAM data access.
ECDA Option for ODBC is a component of Enterprise Connect™ Data Access.
Figure 3-2 illustrates this sample scenario.
Figure 3-2: Transparently accessing and changing data on a mainframe and in other databases
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.