reverse engineering via oracle

[master]

Hi all,

I use EA version 7.0 to connect oracle 11g for reverse engineering. when I connect to oracle , EA doesn't show my tables. I checked it with oracle 10g and it works correctly but I don't know why it has a problem with oracle 11g. can anybody help me with this problem.

Thanks,
master  

[Martin Terreni]

1) check that the shcema owner  is really the owner of the tables and they are part of the selected schema ,not links to other tables (however s it called in Oracle)
2) check that you have the correct driver (and not, having Toad openning the DB is not enough)
Sorry, all i could think of...

[master]

first of all, thanks Martin for your remarks.

I checked the schema owner and it's the table owner too.
about driver, I use ODBC driver thru my oracle client 11g. At first I had used the oracle client 10g to connect the server and it didn't work so I used the client 11g but it hasthe same problem.

Meanwhile, I used Power designer software and it connected the database and model that correctly. So, I don't think there is a problem in schema. this problem may refer to oracle 11g security features or something like that  :-/

[«Midnight»]

There have been similar problems reported for Oracle connections for some time. Almost all seem to be related to some combination of: the client-side driver used, the version of the client-side driver, and Oracle security settings.

Many failed attempts are resolved by ensuring that you are using only a client-side driver from Oracle, not the Microsoft driver. Just having installed the Oracle driver is not enough; make sure you choose the Oracle driver when you set up the EA connection. Neither EA nor Windows will make this choice for you.

Oracle security can catch you at either the client or server side. This often shows up when you can see everything you need from a connection outside of EA, but not when EA connects. You may have to play around here. A possible workaround is to recreate the structure of the target database without data, then set up more generous permissions. Watch out for situations where 'access' to the data is actually via views or stored procedures rather than permissions on the tables themselves. This is a common Oracle paradigm that will stop EA in its tracks.

You might want to send a quick email to Sparx support mentioning the complete version number of the Oracle 11g client. They may have insights on whether some specific versions have issues with EA. [Or they might discover an issue which then can then resolve.]

David