Re: informix <--> oracle connectivity

Nick A colleague mentioned using the Oracle extension to Perl (oraperl?) and the DBD::Informix to write a script that reads from one database and write to another. Or you could use Java and JDBC to both Oracle and Informix. They may work out as better (ie non-vendor specific) approach than using Powerbuilder. HTH Sujit Nick Nobbe <nnob@loc.gov> on 08/19/99 07:21:14 AM To: "Art S. Kagel" <kagel@bloomberg.net> cc: informix-list@iiug.org (bcc: Sujit Pal) Subject: Re: informix <--> oracle connectivity My unit looked into the Informix Gateway product for Informix - Oracle connectivity and found it a bit pricey at US$20,000 +. We decided to pass data using simple unloads and loads. In Oracle unloading Ascii is not as easy as in Informix. We have also considered using something like a Powerbuilder app to mediate between the two servers. Just adding fuel to the fire, Nick On Tue, 17 Aug 1999, Art S. Kagel wrote: > Edward Rosenthal wrote: > > > > In a heterogenous environment ( oracle and informix db's on unix > > servers, > > solaris and hp ). Its probably oracle 8.X and its informix universal > > server 9.12UC2. > > I need to find out if the Informix product Enterprise Gateway Manager is > > what I want, > > for informix to be able to have access to the oracle server. Are there > > other > > products which i will want to review as well? > > Probably will want to set up some sort of batch read and write system > > between > > the servers. > > > > Can someone with that experience (with gateway) give me a quick > > overview of what it is > > all about, and what the requirements are? > > Do i need to have a dedicated nt box or can i do it all on our unix > > servers? > > Yes you can use Informix Enterprise Gateway and access the Oracle server > as if it were another Informix server. Another alternative is a Virtual > Database Server or Universal Database Server such as ISG Navigator. This > is a middleware server that will take requests to both servers as ODBC > queries and using it's own optimizer decide how best to farm the partial > work to the Informix and Oracle servers. Navigator runs on NT and many > UNIX's and it now has several competitors. Oracle is reported to be > planning to select Navigator as its new gateway product. > > Art S. Kagel >