Create a Progress OpenEdge Repository

Creating a Progress OpenEdge database is fully documented in the product information provided with your OpenEdge installer.

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

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

Create the repository

Step

Action

1

From the Windows Start menu, run proenv in OpenEdge; that is: 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 users:

 

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

The Database Administration dialog displays.

 

5

Select Admin | Security | Edit User List and set up one or more user IDs from the Edit User List dialog, as follows:
 

1.  Click on the Add button; the Add User dialog displays.
2.  Complete the User ID, User Name and Password fields, and click on the OK button; the Password Verification dialog displays.
3.  Verify the password and click on the OK button; the Edit User List dialog redisplays.
4.  Repeat the process for the next user or, if finished, click on the OK button; the Database Administration dialog redisplays.

 

6

Close Database Administration (Database | Exit).

 

7

On the proenv command prompt, type:

 

sqlexp -user <user id> -password <password> -db <database_name> -S <port_number>

 

The SQLExplorer> prompt displays.

 

8

Grant privileges to the administrator user:

 

SQLExplorer>grant dba, resource to oe_user;

SQLExplorer>commit;

SQLExplorer>exit

 

9

Execute the OpenEdge_EASchema.sql script, with the following command:

 

sqlexp -user oe_user -password sparx  -db <path\to\database> -S <port_number> -infile <path\to\OpenEdge_EASchema.sql>

 

 

After creating a Progress OpenEdge data repository in Enterprise Architect, you must set up the Progress OpenEdge ODBC driver.

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