TOOLS FOR DATA GOVERNANCE

1. TOOLS FOR DATA GOVERNANCE PASSIONATE BY DATA AND THE PRECISION OF THE RESULTS

2. DATA are at the HEART of I.S. And guaranteeing BUSINESS CONTINUITY DOMAIN APPLICATIONS Data PROGRAMS APPLICATIONS DBMS REVER Data Access PROGRAMS Data Access DBMS Data REVER Processes Presentation Processes Presentation Programs management (web server, transactional, jcl, …) Programs management

3. SOLUTIONS SHARED KNOWLEDGE RISKLESS ÉVOLUTIONS • DOC-EASY • EVOLVE-EASY • DB-MAIN KNOWLEDGEMODELLING • S.E.A.L. • DEV-EASY DEVELOPMENT ACCELERATOR DATA ACCESS LAYER TESTS ACCELERATOR EXTRACTIONS, ANONYMIZATIONS, GENERATIONS, COMPARISONS • D.I.S.Q. DATA QUALITY I.S. QUALITY

4. ARCHITECTURE LEGACY DB Web services Rel. DB jcl programs COBOL, PLI,.. programs JAVA, PHP,… ANALYZERS • . • DATABASES • STRUCTURES • AND RULES • PROGRAMS & PROCESSES SOURCE CODE • DATA MODELLING • DB-MAIN • DOC • EASY DB_MAIN REPOSITORY GENERATORS • DATABASE • SOURCE CODE • PROGRAMS & PROCESSES SOURCE CODE • DATA • EVOLVE • EASY • S.E.A.L. • DEV • EASY • D.I.S.Q.

5. CHARACTERISTICS • AUTOMATIC • CONTROL INDUSTRIAL • GENERIC • FLEXIBLE • PROGRAMMABLE REVER SOLUTIONS AGILES • SUBCONTRACTING • SUPPORT SERVICES

6. BENEFITS RESULTS RELIABILITY SOLUTIONS FLEXIBILITY PROCESSES AUTOMATISATION OBJECTS MODELLING • EXHAUSTIVENESS • SPEED • UNDERSTANDING • RISKLESS • SECURITY • QUALITY • ADEQUACY • AGILITY COMPLETE AND CONTINUOUS CONTROL OF THE PROGRAMS AND THE APPLICATIONS In order to act WITHOUT RISKS DEADLINE DECREASE RISKS DECREASE WORKLOAS DECREASE

7. SOLUTIONS • DOC-EASY • EVOLVE-EASY • DB-MAIN • S.E.A.L. • DEV-EASY • D.I.S.Q.

8. EVOLVE-EASY • DATA MIGRATION • To a new DB • To a software package • … • APPLICATION RE_ENGINEERING • Re-writing • Use of a new database • Technicalre-architecture • Applications spread over several DBMS types • Simplification of redundancy within application • … • DATABASE MIGRATION • DATABASE MERGE • DATABASE SPLIT

9. PROJECT APPROACH PHASE I I.S. UNDERSTANDING AND MASTERY TARGET I.S. understanding TARGET I.S. design or PHASE II DATA MIGRATION SOURCE - TARGET correspondences SOURCE I.S. understanding Data validation Source code adaptation validation migration Wrappers ETL PHASE IIIPROGRAMS ADAPTATION

10. I.S. UNDERSTANDING Programs management Presentation Processes Data access DBMS Data REVER

11. I.S. UNDERSTANDING Missing Source code REPOSITORY (DB-MAIN) DB technical schema (data physical model) structures & explicit links • Application technical schema • (data logical model) • structures & implicit links • Data – data links DDL source code Source code inventory Programs source code & JCL • Application architecture • Links data-programs • Links programs-programs • Links data-data • Applic.Cartography • Specific markings • Technical risk control • Galois graph • « weight watcher » Non compliant data or rules Data validation Applic. «business» schema (data conceptual model) « Business » concepts conceptua-lization

12. I.S. UNDERSTANDING THE DATA SCHEMA • REVERSE-EASY DB TECHNICAL SCHEMA APPLICATION TECHNICAL SCHEMA APPLICATION « BUSINESS » SCHEMA Links via programs • DB-MAIN

13. I.S. UNDERSTANDING APPLICATION ARCHITECTURE PROGRAMS- PROGRAMS APPLICATION CARTOGRAPHY DATA - PROGRAMS DATA - DATA Applic.link Applic.link

14. I.S. UNDERSTANDING. APPLICATION ARCHITECTURE DATA - DATA DATA FLOW DATA - PROGRAMS PROGRAMS - PROGRAMS

15. I.S. UNDERSTANDING • RISKS CONTROL DATA DATA LINKS + DATA PROGRAMS LINKS PROGRAMS PROGRAMS LINKS + = WEIGHT WATCHER

16. PROJECT APPROACH PHASE I I.S. UNDERSTANDING AND MASTERY TARGET I.S. understanding TARGET I.S. design or SOURCE I.S. understanding

17. TARGET I.S. DESIGN DB-MAIN SOURCE Model Conceptual model TARGETmodel RESULTS Databasecreation source code (DDL)

18. PROJECT APPROACH PHASE II DATA MIGRATION SOURCE - TARGET correspondences validation migration Data validation ETL

19. DATA MIGRATION Help tool for establishing the correspondences SOURCE -TARGET DB-MAIN SOURCE model Conceptual model TARGET model Correspondences List of SOURCE tables and columnswithoutcorrespondence List of TARGET tables and columnswithoutcorrespondences RESULTS SOURCE-TARGET Incompatibilitylist

20. DATA MIGRATION DB-MAIN SOURCE model Conceptual model TARGET model Correspondences RESULTS Validation requests « Neutral » DB (only the tables) Unload/ Load Validation requests execution Unload/ Load • Non compliant data report (HTML) SOURCE I.S.

21. DATA MIGRATION DB-MAIN SOURCE model Conceptual model TARGET model « Standards » Transformations code « Specific » transformations code Correspondences RESULTS Data migration code Migration securisation and validation code

22. DATA MIGRATION

23. PROJECT APPROACH Source code adaptation Wrappers PHASE III PROGRAMS ADAPTATION

24. PROGRAMS ADAPTATION DB-MAIN SOURCE model Conceptual model TARGET model Correspondences Wrappers source code + which wrapper in which program

25. PROGRAMS ADAPTATION • Programs source code • Programs source code adapted to the use of the wrappers

26. DATABASE MIGRATION

27. DATABASE MIGRATION scenario 1 : New DB design + data migration (with replication) Before project After project TARGET SOURCE SOURCE jcl, server, ... jcl, server, ... New prog. Presentation Presentation Processes Processes Data access Data access Data access DB DB New DB Replication

28. DATABASE MIGRATION scenario 2 : New DB design + data migration + access modifications Before project After project TARGET SOURCE SOURCE jcl, server, ... jcl, server, ... new programs presentation presentation processings procesings data access data access wrappers new DB DB

29. DATABASE MIGRATION scenario 3 : New DB design + data migration + access modifications + programs modifications Before project After project TARGET SOURCE jcl, server, ... jcl, server, ... new programs presentation presentation processings processings data access data access wrappers new DB DB

30. PROJECTS

31. THANK YOU FOR YOUR ATTENTION