Re: Is anyone still using Transparent Gateway for RMS (tg4RMS) ?

From: Syltrem <>
Date: Wed, 22 Feb 2012 13:56:51 -0500
Message-ID: <UTa1r.107051$>

"Hein RMS van den Heuvel" <> wrote in message On Feb 22, 10:25 am, Hein RMS van den Heuvel <> wrote:
> On Feb 22, 9:35 am, "Syltrem" <> wrote:
> You may want to try a brute force solution:
> Once found, define a system logical to point there and try again?

>>Oops, i now see to already tried that and got further.
>>And it looks like you used SDA> SHOW PROC/CHAN to 'see' the open files
>>and found no LOG files. Darn.
>>It should have GW*.NOS files open as data dictionary.
>>In the mean time I received confirmation that this gateway is a an
>>read-only OEM version for the Attunity 'AIS' offering, long out of
>>It may be more productive to investigate a current ODBC , JDBC or
>>ADO.Net connection to RMS offering (preferably from Attunity :-)
>>I also suspect that Change Data Capture is a more convenient (more
>>reliable) way to deal with this transition situation.
>>Attunity may be able to come up with a limited duration license deal
>>for either approach.
>>Hope this helps,

The app needs to see the ROWID. We tried the Connx ODBC but it doesn`t have the ROWID.

I may try the Oracle 10.1 version and see if I can get this one to work instead.

The Attunity product is interesting but probably too costly for this. We will probably change the app that writes to RMS to instead write to Oracle, albeit temporarily, to alleviate the problem. The RMS app will be completely rewritten in the course of this year.

> Btw... you may want to check out Attunity's RMS-CDC offering.
> And can help you keep an Oracle Database up to date in (near) real
> time with changes made to RMS (indexed) files.
> Hope this helps some,
> Hein van den Heuvel
> Attunity
Received on Wed Feb 22 2012 - 12:56:51 CST

Original text of this message