Home » SQL & PL/SQL » Client Tools » ERD on views (Oracle 11gR2/12c)
ERD on views [message #640519] Thu, 30 July 2015 02:08 Go to next message
ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA
Member
Hello All,

Is there any ERD which could help create ERD on views? I tried few of them like ER Studio/ERWin/SQL Developer Data Modeler but did not work. They claim to support views in an ERD but relations (auto detect) doesn't show up. I cannot manually add them either.

Most of the Microsoft products expose their systems as views (example config mgr), i wonder how do they document their views?
Re: ERD on views [message #640679 is a reply to message #640519] Mon, 03 August 2015 09:04 Go to previous messageGo to next message
thatjeffsmith
Messages: 71
Registered: July 2009
Location: Raleigh, NC
Member

We JUST added support for this in the latest version of SQL Developer Data Modeler, 4.1

http://www.thatjeffsmith.com/wp-content/uploads/2015/01/modeler41_view1.png
Re: ERD on views [message #640680 is a reply to message #640679] Mon, 03 August 2015 09:04 Go to previous messageGo to next message
thatjeffsmith
Messages: 71
Registered: July 2009
Location: Raleigh, NC
Member

Also I'm assuming you mean the relational diagram...
Re: ERD on views [message #640691 is a reply to message #640680] Mon, 03 August 2015 16:19 Go to previous messageGo to next message
ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA
Member
Thanks! I am going to try it.
Re: ERD on views [message #641275 is a reply to message #640691] Wed, 12 August 2015 16:28 Go to previous messageGo to next message
ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA
Member
I tried SQL Developer Data Modeler, 4.1. It would kind of satisfies my need but it is very unstable.
1) keeps crashing
2) Image option for adding a logo image i useless. Cannot hold hi-res pictures. Cannot resize them. Sometimes it just hangs.
3) There is no automatic relationship resolution between views (simple or complex) based on column names.
It is manual work to create the relationships (imagine you have several hundred tables)

It is free, i cannot complain.
Re: ERD on views [message #641351 is a reply to message #641275] Thu, 13 August 2015 09:13 Go to previous message
thatjeffsmith
Messages: 71
Registered: July 2009
Location: Raleigh, NC
Member

You can't complain, yet you just did. But that's OK, it's the Internet.

1. My car won't start, why? You need to give me more information. What sort of error stack is it crashing with? You mention several hundred tables, my first guess is that your JVM needs more memory.
2. Big pictures, dropping into a model..guessing again, memory.
3. Yes there is. You just have to know where to look for it.

http://2.bp.blogspot.com/_HTPuwjEAZfk/TUn1WpMYmsI/AAAAAAAAAYk/NDMf3ZUVUns/s1600/discover_menu.png
Previous Topic: Displaying Object Name after creating it in sql plus
Next Topic: Nightly utility to generate table for report
Goto Forum:
  


Current Time: Fri Jan 19 16:43:58 CST 2018

Total time taken to generate the page: 0.02055 seconds