pcase_logo_white

PCase: Professional ERD modeler for OpenEdge Databases

Seperator

Integrated OpenEdge ERD Modeler

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.

DB Design

PCase is the better Data Dictionary, with DB visualization, fast access to all entities (Table, Fields, Indexes…), table relations and project meta data.

Jump to section

Generate

ABL macros enable powerful code generation from DB structures. The possibilities are limitless: Business Entities, SQL DDL, JSON, ABL classes...

Jump to section

Document

PCase helps a lot to document the DB with tables, table relations, subviews, HTML reports… This is helpful for developers and the customer.

Jump to section

Learn More

There is detailed information about PCase available. This could be explored via the HowTos, YouTube videos, help file, version history and articles.

Jump to section

Are you interested?

We offer a free presentation with demo via internet, it will take only 1 h of your time. Please send a mail to ed.pa1539598417i@1-f1539598417o1539598417 or call +49 (0) 40 – 30 68 03 – 0.

EXPLORE IAP'S TOOLS4PROGRESS

The Tools4Progress (PCase, Skin-Client, Viper) are created for Progress OpenEdge.

These tools extend the abilities of OpenEdge in a practical way:

OF-1 is the Multi-UI/UX Low-Code Development Platform for OpenEdge.

Go to PCase

Skin-Client enables you to modernize and extend your Progress application.

Go to Skin-Client Desktop

Skin-Client Mobile enables App creation without device-specific languages or development environments.

Go to Skin-Client Mobile

Viper brings a programmable 4GL/ABL printing system, which is OS independent.

Go to Viper

Maintain OpenEdge Databases

PCase is the better Data Dictionary, with DB visualization, fast access to all entities (Table, Fields, Indexes…), table relations and project meta data.

OF-1 Business Entity Designer

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.

Read more...

Powerful ABL Macro Support

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.

Read more...

PCase Business Entity Macro Dialog

Documentation and Project Organization

Proven strategies for application modernization (from Character, Standard Progress Client/Server, ADMx, DWP, Dynamics…) are ready to use.

PCase Customer Subview

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))].

Read more...

Learn More

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:

Powerful code generation abilities and database visualization

Stay Updated

PCase is being constantly developed. You either can see the version history of PCase here or stay updated by a newsletter subscription (less than 10 letters per year).

Did we spark your interest or do you have further questions?

If so, then please don't hesitate to contact us. Please call +49 (0) 40 – 30 68 03 – 0 or use the contact form below.