Accessing Oracle From Informix
A user asked whether IDS 10 on HP-UX could query an Oracle 10 database directly from stored procedures or synonyms, and what would be needed. Respondents answered that this requires the separately licensed Informix Enterprise Gateway Manager (EGM) — the only alternative being writing your own Oracle access module, which doesn't exist. Links to IBM's EGM page and the platform-availability spreadsheet were given, confirming builds for AIX, HP-UX, Solaris, Windows and Linux. A follow-up asking whether anyone had used EGM with SCO/IDS 7 or RedHat/IDS 11 against Oracle Express got no reply.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All, Just two questions for you: Can Informix database access Oracle database from an Informix stored procedure and/or synonym? If this is possible, what do we need for? We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. Regards. ISC. Luis Alejandro Martínez Mejía Jefe de Operación y Bases de Datos Grupo SID
Hi there!!! You must buy an Informix tool called "Informix Enterprise Gateway Manager 7.31 XD?" on the latest version. With this product, you can access databases such as Oracle, Sybase, Teradata, and others. Best regards, Alberto Romeu Pessonio Filho IBM Informix Certified System Administrator V7 IBM Certified Managing and Optimizing Informix Databases V7 DBA Informix/DB2 UDB/SQLServer/Oracle albasic@gmail.com -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis Alejandro Martínez Mejía Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 Para: ids@iiug.org Assunto: Accessing Oracle From Informix [14562] Hi All, Just two questions for you: Can Informix database access Oracle database from an Informix stored procedure and/or synonym? If this is possible, what do we need for? We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. Regards. ISC. Luis Alejandro Martínez Mejía Jefe de Operación y Bases de Datos Grupo SID ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
You need the Informix Enterprise Gateway or you have to write a User Defined Table (UDT) module for Oracle (not available) yourself. Art 2009/1/16 Luis Alejandro Martínez Mejía <alejandro.martinez@gruposid.com.mx> > Hi All, > > Just two questions for you: > > Can Informix database access Oracle database from an Informix stored > procedure and/or synonym? > > If this is possible, what do we need for? > > We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. > > Regards. > > ISC. Luis Alejandro Martínez Mejía > > Jefe de Operación y Bases de Datos > > Grupo SID > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Would this product (Informix Enterprise Gateway Manager) also work on Linux Redhat? Regards David -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alberto Pessonio Sent: 17 January 2009 13:25 PM To: ids@iiug.org Subject: RES: Accessing Oracle From Informix [14563] Hi there!!! You must buy an Informix tool called "Informix Enterprise Gateway Manager 7.31 XD?" on the latest version. With this product, you can access databases such as Oracle, Sybase, Teradata, and others. Best regards, Alberto Romeu Pessonio Filho IBM Informix Certified System Administrator V7 IBM Certified Managing and Optimizing Informix Databases V7 DBA Informix/DB2 UDB/SQLServer/Oracle albasic@gmail.com -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis Alejandro Martínez Mejía Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 Para: ids@iiug.org Assunto: Accessing Oracle From Informix [14562] Hi All, Just two questions for you: Can Informix database access Oracle database from an Informix stored procedure and/or synonym? If this is possible, what do we need for? We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. Regards. ISC. Luis Alejandro Martínez Mejía Jefe de Operación y Bases de Datos Grupo SID ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Please check this link http://www-01.ibm.com/software/data/informix/tools/egm/ Informix Enterprise Gateway Manager runs on AIX, HP-UX, Solaris, Windows=AE=A0NT=AE, and Windows XP=AE. Thanks.. Amitava Chakraborty PMP=AE Lead - Informix Interoperability = "David Reed" = <David.Reed@tolli = nk.co.za> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect RE: Accessing Oracle From Inform= ix 19/01/2009 16:31 [14566] = = = Please respond to = ids@iiug.org = = = Would this product (Informix Enterprise Gateway Manager) also work on L= inux Redhat? Regards David -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alberto Pessonio Sent: 17 January 2009 13:25 PM To: ids@iiug.org Subject: RES: Accessing Oracle From Informix [14563] Hi there!!! You must buy an Informix tool called "Informix Enterprise Gateway Manag= er 7.31 XD?" on the latest version. With this product, you can access databases= such as Oracle, Sybase, Teradata, and others. Best regards, Alberto Romeu Pessonio Filho IBM Informix Certified System Administrator V7 IBM Certified Managing and Optimizing Informix Databases V7 DBA Informix/DB2 UDB/SQLServer/Oracle albasic@gmail.com -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis Alejandro Mart=EDnez Mej=EDa Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 Para: ids@iiug.org Assunto: Accessing Oracle From Informix [14562] Hi All, Just two questions for you: Can Informix database access Oracle database from an Informix stored procedure and/or synonym? If this is possible, what do we need for? We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. Regards. ISC. Luis Alejandro Mart=EDnez Mej=EDa Jefe de Operaci=F3n y Bases de Datos Grupo SID ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Yes, there is a Linux build of EGM. You can consult Platform Availability for the Informix products, including the EGM, on this page: http://www-01.ibm.com/software/data/informix/pubs/roadmaps.html (on your right, there is an xls file that is kept up to date; link: 'Download the spreadsheet'). Regards, Veronica. > To: ids@iiug.org > From: David.Reed@tollink.co.za > Subject: RE: Accessing Oracle From Informix [14566] > Date: Mon, 19 Jan 2009 06:01:48 -0500 > > Would this product (Informix Enterprise Gateway Manager) also work on Linux > Redhat? > Regards > David > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alberto > Pessonio > Sent: 17 January 2009 13:25 PM > To: ids@iiug.org > Subject: RES: Accessing Oracle From Informix [14563] > > Hi there!!! > > You must buy an Informix tool called "Informix Enterprise Gateway Manager 7.31 > XD?" on the latest version. With this product, you can access databases such > as Oracle, Sybase, Teradata, and others. > > Best regards, > > Alberto Romeu Pessonio Filho > IBM Informix Certified System Administrator V7 > IBM Certified Managing and Optimizing Informix Databases V7 > DBA Informix/DB2 UDB/SQLServer/Oracle > albasic@gmail.com > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis > Alejandro Martínez Mejía > Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 > Para: ids@iiug.org > Assunto: Accessing Oracle From Informix [14562] > > Hi All, > > Just two questions for you: > > Can Informix database access Oracle database from an Informix stored procedure > and/or synonym? > > If this is possible, what do we need for? > > We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. > > Regards. > > ISC. Luis Alejandro Martínez Mejía > > Jefe de Operación y Bases de Datos > > Grupo SID > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Stay up to date on your PC, the Web, and your mobile phone with Windows Live http://clk.atdmt.com/MRT/go/119462413/direct/01/
It's available for every currently supported platform FAIK. Art On Mon, Jan 19, 2009 at 6:01 AM, David Reed <David.Reed@tollink.co.za>wrote: > Would this product (Informix Enterprise Gateway Manager) also work on Linux > Redhat? > Regards > David > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alberto > Pessonio > Sent: 17 January 2009 13:25 PM > To: ids@iiug.org > Subject: RES: Accessing Oracle From Informix [14563] > > Hi there!!! > > You must buy an Informix tool called "Informix Enterprise Gateway Manager > 7.31 > XD?" on the latest version. With this product, you can access databases > such > as Oracle, Sybase, Teradata, and others. > > Best regards, > > Alberto Romeu Pessonio Filho > IBM Informix Certified System Administrator V7 > IBM Certified Managing and Optimizing Informix Databases V7 > DBA Informix/DB2 UDB/SQLServer/Oracle > albasic@gmail.com > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis > Alejandro Martínez Mejía > Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 > Para: ids@iiug.org > Assunto: Accessing Oracle From Informix [14562] > > Hi All, > > Just two questions for you: > > Can Informix database access Oracle database from an Informix stored > procedure > and/or synonym? > > If this is possible, what do we need for? > > We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. > > Regards. > > ISC. Luis Alejandro Martínez Mejía > > Jefe de Operación y Bases de Datos > > Grupo SID > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Thanks so much for the help!! ISC Alejandro Martínez Mejía Jefe de Operación y Bases de Datos Grupo SID -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Art Kagel Enviado el: lunes, 19 de enero de 2009 08:36 a.m. Para: ids@iiug.org Asunto: Re: Accessing Oracle From Informix [14569] It's available for every currently supported platform FAIK. Art On Mon, Jan 19, 2009 at 6:01 AM, David Reed <David.Reed@tollink.co.za>wrote: > Would this product (Informix Enterprise Gateway Manager) also work on Linux > Redhat? > Regards > David > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alberto > Pessonio > Sent: 17 January 2009 13:25 PM > To: ids@iiug.org > Subject: RES: Accessing Oracle From Informix [14563] > > Hi there!!! > > You must buy an Informix tool called "Informix Enterprise Gateway Manager > 7.31 > XD?" on the latest version. With this product, you can access databases > such > as Oracle, Sybase, Teradata, and others. > > Best regards, > > Alberto Romeu Pessonio Filho > IBM Informix Certified System Administrator V7 > IBM Certified Managing and Optimizing Informix Databases V7 > DBA Informix/DB2 UDB/SQLServer/Oracle > albasic@gmail.com > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis > Alejandro Martínez Mejía > Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 > Para: ids@iiug.org > Assunto: Accessing Oracle From Informix [14562] > > Hi All, > > Just two questions for you: > > Can Informix database access Oracle database from an Informix stored > procedure > and/or synonym? > > If this is possible, what do we need for? > > We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. > > Regards. > > ISC. Luis Alejandro Martínez Mejía > > Jefe de Operación y Bases de Datos > > Grupo SID > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks Did anybody successfully used this product between: SCO Unix / IDS7.x / Informix 4GL 6.x -- Connecting to -- Win XP / Oracle Express or RedHat Linux / IDS11.x / Informix 4GL 7.x -- Connecting to -- Win XP / Oracle Express Regards David -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Veronica Gomes Sent: 19 January 2009 15:47 PM To: ids@iiug.org Subject: RE: Accessing Oracle From Informix [14568] Yes, there is a Linux build of EGM. You can consult Platform Availability for the Informix products, including the EGM, on this page: http://www-01.ibm.com/software/data/informix/pubs/roadmaps.html (on your right, there is an xls file that is kept up to date; link: 'Download the spreadsheet'). Regards, Veronica. > To: ids@iiug.org > From: David.Reed@tollink.co.za > Subject: RE: Accessing Oracle From Informix [14566] > Date: Mon, 19 Jan 2009 06:01:48 -0500 > > Would this product (Informix Enterprise Gateway Manager) also work on Linux > Redhat? > Regards > David > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alberto > Pessonio > Sent: 17 January 2009 13:25 PM > To: ids@iiug.org > Subject: RES: Accessing Oracle From Informix [14563] > > Hi there!!! > > You must buy an Informix tool called "Informix Enterprise Gateway Manager 7.31 > XD?" on the latest version. With this product, you can access databases such > as Oracle, Sybase, Teradata, and others. > > Best regards, > > Alberto Romeu Pessonio Filho > IBM Informix Certified System Administrator V7 > IBM Certified Managing and Optimizing Informix Databases V7 > DBA Informix/DB2 UDB/SQLServer/Oracle > albasic@gmail.com > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Luis > Alejandro Martínez Mejía > Enviada em: sexta-feira, 16 de Janeiro de 2009 22:37 > Para: ids@iiug.org > Assunto: Accessing Oracle From Informix [14562] > > Hi All, > > Just two questions for you: > > Can Informix database access Oracle database from an Informix stored procedure > and/or synonym? > > If this is possible, what do we need for? > > We are running IDS 10.0 on HPUX 11.23 IA64 & Oracle 10 on Win2003 Box. > > Regards. > > ISC. Luis Alejandro Martínez Mejía > > Jefe de Operación y Bases de Datos > > Grupo SID > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Stay up to date on your PC, the Web, and your mobile phone with Windows Live http://clk.atdmt.com/MRT/go/119462413/direct/01/ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.