PCase is a professional ERD modeler for OpenEdge Databases and fully integrated into the OpenEdge Studio. It allows import, create and maintain database versions, document the structure and generate ABL code from DB structure.
The Tools4Progress (PCase, Skin-Client, Viper) are created for Progress OpenEdge.
These tools extend the abilities of OpenEdge in a practical way:
PCase is the better Data Dictionary, with DB visualization, fast access to all entities (Table, Fields, Indexes…), table relations and project meta data.
PCase is fully integrated into the OpenEdge Studio. It supports the full range of DB structure administration processes in a user friendly, wizard based way. Loading schemes via DB connect or from .df file as DB model (in PCase called a project) makes an inventory of existing DBs. For new projects, PCase starts with an empty worksheet.
The project can completely maintained in PCase, all physical and logical OE DB structures can be handled. Two project versions, two projects or a project and an OpenEdge DB can be compared. The changes (add, delete, change) then will be displayed in a clear tree structure. A DB structure can be updated on line.
ABL macros enable powerful code generation from DB structures. The possibilities are limitless: Business Entities, SQL DDL, JSON, ABL classes...
The schema and meta schema of a database contains very valuable information. This information can be used as a bridge between the DB and the application, in form of generated code and mappings. Customer use the macros generate: Trigger, Business Entity creation, schema export for third party products, Temp-Table and DataSet declaration, SQL DDL creation and much more.
PCase has numerous level of these information which are on the OpenEdge 'physical' level (Tables, Fields, Areas…) and on 'logical' levels (Projects, Sub-views, Relations, Custom properties…). On any of these levels macros can be activated via the macro start button. These macros are OpenEdge ABL classes.
Proven strategies for application modernization (from Character, Standard Progress Client/Server, ADMx, DWP, Dynamics…) are ready to use.
Most databases in the OpenEdge world are mature DBs, so first goal of using PCase is often documentation. The import process put all tables in the default Sub-View, which is called "Data Dictionary". Typical OpenEdge systems in the market have 200 (CRM) to 2000 (ERP) tables. Arranging that much tables in a diagram is a futile attempt.
Organizing a larger DB in PCase starts with creation of Sub-Views. Then adding table relations will show how the tables are connected. PCase allows any kind of table relations, including some irregular. to allow the representation of real world databases. Examples are different field types [e.g. charfield = intfield], value relations [e.g. cust.type = "A"] or expression relations [e.g. cust.num = int(substring(somestrangecode, 4,6))].
Becoming more familiar with OF-1 (demos, workshops, PoC, training...) helps to make the right choice and finally the customer is able to work independently.
Starting with PCase is simple: download, installation and then work with PCase. Even in an unregistered version of PCase most tasks can be done, and for testing purposes we offer a cost free time limited license.
There are various resources for PCase: