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! > Grand Rapids? Hmmm. Interesting. OK, first, I'd stay away from IBI. Lots of vaporware! (I'm sure I'll catch some flack from them ;-) Second, you are asking for several things. Informix has their UNIVERSAL Gateway product which is an enhancment over their DRDA gateway product. (DRDA works fine.) However that is Informix to DB2 only. You expressed interest in Informix to MVS based data stores. Which means you need to conform to mainframe security. Talk with IBM. Look at their MQ series middle ware. Now if you are planning to have TCP/IP on MVS or the eventual move to OS-390, then you may have a different set of tools available. But AFAIK, MQ series is the best for Mainframe to whatever database. (UNIX/NT/whatever) HTH -Mikey