Consultor Eletrônico

Status: Verified

GOAL:

Does Progress have tools to create Entity Relationship Diagrams?

GOAL:

Does Progress have tools to create an ERD?

GOAL:

How to create diagrams of the Database structure using Visio

FACT(s) (Environment):

Windows
Progress 9.x
OpenEdge 10.x

FIX:

You will likely need a third party tool to do this if it is possible at all. All of the Progress schema information is exportable by dumping the data definitions (.df). These are normally used to recreate an existing database structure.

Although this is not supported by Progress, it has been done using the following steps with Visio.
Here are the steps, using Visio 2000 Professional Edition:

1. Install Progress.
2. In Microsoft ODBC Data Source Administration create a new DSN. Test the
connection.
3. In Visio 2000 select File>New>Database>Database Model Diagram.
4. In Visio 2000 select Database>Options>Drivers.
5. A new Database Drivers window pops-up.
6. Select ODBC Generic Driver and then setup.
7. Select MERANT Driver, then OK.
8. Select Database>Reverse Engineer. New Reverse Engineer Wizard Pops-up.
9. Select ODBC Generic driver. Your DSN will appear in window. Select it
then select next.
10.A Connect Data Source window pops-up. Enter your user name and password
and then select OK.
11.Acknowledge the warning box that appears. Select your object types. and
then select next.
12 Select your Tables to be viewed then select next and finish.
13.An output window displays the reverse engineering process and the amount
of time to accomplish the task.
14.A table window appears with the requested tables from the database.
15.Click on the table box and drag it onto the Visio working area. The
database table information is depicted.
16 Double clicking on the table in the work area produces a Database
Properties window with all sorts of info.
17.After that the data can be manipulated.