Import Data Model from Oracle Database

[LarsB]

Hi,

I am trying to import an existing data model from an Oracle 10g database for the purpose of reengineering. The  EAP version is 7.10.844. When I use the Oracle driver I get a protocol error. Using the Microsoft Oracle I get a connection to the DB but I don't see any tables from our sceme. Sequences and procedures under sys user are visible. Any suggestions?

[arose]

I have a similar problem.  

Attempting to import a DB schema from Oracle using the MS ODBC driver, I can connect to the Oracle database, but get an empty list of tables.  

Using the Easysoft ODBC Driver for Oracle, I can get the list of tables, and even import one or two tables at a time, but if I select a few more tables (say 5 or 6) or all of the tables, it begins to perform the import, and dies.  

The Microsoft error report indicates a failure in:
AppName: ea.exe       AppVer: 7.1.0.827       ModName: esoracle.dll
ModVer: 3.2.0.3       Offset: 0000626f

Both the MS and Easysoft drivers work properly using MS Query, and Toad, so I wonder if the problem might be in the way EA is accessing the driver.

Does anyone know of someone who has successfully imported an Oracle schema into EA?

[almussio]

Hi...

I had the same problem. I used the Oracle ODBC driver to solve it.
You can download this driver at: http://www.oracle.com/technology/software/tech/windows/odbc/index.html

Good luck!

[RoyC]

In the Help - (Connect to an) Oracle Data Repository and, more recently, Set Up a Database Repository - there are specific instructions to select the Oracle Provider for OLE DB and not select Microsoft OLE DB Provider for Oracle. Enterprise Architect can not operate properly with the Microsoft provider.

[LarsB]

Hi,

by chance, I found out. One has to use the oracle odbc driver. Furthermore, I had a problem with ldap. After renaming the file C:\Programme\Ora102\NETWORK\ADMIN\ldap.ora everything works fine.

Greetings, Lars