Re: Informix and Oracle

cse@wetware.com (Scott Ellard) wrote: > > In article <3hoq39$n7j$1@mhadg.production.compuserve.com> Paul Borrett <100322.2716@CompuServe.COM> writes: > >Does anyone have any experience of linking live Informix Online > >and Oracle (v7?) databases ? We will soon have to integrate our > >Online system with a supplier Oracle system and would kind of > >like to have one large database (with synonyms, or course!). Is > >this possible, and if so what products do I require ? > > Oracle has recently released a gateway product which somewhat > addresses this problem. Basically, tables in foreign databases > appear as regular tables in Oracle. I have seen it operate, so > it is real. As I understand it Informix, Sybase and Ingres are > currently supported. Oracle does indeed provide a number of Transparent or Procedural Gateways to "foreign" datastores such as DB2, TurboImage, Rdb, SQL/400 and a number of others also. The gateways make the other datastore look like an Oracle database as far as the users and developers are concerned. Hence, through the use of database links and synonyms there is no extra application code required to access the data outside Oracle. An additional advantage of the gateways is that data can be downloaded into Oracle very simply using standard SQL commands and in most cases the gateways are WRITE as well as READ enabled. Thus, data maybe transferred bi-directionally. Oracle is currently developing gateways to Informix, Sybase and Ingres. Please contact Oracle direct for further information on availability. Regards, Paul Bash