Progress OpenEdge Repository

Before creating a Progress OpenEdge data repository, you must have OpenEdge 10.0B03, 10.1B01 or later, and MDAC 2.6 or higher installed, and access permission to create a new database. Creating an OpenEdge database is beyond the scope of this User Guide - refer to your OpenEdge documentation for assistance.

Having created your OpenEdge database, use the SQL script provided by Sparx Systems to create the required table definitions for Enterprise Architect. You can obtain the scripts from the Sparx Systems website, on the:

Registered Corporate edition Resources page (Registered users)
Corporate edition Resources page (Trial users)

How to

Step

Action

1

Run proenv from the OpenEdge menu: Start | Programs | OpenEdge | proenv.

 

2

Create the database:

prodb <database_name> empty.

 

3

Start the database server:

proserve <database_name> -S <port_number>

 

4

Open Data Administration to add a user:

prowin32 -db <database_name> -S <port_number> -p _admin -rx

 

5

Select Admin | Security | Edit User List.

 

6

Close Data Administration.

 

7

Open the SQL Explorer Tool, connect as sysprogress.

 

8

Add a user:

create user 'user','password';

commit;

 

9

Grant privileges:

grant dba, resource to <user>;
commit;

 

Notes

This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions
Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic

Learn more