I need to get a UML (or alike) DB architecture view out of a database (in this case Oracle) by simply providing needed credentials (or otherwise). Please, advice any tools that you use/have used to accomplish the same purpose.
+2
A:
Enterprise Architect can reverse engineer a database relationship diagram.
From Oracle: SQL Developer Data Modeler
Mitch Wheat
2010-10-29 08:48:43
Thanks for Data Modeler hint.
den-javamaniac
2010-10-29 10:01:02
+1
A:
Comercial tool the best case is PowerDesigner (by Sybase http://www.sybase.com/products/modelingdevelopment/powerdesigner) - distributed in multiple packages including DBA tool Architect, Developers ...
Dewfy
2010-10-29 08:50:20
+1 - Our DataArchitect uses it at our place, it's very powerful and has lots of great features.
Adrian K
2010-10-29 09:41:17
A:
There is a confusion between Database design related to business entities and UML which is an object approach. EA and Sysbase provides a reverse of a database inside a dabase diagram but not an UML diagram.
A solution for Oracle is to use EclipseUML Omondo to create the bridge between database and model. See the tutorial how to reverse a database at:
Fully disagree. Sybase allows you convert from database to UML (object-oriented model), or vise-verse - to create DB from object diagram
Dewfy
2010-10-29 10:55:01
There's actually no need in entity relationship I just need an architectural overview (tables, connections, fields). Besides question is not particularly about java (though I liked it).
den-javamaniac
2010-10-29 11:03:57