OraFAQ Forum: General » Diagramming the system

Home » Other » General » Diagramming the system

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

Diagramming the system [message #171625]

Wed, 10 May 2006 12:01

Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada

Member

I would like to diagram all our databases to capture everything from oracle, access, spreadsheets, adabas, etc. If it is a production data source it makes the diagram. Then to be real fancy .... I can click on a data source and it would drill down into an erd (if created).

Which tool would be best for such a task? Designer? Visio? Other?

Report message to a moderator

Re: Diagramming the system [message #171638 is a reply to message #171625]

Wed, 10 May 2006 15:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Designer is a good place to start but I don't think it will handle the spreadsheets. Actually I can'tthink of anything that will 'look' at the spreadsheets.

David

Report message to a moderator

Re: Diagramming the system [message #171646 is a reply to message #171638]

Wed, 10 May 2006 18:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I thought about your problem more over breakfast, and Access or a real windows based application is probably the best bet as the PC has ODBC connections to Oracle and Adabas. Access also had a builtin connection to spreadsheets until this last law suite and update to Office. But if you use an older version you may be able to drill into spreadsheets.

You could, of course, use Oracle 10g and Application Express and convert all your Access databases and Excel spreadsheets to Oracle and then you would only have to worry about getting Oracle to connect to the Adabas environment. Wink

David

Report message to a moderator

Previous Topic:	Project
Next Topic:	noramlization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 20:15:43 CDT 2025