Detailed instructions to reverse engineer old Oracle 9i database

[Richard Freggi]

I've been reading up this forum and googling on how to reverse engineer Oracle 9i with my EA version 13.10 professional (I don't have the data modeler extension), but I'm confused.

1. Does the recommendation to NOT use the Microsoft OBDC driver apply to reverse engineering?  Or does it apply just to using Oracle as model repository
2. If I need to install the Oracle OLE driver, do I need to install the instant client as well (400MB - hugh)?  I won't need SQLPLUS client etc. - only reverse engineering (query the dba views).  Or can I just unzip the driver and install that?  Can I get away by just installing sqora32.dll in my Windows directory?
3. Any detailed instructions out there for successful OBDC or OLE connection for the purpose of reverse engineering 9i?

Many thanks

[koenvanthiel]

Hi,

I succeeded in building a connection with the EA data base builder (EA 14) with Oracle DB.
I installed the 'Oracle in OraClient12Home1_32bit'
The tables and packages can be synchronised now.
 I only have a problem with the size of the package body and package specifications, which in the reverse engineering process have a max cap on 32 kb (will create another topic on this forum for this).

Kind regards,