Benefits of Using All Fusion ERwin and Advantage

Benefits of Using All. Fusion ERwin and Advantage Gen in the Same Project Lifecycle Steve Smith Jumar Solutions 28 th March 2007

Abstract AIIFusion ERwin Data Modeler working together with All. Fusion Gen Why is this such a powerful combination and how can it made to work most effectively?

Jumar Solutions • • Founded in 2000 360° Business and IT Solutions Company Gen specialists Rapid Growth – Deloitte Fast 50 National Winner 2005. • HQ in Solihull, UK

Clients

Jumar Brands Jumar: Links is the brand for tool integration products. Jumar: Xtras is the brand for complementary products, utilities, add-ins and plug-ins. Project Phoenix is the brand for Gen application modernisation software and services.

Agenda • • • Introduction to ERwin and its features Benefits for Gen Users How Jumar: Links integrates the two products Practical Scenarios Demonstration Implementation Summary Q&A Brief Introduction to Jumar’s other Gen Products

All. Fusion ERwin Data Modeler “… performs transactional and data warehouse database design, generation and maintenance; logical and physical database design; enterprise modeling; dimensional modeling, IDEFX 1 modeling; and information engineering modeling. ” purpose-built for data and database modeling

Why use ERwin as well as Gen? • Dedicated full-featured data and database modeling tool has many more features • Allows rapid development of new web/J 2 EE applications based upon existing data stores • Improves user and analyst communication • Allows the DBA function and the Gen development world to be properly integrated

ERwin Features • • • Design layer architecture Datatype mapping facility Naming Standards and Glossary Complete Compare bi-directional synchronization across models Database design generation Forward and reverse engineering Large model management via Subject Areas and Stored Displays Drawing objects Data Warehouse design

Complete Compare models with other models, databases or scripts, move changes in either direction and generate ALTER scripts

Reverse Engineering Generate a model from an existing database or script then move it into Gen and start constructing an application

What is needed from a solution that integrates these products? • Must deal with all major objects on both sides • Must deal with the issues of change and configuration management • Must be flexible to support in-house standards • Must show quality and productivity gain in the development cycle • Must be intelligent - more than a simple metadata bridge • Must be simple to use on a daily basis

FRAMEWORK Jumar: Links Integration 1. Read ERwin data via exposed object hierarchy 3. Update Gen data via proprietary Active. X interface which calls Gen API functions 2. Main application performs all object mapping and transformation Active. X layer ERwin API 1. All. Fusion ERwin Data Modeler 2. ERwin data exposed 2. Code-based transformation rules BUSINESS OR MAPPING RULES 3. Gen data generated Gen API Advantage Gen

Jumar: Links Features • Simple to use GUI interface • Creation of all major logical and physical data objects in both directions • Variety of transformation types - Logical to Logical, Physical to Logical, etc • Flexible and configurable via clickable Mapping rules • Use of custom properties for object properties which don’t map well • Action logging • Intelligence – adds, removes and changes objects during transformation

Custom Properties ERwin User-Defined Properties may optionally be used to store information useful in Gen but not available in ERwin • RI Trigger Names • Logical Entity Volumetrics • Modifying / Referencing • ….

Transformation Options • User selects the desired set of transformation rules • Each organisation has a slightly different requirement

Action Logging

Jumar: Links Features (2) Automated QA and standards enforcement • Object id and name maps are maintained for traceability and change/impact analysis – uses custom properties in ERwin and Tags in Gen description panels • Integrate ERwin and Gen allowing Update Migration of changes made in ERwin.

Usage Scenarios (1) Gen is the master Models are ‘checked out’ from Gen to ERwin, changed and then ‘checked back in’ again Database is generated and maintained from either ERwin or Gen application accesses database Application is generated and maintained from Gen

Usage Scenarios (2) ERwin is the master Initial ERwin to Gen synchronization is followed by subsequent forward migration of changes Database is generated and maintained from ERwin Gen application accesses ERwin database Application is generated and maintained from Gen

Usage Scenarios (3) Reverse Engineering 1. Take an existing database 4. Create new network or web application 2. Generate an ERwin model 3. Transform it into Gen

Initial Setup - Synchronisation • Where models already exist on both sides • Need to store corresponding object ids across models • Name based comparison • Manual methods • Automated Methods

Demonstration

Implementation considerations • Definition of the life-cycle (tool positioning) • Roles – who uses which tool? • Definition of the modelling standards (ERwin/Gen) • Definition of the detailed mapping rules • Configuration Management, Round-trip and Versioning

Summary üIt is possible and practical to use both ERwin and Gen within the same life cycle and to manage change üMore than just a bridge is required. An integrated, intelligent, configurable transformation checks, changes and adds changes üNew developments operating against existing databases can be launched fast üHigh automation means high quality and productivity, in-line QA and standards enforcement üMaximum benefits come from a managed implementation into an amended development lifecycle

? Questions & Answers

Other Gen Specific Products – • Jumar: Xtras Model. Reporter for All. Fusion Gen • Jumar: Xtras Bulk. Update for All. Fusion Gen • Jumar: Xtras Difference. Analysis for All. Fusion Gen • Jumar: Xtras Print. Enhancer for All. Fusion Gen • Jumar: Links for All. Fusion: Gen and UML

Other Gen Specific Products – • Model Analyser for All. Fusion Gen • 3270 Automation for All. Fusion Gen • Test Harness Generator for All. Fusion Gen • QA Compliance for All. Fusion Gen • CBD Automation for All. Fusion Gen • Fat Client Re-engineering for All. Fusion Gen • GUI to WUI for All. Fusion Gen

Other Products – Custom Automation • Individual pieces of automation for individual tasks • Rapidly assembled from a library of hundreds of high-level model manipulation routines built on top of the Gen APIs • Solve big problems without large manual effort

Contact Steve Smith Development Team Leader Jumar Solutions steve. smith@jumar-solutions. com www. jumar-solutions. com