We have a legacy system using Oracle 7.3.4 in AIX. I want to use OWB 11g (in Linux) to connect to this database to extract data using mapping.
I'm thinking thru ODBC, but i have only tried it using excel in windows. Appreciate if you can guide me step by step. Many Thanks!
As far as I know the oracle ODBC driver 2.x which was shipped with Oracle 7 is NOT ODBC level 3 compliant which is a requirement for the database gateway for ODBC.
If you want to continue (without guarantee it will ever work) you need to install on a Windows machine the Oracle client 7.3.4 and its ODBC driver into the first Oracle_Home. Then configure the Oracle 7.3.4 client so that it can connect to the Oracle 7.3.4 database. When the connection is successful, then configure a system ODBC DSN ad test the ODBC connection to the 7.3.4 database.
Now install the Database Gateway for ODBC release 11 into a second Oracle_home on this machine.
The configuration of DG4ODBC is done as described in the My Oracle Support note:
How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit to Connect to Non-Oracle Databases Post Install [Document 466225.1]
Edited by: kgronau on Jul 23, 2012 1:21 PM
OK- found the OWB documentation:
It shows that you can use DG4ODBC to connect to a foreign database, so in general the set up described earlier might be possible. Only limitation is the Oracle ODBC driver whipped with 7.3.4 which is not ODBC level 3 compliant.
it is not needed to transfer the database to Windows.
On the Windows machine you only need to set up the ODBC driver and client which was shipped with 7.3.4 and make sure the ODBC driver is able to connect to the Oracle database.
In a second home you then set up DG4ODBC which will use the ODBC driver to connect to the 7.3.4 Oracle database.
So the connection flow is the Oracle database on AIX connects to DG4ODBC on Windows using SQL*Net. DG4ODBC loads the ODBC driver and connects to the 7.3.4 database.
OWB Oracle 11g Linux ----> (DG4ODBC) Windows (Oracle 7.3.4 client) ----> Oracle 7.3.4 AIX
oracle 11g connects to windows thru dg4odbc. dg4odbc connects to oracle client 7.3 that is in windows also. oracle client 7.3 connects to Oracle 7.3 in AIX.
Is my understanding correct?
OWB connects to your Oracle database on Linux ==>> connects to DG4ODBC on Windows ==> uses the ODBC driver of Oracle 7.3.4 (without any guarantee it will work as it is not level 3 compliant) ==> the ODBC driver connects to 7.3.4 Oracle db on AIX.