Re: Creating a Database link between Informix & Oracle

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Obnoxio The Clown — Wed, 30 Jun 1999 10:30:33 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Karen X Walker" <kxw@ddpmi.com> > >I am new to informix (background in Oracle), it is possible to create a >database link between Informix and Oracle which will allow for replication? > Please provide suggestions. AFAIK, you have many options: 1. Informix sells an Oracle Gateway. 2. Oracle sells an Informix Gateway. 3. Praxis Omni Replicator. (Possibly the best bet?) 4. Some kludge using ODBC. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

Edward A. Geddis — Thu, 1 Jul 1999 13:47:47 -0400 — source: Informix-list mailing list archive (1991-1998)

You could use OpenLink's Virtuoso to connect to multiple databases. Please visit http://www.openlinksw.com to download. General Information: Virtuoso is a revolutionary, next generation, high-performance virtual database engine for the Distributed Computing Age. It is a core universal data access technology set to accelerate our advances into the emerging Information Age. Virtuoso provides transparent access to your existing data sources, which are typically databases from different database vendors. Through a single connection, Virtuoso will simultaneously connect your ODBC, JDBC, UDBC, OLE-DB client applications and services to data within Oracle, Microsoft SQL Server, DB/2, Informix, Progress, CA-Ingres and other ODBC compliant database engines. All your databases are treated as single logical unit. The full installation takes up less than 10MB of disk space. The actual database element takes up less than 5MB. Virtuoso currently supports Linux ("glibc2" and "libc5" based distributions), Windows 95/98/NT/2000, and UNIX (all flavors). There are plans to port Virtuoso to the OS390, OS400, VMS, and MacOS platforms subject to demand. -- Thanks, Edward A. Geddis Technical Support Consultant OpenLink Software http://www.openlinksw.com Making Technology Work for You Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:7lcsmo$16$1@news.xmission.com... > > From: "Karen X Walker" <kxw@ddpmi.com> > > > >I am new to informix (background in Oracle), it is possible to create a > >database link between Informix and Oracle which will allow for replication? > > Please provide suggestions. > > AFAIK, you have many options: > > 1. Informix sells an Oracle Gateway. > 2. Oracle sells an Informix Gateway. > 3. Praxis Omni Replicator. (Possibly the best bet?) > 4. Some kludge using ODBC. > > HTH. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com