Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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>;
|
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