picture this! using allfusion 2e with graphical tools session 6c darryl millington hawkbridge pty...

Post on 26-Mar-2015

212 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

TRANSCRIPT

Picture This!Using AllFusion 2E with

Graphical Tools

Session 6CDarryl Millington

HawkBridge Pty LtdMelbourne, Victoria, Australia

2 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Session Abstract

- Visualising AllFusion 2E database relations from graphical tools such as CA’s AllFusion ERwin and Microsoft Visio increases developer productivity and enhances communication between IT and the business.

- This session will cover out-of-the box solutions providing a convenient method of transferring data model information – from AllFusion 2E data models to AllFusion ERwin data models where a picture conveys a thousand words.

3 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Speaker Bio

- Darryl has worked as an AllFusion 2E developer since 1988 traveling extensively as an independent consultant throughout Australia, New Zealand, USA, UK and Asia.

- He is a regular speaker at CA conferences and has been speaking on AllFusion 2E-related topics since 1991.

- Darryl.Millington@HawkBridge.com

4 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

About HawkBridge

- Focused on enabling clients to create business advantage through use of quality systems to enhance business capabilities

- Fostered strong relationships with CA

- Freedom Productivity and Enablement Tools:

- Freedom/Erwin, Freedom/Visio, Freedom/Plex

- http://www.HawkBridge.com

5 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Session Agenda

- Introduction

- Freedom/ERwin Overview

- Freedom/Visio Overview

- Overview of Benefits

- Visualising AllFusion 2E

- Freedom/ERwin Demo

- Freedom/Visio Demo

- Summary

- Q&A

6 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

(C) HawkBridge Pty Ltd 1999 DOCUMENT RELATION DETAILS. Op: HSECOFROptions: Model relations. . . . : *USER Application area(s). . : OE Order Entry Narrative text type. . : *NONE Relation level . . . . : *ALL Print entries. . . . . : *RDR Print change date . . : *NONE Print changes only.....: *NO Print file narrative...: *NO Print field narrative..: *NO Model: HBUTLMDL (C) HawkBridge Pty Ltd 1999 File/Item Verb Seq File/Item For Customer Defined as FIL Customer REF Known by 1 FLD K Customer CDE Has 2 FLD A Customer Name TXT Has 3 FLD A Customer Telephone TXT Has 4 FLD A Customer Credit Limit VAL Has 5 FLD A Customer Account Balance VAL Has 6 FLD A Customer Status STS Has 7 FLD A Customer Type STS Refers to 8 FIL Territory REF Includes 9 FIL Address STR Includes 10 FIL Audit Trail STR Extended by 900 FIL Customer Export CPT Order Defined as FIL Order REF Known by 1 FLD K Order SGT Has 2 FLD A Order Date DTE Has 3 FLD A Order Status STS Has 4 FLD A Order Total Amount VAL Refers to 5 FIL Customer REF Refers to 6 FIL Employee REF Sales Rep Order Product Defined as FIL Order Product CPT Owned by 1 FIL Order REF Owned by 2 FIL Product REF Has 3 FLD A Order Quantity QTY ** END OF REPORT **

Introduction

… in 3 simple steps where a picture conveys

1000 words!

Visualise this text based AllFusion 2E data model

relations report …

7 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Freedom/Erwin Overview

- Freedom Utilities Integration with AllFusion 2E for iSeries 400 and AllFusion ERwin Data Modeler

- Converts AllFusion 2E data models to AllFusion ERwin data models

- http://www.HawkBridge.com/html/freedom_erwin.htm

AllFusion 2EData Model

.xml AllFusion ERwinModel

8 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Freedom/Visio Overview

- Freedom Utilities Integration with AllFusion 2E for iSeries 400 and Microsoft Visio

- Converts AllFusion 2E data models to Microsoft Visio diagrams

- http://www.HawkBridge.com/html/freedom_visio.htm

AllFusion 2EData Model

.xml Microsoft VisioDiagram

9 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Overview of BenefitsFreedom/ERwin Freedom/Visio

- Industry Leading Solution Yes Yes

- Logical and Physical Data Models Yes -

- Export of Implementation Details Yes Yes

- Generate Databases Yes -

- Scaleable Enterprise Solution Yes -

- Single Non-Tier Based Licence Yes Yes

- Value for Money Yes Yes

- Saves Time Yes Yes

- Flexible Command Interface Yes Yes

- Visualise All Database Relations Yes Yes

- Uses XML Import Yes Yes

- CA Smart Certified Yes Yes

21 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

- Defined as

- Owned by

- Refers to

- Extended by

Visualising AllFusion 2E

Order

Owned byOrder Line Order

Refers toOrder Customer

Extended byCustomer

CustomerExport

22 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

- Includes

- Known by

- Qualified by

- Has

Visualising AllFusion 2E

IncludesCustomer Audit Trail

Customer

Cust Nbr

Product Price

Effective Date

Customer

Cust Name

23 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Step 1: Run the HCRTERWERD Command to generate a physical file containing the exported XML

24 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Uses the AllFusion 2E model object select program to select

an existing model object

25 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Uses the AllFusion 2E model object list commands to edit

the list of selected objects

26 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Generates an AllFusion ERwin compliant XML import file

27 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Transfer XML File to PC

Step 2: Transfer the generated physical file to the IFS or PC

28 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Transfer XML File to PC

Specify a standard ASCII file transfer

29 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Transfer XML File to PC

Exclude the end of file indicator

30 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Transfer XML File to PC

Message indicates file transfer has been successful

31 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Step 3: Open XML file directly in AllFusion ERwin without the

need for other intermediate tools

32 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Message indicates XML import has been successful

33 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Use the Layout Entire Diagram option to produce optimal layout

34 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Logical model shows human readable names for objects with

model view in left pane

35 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Physical model shows internal system names for objects with

domain view in left pane

36 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Logical model with alternate diagram convention

37 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Relationship details showing redirected entry rolenames

38 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in AllFusion ERwin

Relationship key group details showing member attributes

39 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Step 1: Run the HCRTVSOERD Command to generate a physical file containing the exported XML

40 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Uses the AllFusion 2E model object select program to select

an existing model object

41 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Uses the AllFusion 2E model object list commands to edit

the list of selected objects

42 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Generate XML File

Generates an Microsoft Visio compliant XML import file

43 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Transfer XML File to PC

Step 2: Transfer the generated physical file to the IFS or PC

44 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in Microsoft Visio

Step 3: Open XML file directly in Microsoft Visio without the need

for other intermediate tools

45 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in Microsoft Visio

Use the Lay Out Shapes option to produce optimal layout

46 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in Microsoft Visio

Implicitly selected entities which were not in the initial list are grey

with diagonal stripes

47 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in Microsoft Visio

Select one or more entities to run the “Show Keys Only” or “Show

Attributes” add-in against

48 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in Microsoft Visio

Re-use the Lay Out Shapes option to produce optimal layout

49 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Open XML File in Microsoft Visio

Diagram can now be manually adjusted to fine tune the layout

50 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Session Summary

- Text based modeling language of AllFusion 2E for defining database relations is quite powerful

- In large data models it can become difficult to appreciate and understand object relationships

- Conversion to a graphical data model such as AllFusion ERwin or Freedom/Visio where a picture can convey a thousand words increases developer productivity

- Contact sales@HawkBridge.com for further details and to request a free demonstration copy

51 © 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.

Questions and Answers

Picture This!Using AllFusion 2E with

Graphical Tools

Session 6CDarryl Millington

HawkBridge Pty LtdMelbourne, Victoria, Australia

top related