Re: Know of any good Gateway products??
Bruce_Farwell@spartanstores.com wrote: > > I am interested in finding products that can provide a gateway to Informix, > DB2, > and possible ADABAS database tables. I would like to have bi-directional > access > i.e. Desktop apps like VB accessing Informix on UNIX and DB2 on MVS and > conversely > MVS Cobol apps accessing both DB2, ADABAS, and Informix on UNIX databases > using heterogenous table joins and transactions. > > I'm somewhat familiar with the Informix Enterprise Gateway using IBI's > EDA/SQL. > I'm interested to know if there are other products available and any > comments > on how well any of these work. > > Thanks for the info! > > Bruce Farwell > Spartan Stores, Inc. > Grand Rapids, MI Hi Bruce, You may want to take a look at the VORTEXcobol, VORTEXodbc, VORTEXserver and GENESIS products from Trifox. Here's an examples of an MVS COBOL program accessing local DB2, local Oracle, local ADABAS C via Genesis and remote Informix, Oracle and Sybase on Unix. +--------------+ | VTXcobol | MVS +--------------+ | +-----------------------------------------------------+ | VORTEXcli (Client) | +-----------------------------------------------------+ | | | | +-----------------------+ +----------+ | +----------+ | VORTEXnet (TCP/IP) | | DB2 | | | ORACLE | +-----------------------+ +----------+ | +----------+ \\ +----------+ | \\ | GENESIS | \\ +----------+ -- | \\ +----------+ \\ | ADABAS | \\ +----------+ +------------------------+ | VORTEXnet (TCP/IP) | UNIX +------------------------+ +----------------------------------------------------------+ | VORTEXserver (Server) | +----------------------------------------------------------+ +-----------------+ +---------------+ +---------------+ | INFORMIX Driver | | ORACLE Driver | | SYBASE Driver | +-----------------+ +---------------+ +---------------+ | | | | | | +---------------+ +---------------+ +--------------+ | | | | | | | INFORMIX | | ORACLE | | SYBASE | | | | | | | +---------------+ +---------------+ +--------------+ Here's an examples of a VB program and COBOL program on Windows NT accessing an MVS DB2, MVS ORACLE, MVS ADABAS C (via Genesis), a Unix Informix, Unix Oracle and Unix Sybase. +--------------+ | Visual Basic | +--------------+ | +----------+ | +-----------+ | Esperant | | | MS ACCESS | +----------+ | +-----------+ | | | +---------+ +--------------+ +---------------+ | NATURAL | | VTXcobol | | VORTEXodbc | +---------+ +--------------+ +---------------+ | | | +--------------------------+ | | VORTEXcli (Client) | | +--------------------------+ | | | +---------------------------------+ | VORTEXnet (TCP/IP) | +---------------------------------+ \\ \\ \\ \\ | \\ | -- | \\ | \\ | \\ | +-----------------------------------------------+ | | VORTEXnet (TCP/IP) | MVS | +-----------------------------------------------+ | | \\ +--------------------------------------------------------+ \\ | VORTEXserver (Server) | \\ +--------------------------------------------------------+ -- | | | \\ +----------------------+ | | \\ | GENESIS | | | \\ +----------------------+ | | | | | | | +---------------+ +------------+ +-------------+ | | | | | | | | | ADABAS C | | DB2 | | ORACLE | | | | | | | | \\ +---------------+ +------------+ +-------------+ \\ +------------------------+ | VORTEXnet (TCP/IP) | UNIX +------------------------+ +----------------------------------------------------------+ | VORTEXserver (Server) | +----------------------------------------------------------+ +-----------------+ +---------------+ +---------------+ | INFORMIX Driver | | ORACLE Driver | | SYBASE Driver | +-----------------+ +---------------+ +---------------+ | | | | | | +---------------+ +---------------+ +--------------+ | | | | | | | INFORMIX | | ORACLE | | SYBASE | | | | | | | +---------------+ +---------------+ +--------------+ Please see http://www.trifox.com for more details on VORTEXcobol, VORTEXodbc, VORTEXserver and Genesis. Regards, Bob Eisner 408 369-2392