Speed Up Development Maintenance andor Migration with Axel

Speed. Up Development, Maintenance and/or Migration with Axel Oberländer and James Ryan

About Tools 4 Plex… • A productivity tool for CA Plex • The story behind the tool • An example in numbers • What do we have right now • Where do we want to go 2 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… A productivity tool for CA Plex Tools 4 Plex has a wide range of functionality This presentation is primarily concerned with the menu options PLEX and Plex. XML 3 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… A productivity tool for CA Plex Menu option: PLEX Assists in creating triples for • datamodel and inheritance definition • creating or changing name triples • creating field values and literals • from. csv, Excel, database schemas, … • … 4 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… A productivity tool for CA Plex Menu option: Plex. XML is one View framework that we use. Tools 4 Plex assists in creating the files necessary to generate the possible Plex. XML dialogs • the user interface • diverse functionality • View controls (buttons, links, …) 5 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… • A productivity tool for CA Plex • The story behind the tool • An example in numbers • What do we have right now • Where do we want to go 6 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… The story behind the tool • • Early 2011 Thomas joined us as a developer. Main skills: software architect, developer, DB-designer, . Net, SQL, … Learning CA Plex was his first task. He explored the Plex model api and quickly began to automate tasks he considered manually repetitive … Tools 4 Plex was born. • Since then, we haven‘t look back 7 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… • A productivity tool for CA Plex • The story behind the tool • An example in numbers • What do we have right now • Where do we want to go 8 Copyright © 2013 CA. All rights reserved.

Positioning Tools 4 Plex Development process: Datamodel design • Build the datamodel (inside CA Plex) • Entities, Views & Indexes • Fields, Labels & Values • Relations • …. • Analyse the functional groups, determine inheritance • Define and create the inheritance triples • Develop functionality • time passes, new requirements, new systems, …. • Refactoring and migration 9 Copyright © 2013 CA. All rights reserved. Tools 4 Plex Tools 4 Plex

Positioning Tools 4 Plex The quintessence of Tools 4 Plex 10 Copyright © 2013 CA. All rights reserved.

Positioning Tools 4 Plex What is mass modeling • add multiple triples • change multiple triples • name refactoring • language translation • model translation 11 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… • A productivity tool for CA Plex • The story behind the tool • What do we have right now • Where do we want to go 13 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu PLEX Create triples from Schema selection and preview of triples to generate 14 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu PLEX Creating triples Results in CA Plex Object. Browser All objects made real. Fields inherit from the required base fields. 15 Copyright © 2013 CA. All rights reserved.

An example in numbers… Textile industry - ERP/PPS system written in Synon • • • 500 Entities 8. 500 Fields with 14. 400 Labels 215. 500 Values (with inherited values, absolute 33. 500) 5. 400 Attributes 18. 500 Impl. Names & File. Names (autonaming? ) 400 Qualifier 490 Physical tables 1. 470 Views = 85. 000 Object definitions 16 Copyright © 2013 CA. All rights reserved.

An example in numbers… Example in numbers Textile industry - ERP/PPS system written in Synon = 85. 000 Object definitions / triples / … + error correction + quality control = how long do you think? With Tools 4 Plex in less than one day ! Without the definitions necessary inside the tool to describe the naming rules, datatype mapping, etc. This means another 2 -3 days. 17 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu PLEX . csv-import Example: import of a db-schema in. csv-format 20 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu PLEX Add triples Depending on the selected objects and verb names, new triples are created. Example: Ent. Is. Ent DEMO 21 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Change triples Hauptfunktionen Die. PLEX Plex. Box Create (Templates) 22 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Process Hauptfunktionen Die. PLEX Plex. Box Create triples (Templates) What was just shown, can be packaged into process-steps (which can contain triple templates) and executed against selected objects. 23 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Template triples Hauptfunktionen Die. PLEX Plex. Box Create triples View of predefined triple-templates (Templates) 24 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Process Hauptfunktionen Die. PLEX Plex. Box Create triples (Templates) Additional process-steps can be added that execute things like: • • • Delete files from GEN-directory Generate and Build operations Groupmodel operations Tools 4 Plex-database operations Check future length of automatically generated implnames and filenames • … DEMO 25 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Model. Viewer Hauptfunktionen Die. PLEX Plex. Box Create triples (Templates) Left (Tree. View) Explore all types of objects with its target objects, triples, attributes and dependencies Right (Details) • Object. Properties • Action. Diagram if available DEMO? 26 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Define virtual triples fields Hauptfunktionen Die. PLEX Plex. Box Create (Templates) Left (Tree. View) All entities with all their attributes, to define the fields that can act as virtual fields, when not defined in your model. This is required for the Plex. XML UI 27 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Hauptfunktionen Die. PLEX Plex. Box Create triples (Templates) End of Part 1 Need more? 28 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Hauptfunktionen Die. Plex. XMLBox § Plex. XML Dialog. Builder Create and store browserbased standardpanels for the administration of all the tables in a breath. - Tabular view (Grid) Detailpanel with editing functionality combined tabular and detail panels Master. Detail and Master. Tab § Panel. Child. Builder Definition of more complex dialogs by combining existing panels. 29 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex. XML… the beginning • Who knows Plex. XML? • Who uses Plex. XML? • What is Plex. XML? A dynamic CA Plex web client using XML, Ajax, Java. Script • I began with Plex. XML in 2009 with quick success in the tutorial, however. . . • Plex. XML relies heavily on Java/xslt technology, which I don’t know that well, being a tool person. • “Anything difficult to do manually, should be automated” Tools 4 Plex for Plex. XML was born • Following the development of Tools 4 Plex for Plex. XML, most of the steps necessary to get the Plex. XML based UI and functionality up and running, was automated (2011/2012) 30 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Plex. XML Dialog. Builder 31 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Plex. XML Dialog. Builder Panel. Child dialog 32 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Plex. XML Dialog. Builder Detail view with editing functionality 33 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Plex. XML Dialog. Builder Master. Detail Dialog 34 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Dialog. Builder Hauptfunktionen Die. Plex. XMLBox Dialog. Builder Master. Tab Dialog 35 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Dialog. Builder Hauptfunktionen Die. Plex. XMLBox DEMO? 37 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Panel. Child Hauptfunktionen Die. Plex. XMLBox Combine existing dialogs to get a new and powerful Panel. Child dialog… 38 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Panel. Child Hauptfunktionen Die. Plex. XMLBox …and let Tools 4 Plex generate the necessary code 39 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu Webbrowser Hauptfunktionen Die. Plex. XMLBox Automatic navigation to every generated request. of your application, to get the information written into Plex. XML -database !! 40 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu XMLfiles Hauptfunktionen Die. Plex. XMLBox Browse through all of the generated xml, xsl/xslt-files and the code contained 41 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu XMLMenu Hauptfunktionen Die. Plex. XMLBox Create all the menus needed to test your functions…with one click. When ready, drag `n drop the menu items to their respective menus. 42 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu XMLFormat Hauptfunktionen Die. Plex. XMLBox View on generated functions and formats. Create combo boxes and/or the hyperlinks you want within the formats. 43 Copyright © 2013 CA. All rights reserved.

Different aspects of Tools 4 Plex Main processes Menu XMLAllabout Hauptfunktionen Die. Plex. XMLBox Central view of Plex. XML tables that define your menus, functions, formats and translations. For example: Here the menu tab is active, so the menu items created by Tools 4 Plex can be seen 44 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… • A productivity tool for CA Plex • The story behind the tool • An example in numbers • What do we have right now • Where do we want to go 45 Copyright © 2013 CA. All rights reserved.

About Tools 4 Plex… Where do we want to go? Continued integration of further presentation layers. Who wants to be first? 46 Copyright © 2013 CA. All rights reserved.

TE@MCONSULT Group Speakers Bio Name: Developer: CA 2 E: CA Plex: Club Lava Member #: Axel Oberländer since 1983 since 1988 since 1995 (Obsydian r 1. 02) 32 Mail: axel. oberlaender@teamconsult. de URL: www. teamconsult. de Name: Developer: CA 2 E: CA Plex: James D. Ryan since 1981 since 1987 since 1995 (Obsydian r 1. 02) 49 Employees TSD(Group) 6+(30) • 3(12) Development • 2(4) Consulting, Services and Support • 1(3) Marketing and Sales • 1(3) Backoffice Company TE@MCONSULT Ltd. Solutions & Development Hohe Brück 7 60437 Frankfurt am Main TE@MCONSULT Solutions & People Ltd. Steinhauserstrasse 160 42399 Wuppertal External Contractors • 5(8) TE@MCONSULT Sales Force Ltd. Steinhauserstrasse 160 A 42399 Wuppertal Partners Customers 5 in D, CH and I > 70 companies and organisations, in D-I-CH Copyright © 2013 CA. All rights reserved.