Oracle ODBC Question 3

[sera]

I am currently researching a project that I need to complete eventually. I need to know if what I intend to do is possible. My resident "Oracle expert" told me that I may need to buy a piece of software called a "gateway?" in order to accomplish this. But she also told me that she hasn't looked into doing anything like this for some time, so I should go ahead and post.
Here is what I want to do:

OracleDatabase resides in Oracle.
ParadoxDatabase resides in Paradox.

I would like to create a "live" link between the OracleDatabase and the ParadoxDatabase. The OracleDatabase needs to have access to the data in the ParadoxDatabase. It would be simple if it was the other way around....but I need the OracleDatabase to have a view of the data in the ParadoxDatabase. Does Oracle have something built in like Microsofts ODBC's to handle this? If so can you point me in the right direction?


Sera
I often believe that...
My computer is possessed!

 

[Turkbear]

Hi,
Look into the docs
(

http://tahiti.oracle.com)

about
heterogeneous connections and transparent gateway

( But I'm not sure there is an ODBC driver for Paradox.)

 

[jocave]

The other option, if there is a type 4 (thin) JDBC driver for Paradox, is to load that driver into Oracle's JVM and write Java stored procedures to access the data.

Justin

 

[sera]

Well that tahit.oracle.com site is nice....and it gives me more answers than the oracle.com site did, it also gave me a great bit of reference for future use. I have not started developing with oracle yet (although I will have the opportunity real soon). The oracle site did have a nice listing of FAQs about the differences between Generic Connectivity and Transparent Gateways...

http://www.oracle.com/gateways/gateway_bundles/index.html?faq.html

Paradox does have an ODBC driver...already checked, although it may be a real pain to use. No Offense, but why use Paradox? All it does is make my life miserable....
enough whining...

Jocave, that is a very interesting solution and I will certainly check into it!

Thanks

Sera
I often believe that...
My computer is possessed!