OraFAQ Forum: General » Tool for ER-Like Diagram

Home » Other » General » Tool for ER-Like Diagram (Oracle DB 11.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tool for ER-Like Diagram [message #604723]

Fri, 03 January 2014 07:58

suddhasatwa_oracle
Messages: 24
Registered: January 2014

Junior Member

Hello All,

I have two schemas A and B. Both are on same database running on Oracle 11.2.0.1. I have 3 tables in A from where I am loading data into B into one table. To do so I am using a simple SQL Query. After providing all the grants and after creating the required synonyms, I am able to run the query and it is inserting the correct records into the target table in B.
Now, I would like to generate a diagram of this operation. I am in serious need of a easy to use tool which can be used to create a diagram showing this data flow with details like which columns are getting selected from A to B by my SQL Query.

Kindly advice if there are any such tools available.

For any queries, kindly reply.

Best Regards,
Suddhasatwa

[Updated on: Fri, 03 January 2014 07:59]

Report message to a moderator

Re: Tool for ER-Like Diagram [message #604724 is a reply to message #604723]

Fri, 03 January 2014 08:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Kindly advice if there are any such tools available.
I am not aware of any such tool.

said SQL does not have to reside within the database & even if it did reside within the database said tool would have to parse every SQL in order to produce desired results.

Report message to a moderator

Re: Tool for ER-Like Diagram [message #604898 is a reply to message #604724]

Sun, 05 January 2014 20:24

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Oracle's SQL Developer Data Modeller apparently has some kind of Data Flow Diagram capability. I have not looked into it yet myself, but from what I have read it sounds appropriate, although I doubt it would display at the column level. You could reverse engineer the tables into the model and then create the data flow manually. Try it out.

http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/datamodeler-087275.html?ssSourceSiteId=ocomen

Ross Leishman

Report message to a moderator

Previous Topic:	SAP Training in Chennai
Next Topic:	login and password forgotten in oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 06:04:36 CST 2024