Visio & how to connect to a data source

Question

 

I'm very new to Visio 2003 Prof.  I just want to diagram a schema/db from Oracle. 

1. How can I connect to the schema/db through Visio?
2. I want to make sure by doing this I don't change anything on the schema/db.  From what I read that reverse enginerring might make changes to some of the tables.

Just want a simple diagram showing all the tables and how they link.

Thank You all for any help

Jerry

Answer 1

Hi,

I haven't done this for oracle but, I have done this for SQL Server. I think the procedure is same for Oracle too. What you need to do, make a ODBC connection to Oracle.

 

- Start a new diagram from File->New->Software and Database

- This will give you a blank page and Database menu will show up

- Click on Database menu and select Reverse Engineering..

- In the dialog box you will see options for creating ODBC connection to the Oracle Database

- Once connected to the database select the tables you want in your diagram.

 

Hope this helps..

Answer 2

Himadri,

Will the reverse engineering have any effect on my database(Tables, Procedures, etc..)?

When I went to File -> New I didn't have "Software and Database".  They were two different selections.  I opened a blank drawing and went to database but i don't want to do the reverse engineering till I know I won't change anything on the database.

 

Thank you for your help

 

Jerry

 

Answer 3

Nothing will change in your database.

---

Computer systems engineering, information technologies and computer sciences.

Answer 4

Hi to All Respected Gurus!

I am trying to do the same for creation of ERD in Microsoft Viso with connectivity of Oracle Database but I am receiving tables with unknown language. Picture is attached, please help in this.

Thanks & Regards

Muhammad Uzair Awan

---

Muhammad Uzair ORACLE Application Developer