Oracle Reverse Engineer

[Paolo F Cantoni]

One of our users is trying to reverse engineer an Oracle DB.

We're usually a SQL Server shop, so I haven't done one of these for ages.  Using b1351, he seems to be doing all the right things on the Import from ODBC dialog.  Are there any "gotchas", "secret sauces" that we should be using?

The result is that after asking it to reverse engineer everything, for the tables, we get the table objects, no features or relationships - just empty boxes...

TIA,
Paolo

[Sunshine]

Done a couple of oracle databases and never been able to get the relationships either. Fortunately the primary keys and foreign keys where named consistently that i wrote a script to create the relationships. Not ideal but i ended up with the desired result.

[Mauricio Moya (Arquesoft)]

Are you using legacy reverse engineering? Have you tried Database Builder?

[hd]

Make sure the ODBC driver is the Oracle driver and not the "Microsoft ODBC for Oracle" driver.

[Paolo F Cantoni]

Are you using legacy reverse engineering? Have you tried Database Builder?

Yes (I think so), I'll give it a go!

Paolo
[EDIT: I tried it, but it seems to me that the import DB Schema is the SAME dialog as the non-Database Builder route.  I tried an SQL Server DB (as my user isn't in yet) and both routes worked fine.]

[Paolo F Cantoni]

Make sure the ODBC driver is the Oracle driver and not the "Microsoft ODBC for Oracle" driver.

Will do, when I get in to work.

I should get both the columns AND the FK relationship, yes?

Paolo

[Glassboy]

Make sure the ODBC driver is the Oracle driver and not the "Microsoft ODBC for Oracle" driver.

Will do, when I get in to work.

I should get both the columns AND the FK relationship, yes?

Paolo

It's been a few years since I reverse engineered an Oracle DB but I remember getting everything.

[Paolo F Cantoni]

A combination of V14 and the DB Builder (we were using the Oracle ODBC drive - 11.0.2.1) did it.

We imported 2355 tables, 159 views etc...   However, we got a Resources Exceeded message and thought it might have damaged the FK Constraint import.  But it seems that this product hasn't got any FK Constraints!

Paolo

[Geert Bellekens]

But it seems that this product hasn't got any FK Constraints!

Who in his right mind would design a database without FK constraints! 
Ohh, um, ... nevermind... 

Geert

[Richard Freggi]

I'm not an Oracle expert but any RDBMS should spit out the schema DDL code as a text file on request.  Then just run the DDL in EA to recreate the schema as a physical data model?

[qwerty]

Why do it the simple way if you can go through a variety of ODBC and native drivers instead?

q.

[Sunshine]

I'm not an Oracle expert but any RDBMS should spit out the schema DDL code as a text file on request.  Then just run the DDL in EA to recreate the schema as a physical data model?

Interesting I didn't know you could run DDL in EA to recreate the schema. I've search the help and can't find anything on that particular feature. Care to share a reference on how to access it?

[Sunshine]

Why do it the simple way if you can go through a variety of ODBC and native drivers instead?

q.

Probably because the help tells you to use ODBC drivers. Haven't found out how to run DDL in EA yet though. Still searching in the online help for that feature.
https://www.sparxsystems.com/downloads/resources/booklets/uml_code_engineering.pdf

[Eve]

EA can't reverse engineer a DB schema from a sql file.

[qwerty]

Yes, I know that EA can't RE a DDL. Unfortunately there's no emphasis for irony/sarcasm in texts.

q.