Benefits of Using AllFusion ERwin and Advantage Gen in the Same Project Lifecycle - PowerPoint PPT Presentation

Loading...

PPT – Benefits of Using AllFusion ERwin and Advantage Gen in the Same Project Lifecycle PowerPoint presentation | free to download - id: 560f60-MDY4N



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Benefits of Using AllFusion ERwin and Advantage Gen in the Same Project Lifecycle

Description:

Title: Slide 1 Author: Rainier Software Last modified by: Steve Smith Created Date: 3/13/2003 9:50:59 AM Document presentation format: On-screen Show – PowerPoint PPT presentation

Number of Views:73
Avg rating:3.0/5.0
Slides: 31
Provided by: RainierS2
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Benefits of Using AllFusion ERwin and Advantage Gen in the Same Project Lifecycle


1
Benefits of Using AllFusion ERwin and Advantage
Gen in the Same Project Lifecycle
  • Steve Smith
  • Jumar Solutions
  • 28th March 2007

2
Abstract
AIIFusion ERwin Data Modeler working together
with AllFusion Gen
Why is this such a powerful combination and how
can it made to work most effectively?
3
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

4
Clients
5
Jumar Brands
JumarLinks is the brand for tool integration
products.
JumarXtras is the brand for complementary
products, utilities, add-ins and plug-ins.
Project Phoenix is the brand for Gen application
modernisation software and services.
6
Agenda
  • Introduction to ERwin and its features
  • Benefits for Gen Users
  • How JumarLinks integrates the two products
  • Practical Scenarios
  • Demonstration
  • Implementation
  • Summary
  • Q A
  • Brief Introduction to Jumars other Gen Products

7
AllFusion ERwin Data Modeler
performs transactional and data warehouse
database design, generation and maintenance
logical and physical database design enterprise
modeling dimensional modeling, IDEFX1 modeling
and information engineering modeling.
purpose-built for data and database modeling
8
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/J2EE
    applications based upon existing data stores
  • Improves user and analyst communication
  • Allows the DBA function and the Gen development
    world to be properly integrated

9
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

10
Complete Compare
Compare models with other models, databases or
scripts, move changes in either direction and
generate ALTER scripts
11
Reverse Engineering
Generate a model from an existing database or
script then move it into Gen and start
constructing an application
12
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

13
JumarLinks Integration
3. Update Gen data via proprietary ActiveX
interface which calls Gen API functions
1. Read ERwin data via exposed object hierarchy
2. Main application performs all object mapping
and transformation
ActiveX layer
ERwin API
Gen API
1.
2.
2.
3.
Code-based transformation rules
AllFusion ERwin Data Modeler
ERwin data exposed
Gen data generated
Advantage Gen
14
JumarLinks 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 dont map well
  • Action logging
  • Intelligence
  • adds, removes and changes objects during
    transformation

15
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
  • .

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

17
Action Logging
18
JumarLinks 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.

19
Usage Scenarios (1)
Gen is the master
Models are checked out from Gen to ERwin,
changed and then checked back in again
Application is generated and maintained from Gen
Database is generated and maintained from either
ERwin or Gen
Gen application accesses database
20
Usage Scenarios (2)
ERwin is the master
21
Usage Scenarios (3)
Reverse Engineering
1. Take an existing database
2. Generate an ERwin model
22
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

23
Demonstration
24
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

25
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

26
Questions Answers
?
27
Other Gen Specific Products
  • JumarXtras ModelReporter for AllFusion Gen
  • JumarXtras BulkUpdate for AllFusion Gen
  • JumarXtras DifferenceAnalysis for AllFusion Gen
  • JumarXtras PrintEnhancer for AllFusion Gen
  • JumarLinks for AllFusionGen and UML

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

29
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

30
Contact
Steve Smith Development Team Leader Jumar
Solutions steve.smith_at_jumar-solutions.com
www.jumar-solutions.com
About PowerShow.com