Re: Oracle Transparent Gateway
Date: 1998/10/22
Message-ID: <362FF05D.1F0147FC_at_us.oracle.com>#1/1
Dawn,
Oracle has a bunch of different gateways. They basically into two categories:
- Transparent Gateways, which provide SQL access
- Procedural Gateways, which provide access to business logic (transactions)
We have transparent gateways for Sybase, Informix, SQL Server, DB/2, and most of the other relational databases. For SQL access to mainframe datastores such as IDMS, Datacom, and Model 204 we have the Transparent Gateway for EDA/SQL (TG4EDA). This product does use Information Builders EDA/SQL Server. So, in effect, it is a gateway to a gateway. EDA/SQL knows how to submit and process SQL to all of the mainframe data stores. By putting an Oracle Transparent Gateway in front of EDA/SQL, you essentially make the mainframe data store look like Oracle. You can even due distributed transactions protected by Oracle's Two Phase Commit mechanism.
I have some experience with the TG4EDA. You can email me privately with any questions.
Tim Taylor
Technical Account Manager
Oracle Government, Education, and Health
Reston, VA
dawnwv_at_my-dejanews.com wrote:
> I was told that Oracle Transparent Gateways contains EDA/SQL as the base
> of the Data Acquisition function. Does anyone know if there is any
> truth to this statement? Any input would be welcome.
>
> Thanks,
> Dawn
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 22 1998 - 00:00:00 CEST