Visio&如何连接到数据源 [英] Visio & how to connect to a data source
问题描述
我是Visio 2003教授的新手。我只想从Oracle绘制架构/数据库。搜索结果1。如何通过Visio连接到架构/数据库?
2。我想通过这样做来确保我不会更改schema / db上的任何内容。从我读到的反向工程可能会对某些表进行更改。
只需要一个简单的图表显示所有表以及它们如何链接。
感谢大家的任何帮助
Jerry
我没有为oracle做过这个,但是我已经为SQL Server做了这个。我认为Oracle的程序也是一样的。您需要做什么,与Oracle建立ODBC连接。
- 从File->开始一个新图表; New->软件和数据库
- 这将为您提供一个空白页面,数据库菜单将显示
- 单击Database菜单并选择Reverse Engineering ..
- 在对话框中,您将看到用于创建与Oracle数据库的ODBC连接的选项
- 连接到数据库后,在图表中选择所需的表格。
希望这会有所帮助。
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
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..
这篇关于Visio&如何连接到数据源的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!