Progress OpenEdge Repository

This topic describes how to create a Progress OpenEdge repository.


  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions.
  • Before starting, you must have OpenEdge, the Progress OpenEdge ODBC Driver, and MDAC 2.6 or higher installed, and you must have the appropriate permission to create a new database.
  • The OpenEdge database must be either version 10.0B03 or version 10.1B01, or later. The process of setting up OpenEdge is beyond the scope of this User Guide; please consult your Progress OpenEdge documentation for further guidance.

Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer.

Create the Repository

To create the OpenEdge repository, follow the steps below:

  1. Run proenv from the OpenEdge menu; select 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, connecting as 'sysprogress'.
  8. Add a user:
    create user 'user','password';
  9. Grant privileges:
    grant dba, resource to <user>;


OpenEdge repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you are using an existing .EAP model, you can upsize it.