Create a Progress OpenEdge Repository

Return to Introduction  Previous page  Next page

Note: This feature is available in the Corporate edition only.

Before creating a Progress OpenEdge data repository, you must have OpenEdge and MDAC 2.6 or 2.7 installed, and access permission to create a new database. Please note that setting up OpenEdge and the issues involved are beyond the scope of this manual. Consult your OpenEdge documentation for guidance.

Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script is up to you.

·Registered users can obtain the scripts from the Registered Corporate edition Resources page of the Sparx Systems website at
·Trial users can obtain the scripts from the Corporate edition Resources page of the Sparx Systems website at

Creating the Data Repository

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 want to use an existing .EAP model, you can upsize it.

1.Run proenv from the OpenEdge menu: Start->Programs->OpenEdge->proenv.
2.Create database: prodb <database_name> empty.
3.Start 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.Open Admin->Security->Edit User List.
6.Close Data Administration.
7.Open SQL Explorer Tool, connect as 'sysprogress'.
8.Add user:
create user 'user','password';
9.Grant privileges:
grant dba, resource to <user>;

Tip: Use the Project Data Transfer function to upload a basic model into the repository.