Oninit cdi / Archive
Talk to an expert →

Informix to Oracle interface

Posted in 2013

Topics: Platform-Specific Issues

MARK CRUTCHER — — source: IIUG Forums & Mailing Lists

We have IDS 10 on a Sun box running Solaris 5.9, and want to be able to access an Oracle table on another machine from within Informix. Specifically, we want to be able to make a view in the Informix database that points to this external Oracle table. Is this possible, and if so, how is it done?

↪ replying to MARK CRUTCHER
Art Kagel — — source: IIUG Forums & Mailing Lists

You can only do that using the IBM Informix Enterprise Gateway which is a separately licensed product. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 28, 2013 at 4:11 PM, MARK CRUTCHER <mcrutcher@national.aaa.com>wrote: > We have IDS 10 on a Sun box running Solaris 5.9, and want to be able to > access > an Oracle table on another machine from within Informix. Specifically, we > want > to be able to make a view in the Informix database that points to this > external Oracle table. Is this possible, and if so, how is it done? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d042ac0e87ec2a004e9fd407e

↪ replying to MARK CRUTCHER
Paul Watson — — source: IIUG Forums & Mailing Lists

ODBC will work > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > MARK CRUTCHER > Sent: Monday, October 28, 2013 3:11 PM > To: ids@iiug.org > Subject: Informix to Oracle interface [31833] > > We have IDS 10 on a Sun box running Solaris 5.9, and want to be able to > access > an Oracle table on another machine from within Informix. Specifically, we > want > to be able to make a view in the Informix database that points to this > external Oracle table. Is this possible, and if so, how is it done? > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary