Freedom/ERwin Integrating CA 2E to CA Erwin ERD User Guide
Contents
1. CA ERwin Data 4 T File Edit View Format Model Database Tools Services Window Help zix n B HBA1REP HBAZREP 7 vce BATAESG DECIMAL 7 0 2 CHAR 6 B m E Ref from For Sales Rep 7 RAZAESG DECII 0 CHAR 6 FK trom x AZBWTX CHAR 25 Ti POH sas gnag Pe EF Defaut Values ATBECD CHAR 6 FK ii Y ATAIDT DECIMAL 7 0 c Domains i ATASST CHAR 1 ur ATAPVA DECIMAL 11 2 4 Blob Y m COE Wd Ref fom ADCD __ __ oH SASAYCD CHAR S 5 8 AICD CHARIS CHARQS For Costidg Alternate Dept E amp 5 BFCD BAVAOCD CHAR 6 HBAYREP Ostas A3CD AVBPTX CHAR 25 pete AVBQTX CHAR 25 FK HBA3REP A4CD AVBRDC CHARDS FI TRBAYATCD CHAR E Ref foc AYCD IBAUCPI AVACTM DECIMAL 6 0 FK AYBTIX CHAROS FK AZCD S AUAZCD CHAR 6 FK AVAGDT DECIMAL 7 0 FK 1 CHARIG FK P AYBUTX 25 FK SS H 085 S AUAHDT DECIMAL 7 0 ee Gunes A3AYCD CHAR 6 AYBVIX 25 FK AVENTX CHAR 25 LM pes DTH CHAR 25 AYBSTX CHARLES 8 8 DTE AVANVA DECIMAL 11 2 AYAQST CHAR H AHDT DECIMAL 11 2 CHAR E AIDT Owns pad2. AYASCD CHAR 6 FK 5 8 JOT S CHAR AYATCD CHAR 6 FK 83 AGDT AYBGCD CHAR 6 2 by from For Mentor E Mr cg 2 NER HBAWCPP Audit Trai Number p Extdnds acmpEcMAL609 PCT id Ref_from_For _Manager 2 PRC AWACTM DECIMAL 6 0 FK CHACON 9 AWAGDT 7 0 Included TRAXAOVN CHAR 10 ALC 0 FK a Qty AWANVN CHAR 10 FK AXAPVN CHAR 10 EH AWATST CHAR 1 AXADSG DECIMAL 7 0 SGT String STS TM A 5 TME Ha x Model 18 Subject Area Display Ready Series 5 x 6 x Confidential Page 13 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 All Attributes in Logical Edit Mode with Alternate Diagram Convention CA ERwin Data Modeler Samp t final erwin Main Subject Area gt File Edit View Format Model Tools Services Window Help Order Product Ref from For Sales Rep tone E e Refers to For Sales Rep Order Quantity Quantity Sales Rep Coy Dept FK 5 Date Status Order Total Amount Ref from For ost qe For Costifg Alternate Dept Employee Company Division FK Owned Company Dept FK Ref from For Manager Updated Time FK s to For Marmger dias Updated Date F
3. DECIMAL T 0 CHAR 1 DECIMAL 11 2 AXAOVN CHAR 10 CHAR 10 AXADSG DECIMAL 7 0 CHAR 6 FK A1BDCD CHAR 6 CHAR 6 FK CHAR 6 FK Ret m em metton o 8 AVAOCD CHAR 6 AVBNTX CHAR 25 AVBOTX CHAR 25 AVANVA DECIMAL 11 2 AVAOVA DECIMAL 11 2 AVAZST CHAR 1 CHAR 1 AVAYCD CHAR 6 FK AVBPTX CHAR 25 FK AVBQTX CHAR 25 FK AVBRTX CHAR 25 AVACTM DECIMAL 6 0 FK AVAGDT DECIMAL T 0 FK AVANVN CHAR 10 FK Audit Trail Ref from For Sales Rep amp ASAYCD CHAR 6 ASBLTX CHAR 25 HBASREP A3A9CD CHAR FK A3BACD CHAR 6 FK BE 8 A3A1CD CHAR 6 FK A3AYCD CHAR 8 FK ACTM DECIMAL 6 0 AGDT DECIMAL 7 0 f amp ANVN CHAR 10 6 CHAR 25 BJTX CHAR 25 BKTX CHAR 25 CHAR 6 FK ADA4CD CHARIS CHAR 25 Ref AYASCD CHAR 6 FK AYBACD CHAR 6 FK f amp AYAICD CHARIS AYBSTX CHAR 25 AYA2ST CHAR 1 AYBTTX CHAR 25 FK AYBUTX CHAR 25 FK AYBVTX CHAR 25 FK AYASCD CHAR 6 FK AYA2CD CHAR 6 FK CHAR 6 FK AYATCD CHAR 6 FK AYABCD CHAR 6 FK AYBGCD CHAR 6 FK Series
4. Confidential Page 9 Copyright 2012 by HawkBridge Pty Ltd 31 March 2012 Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 All Attributes in Logical Edit Mode with Alternate Diagram Convention Computer Associates act So Eie Edit Views Format Model ModelMart Tools Window Help poss QQQAA GS Logica HE Order FK f Product FK 5 Product Name if Customer Time Zone Last Updated Time FK Last Updated Date FK Last Updated User FK 2 Order Date Order Status H Order Total Amount AE Customer Order Sales Rep Coy Div FK AE Order Sales Rep Dept FK AE Order Sales Rep FK Customer Name if Customer Telephone WE Customer Credit Limit Customer Account Balance if Customer Status i Customer Territory FK 4 Customer Address Line 1 FK if Customer Address Line 2 FK Customer Address Line 3 FK Last Updated Time FK Last Updated Date FK Last Updated User FK Included by Includj Audit Trail Last Used Surrogste File Field H Last Used Surrogste Ref from For Sales Rep Refers to For Sales Rep 5 Territory Employee Teritory Employee Company Division FK Employee Company Dept FK AS Employee FK Teritory FK Included by Incl m Last
5. ustomer Address Line 3 FK Updated Time FK Updated Date FK H Company Division Company Division zx Ref from For Sales Rep ieCempany Division Name Refers to For Sales Rep by Division pany Department Alternate Dept Employee RyEmployee Company Division FK ployee Company Dept FK Employee FK eTemtory FK Tile 9 HrEmployee Costing Coy Div FK Owns Manager Coy Dept FK by Costing Coy Dept FK Employee Cig Alt Coy Dept FK Include by J Ref from For Me h Refers to For Me 4 IZ psg Customer Export Nn Address BERE BERE zz Extends Updated Ts 8 Line 1 Extended by 3 Updated Date Address Line 2 l Last Used Heese Fort Updated Time Updated User Line 3 Refus to For t ques Updated Date FK Included by least Updated User FK Indudes Customer Time Zone Last Used Surrogate cenas Dy Model Subject area Confidential Display 1 Page 12 Copyright 2012 by HawkBridge Pty Ltd 31 March 2012 Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 All Attributes in Physical Edit Mode with Entity Details ERwin Data t
6. fi rm 4 File Edit View Format Model Database Tools Services Window Help 0AA AAA Be 5 Stored Procedures fe Subject Areas Tables H E Address Audit Trail HBAOREP HBATREP 2 HBA3REP ES HBASREP HBATREP 8 HBAUCPP HBAVREP 5 HBAWCPP 5 Child Relations Audit Trail Included by HBAWCPP a HBAVREP Owns Bf Columns AWADCD E AWATST AWACTM AWAGDT AWANVN Indexes s HEAWCPLO s HBAWCPLI s HBAWCPP XIF1Customer_Export j x9 XIF2Customer_Export 9 88 XPKCustomer Export Uf Parent Relations HBAZREP E Ref from For Sales Rep HBAIREP 1 1 5 DECIMAL 7 0 HBUTLMDL 2 25 DECIMALO FK CHAR 6 FK Data Movement Sources DOCU ATBDCD CHARS FK PP 3 f Defaut Values ATBECD CHAR S FK Y AJAIDT DECIMAL 7 0 8 d us T ATASST CHAR 1 G dares DECIMAL 11 2 2 Relati Script Templates Ret from Ref fom __ HBAVREP BAVAOCD CHAR 6 AVBPTX CHAR 25 FK AVBQTX CHAR 25 FK CHAR 25 FK AVACTM DECIMAL S O FK AVAGDT DECIMAL 7 0 FK AVANVN CHAR 10 FK AVAYCD CHAR 6 FK AVENTX CHAR 25 AVBOTX CHAR 25 AVANVA DECIMAL 11 2 AVAOVA DECIMAL 11 2 HBAUCPP RAUAZCD CHAR 6 FK BAUAHDT DECIMAL 7 0 AUAMVA DECIMAL 11
7. Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 i f Freedom ERwin Integrating CA 2E to CA Erwin ERD User Guide Version 3 1 HawkBridge Pty Ltd 3 Highett Road Hampton VIC 3188 Australia http www HawkBridge com au Copyright 2012 by HawkBridge Pty Ltd All rights reserved including the right of reproduction in whole or in part in any form Confidential Page 1 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Table of Contents OVORVICW 3 SOE ALG LI 3 2 5 a 4 05 400 5 e ORO ue te 4 CA 2B 8 0 ru bI o DAR E EAT RE EXER eid EU ue gerer ty he du neue Cagle 4 Allfusion ERwin 4 1 CA ERwin 7 3 CA ERwin 8 0 or above sess nennen enne entrent 4 Using the Freedom ERwin Integration Tool eee 5 Greate a Model Object List sioan orre e aae penc e e pi p 5 Create the ER want Import FM dire er e e oa EE ce ei eee RE 6 Transfer the CA ERwin
8. User Guide 3 1 Relationship Detail showing Rolenames Relationship Employee Ref from For Manager Employee Name Ref from For Manager New Delete General Definition Rolename Actions Rolename Info Migrated Key Confidential Page 15 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Interface Issues and Design Standard There where several interface issues with the tool more so to do with CA ERwin not supporting certain features of CA 2E data modeling This section will highlight the most crucial issues and how they have been resolved CA 2E Structure Files The CA ERwin tool does not support the concept of structure files and the includes relationship For this reason all structure file attributes will be defined as primary key attributes This enables the includes relation to correctly resolve the relation entries CA 2E Includes Relation This relationship direction has been reversed to enable CA ERwin to correctly resolve the relation entries CA 2E Span Access Paths CA ERwin does not support multi format key groups being generated for span access paths To resolve this in CA ERwin each format of the span index will be generated as a separate key group on the associated based on file for the format If the based on file for the access path is different to the based on file of the forma
9. 4 Les Employee M Audit Trail Address fo 1 E Employee Teritory Extends Updated Ts isAddress Line 1 L um pee ied ere e Li ikiss Ra kom Manager n Ta L Updated User ress Line 3 sie ERES Time Zone a A amp amp GQ Logical H U Default Values Domains 8 default 5 8 code value 5 8 Company Department 8 Employee Company Dept EF Employee Costing Coy Dept E Employee Alt Coy Dept Ek Employee Manager Coy Dept E Order Sales Rep Coy Dept 9 8 Company Division Customer 8 Employee EF Product Teritory Blob EF Date in ISO format YYYY MM DD intemally EF Date in pure numeric format YYYYMMDD intemally 5 88 Date in system date format YYMMDD intemally 8 Job date EF Last Updated Date EF Effective Date EF Order Date EF Datetime E HawkBridge Binary 4 EF Ideographic text 5 8 Monetary value EF Customer Account Balance EF Customer Credit Limit EF Order Total Amount EF Product Price EF Narrative text E Number 8 Object text EF Percentage or market index E Price or tanif EF Pure numeric value eg line number 5 8 Quantity BF Order Quantity eCustomer FK Sales Rep FK Sales Rep Coy Div FK Sales Rep Coy Dept Date Ref Reffrom Customer RyCustomer leCustomer Address Line 1 FK
10. ERwin ERD User Guide 3 1 Create the ERwin Import File Make sure that FREEDOMER7 is in your library list The minimum library list to run the interface tool is e QTEMP e FREEDOMER7 Prompt the command HCRTERWERD and enter the following details then press Enter Create ERwin ERD Import File HCRTERWERD If you are generating XML for CA ERwin 7 3 or later then you will need to select 7 on the CA ERwin XML file version prompt under the additional parameters Otherwise the default of ERWA will generate XML for AllFusion ERwin 4 1 Note There are additional optional parameters for the HCRTERWERD command not displayed on the above figure that can be displayed by pressing the PgDn key For this example the default values for these parameters are acceptable Transfer the CA ERwin Import File to the PC Start an AS 400 to PC file transfer session to transfer the file HERWIMPDTA member HERWIMPDTA in the generation library to a temporary PC directory such as C TEMP The transfer details are as follows e From file lt GENLIB gt HERWIMPDTA HERWIMPDTA lt lt To File C TEMP HERWIMP XML e To File Type ASCII Text Note lt GENLIB gt should be replaced with the actual name of the generation library It is important that the PC file have the xml suffix so that CA ERwin will import the file correctly It is also important that the to file type be ASCII text as all the xml formatting has already been done
11. 6 FK BE 8 A3A1CD CHAR 6 FK A3AYCD CHAR 6 FK amp ACTM DECIMAL 6 0 amp DECIMAL 7 0 CHAR 10 amp BITX CHAR 25 6 BJTX CHAR 25 CHAR 25 CHAR 6 FK amp ADASCD CHARIS CHAR 25 For Costi Ref f m For Costing Alt ate Dept AYASCD CHAR 6 FK amp AYBACD CHAR 6 FK AYAICD CHAR 6 AYBSTX CHAR 25 AYA2ST CHAR 1 AYBTTX CHAR 25 FK AYBVTX CHAR 25 FK AYASCD CHAR 6 FK AYA2CD CHAR 6 FK AYABCD CHAR 6 FK AYATCD CHAR 6 FK AYABCD CHAR 6 FK AYBGCD CHAR 6 FK All Attributes in Physical Edit Mode with Domain Hierarchy A File Edit View Format Model Database ModelMart Tools Window Help 5 9 Domains E defaut Bob fl Abe CDE Aye ACD fA Age 1 ABCD E A 4 Aye Aye ATCD Aye Aye BECD BGCD Aye AYCD 2 A2AESG DECIMAL 7 0 FK 6 A2AZCD CHAR 6 FK HBATREP ATAZCD CHAR 6 ATBMTX CHAR 25 HBAUCPP amp AUAZCD CHARIS amp AUAHDT DECIMAL 7 0 AUAMVA DECIMAL 11 2 V CHAR 6 FK AWATST CHAR 1 AWACTM DECIMAL 6 0 FK AWAGDT DECIMAL 0 FK P AWANVN CHAR 10 FK ATAESG 0
12. Cov Dept Employee Manager Rolename Employee Manager Coy Dept Migrated Att Employee Company Dept Key Group Detail showing Member Attributes y Entity Customer Key Group Type Definition Show FK Groups New Update index Retrieval index Rename Delete Members General Definition Note UDP Available Attributes Key Group Members Customer Name Customer Customer Telephone Customer Credit Limit Customer Account Balance Customer Status Customer Address Line 1 Customer Address Line 2 Customer Address Line 3 Last Updated Time Last Updated Date 1 nat Lind ated Llane Attribute Cancel Confidential Page 11 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 Example CA ERwin 7 3 Screen Shots All Attributes in Logical Edit Mode with Entity Details ERwin Data HE 24 q File Edit View Format Model Tools Services Window Help CA ERwin Data Mo HBUTLMDL en File Edit View Format Model Tools Services Window Help Logic
13. by the AS 400 and does not need to be converted Import File into CA ERwin Launch CA ERwin If prompted with the ModelMart Connection Manager use the cancel button to close the dialog box Choose menu option File Open or click the Open button to display the open dialog box Change the look in directory to the temporary PC directory you transferred the import file into Confidential Page 6 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Change the files of type selection list to XML Files xml Your import file in our example HERWIMP XML should now appear in the selection list Select the import file and click the Open button CA ERwin 7 3 or later may prompt for XML File Validation You may select either Yes or No to continue with the import It is advised to select Yes as additional validation will be performed on the XML file prior to import AllFusion ERwin 4 1 may prompt the XML4ERwin message box If no errors occurred then click the OK button to close the message box CA ERwin 7 3 or later may prompt the ERXML message box if any errors have occurred You may select either Yes or No to continue It is advised to select Yes as it will display the error log for the import with details of all the import errors If you received an error message then you need to resolve the import errors If you cannot resolve the errors then contact us for as
14. 2 CHAR 6 4 HBASREP BASAYCD CHAR ASBLTX CHAR 25 i HBAYREP CHAR S 3 D CHAR G FK AYSUIX 1 CHAR 6 P BABAYCD CHAR 6 AYBVTX 25 Owns AVAZST CHAR 1 AVAOST CHAR T ee HBAWCPP Audit Address BAWAOCD CHAR 6 FK p Extdnds BACT DECIMAL 6 0 a CHAR 25 AGDT DECIMAL 7 0 CHAR 25 AWACTM DECIMAL S 0 FK AWAGDT DECIMAL 7 0 FK Lig Indluded by CHAR cHAROS CHAR 10 AWANVN CHAR 10 FK BAXAPVN CHAR 10 AWATST CHAR 1 RAYASCD CHAR 6 FK X AYBACD CHAR 6 FK X AYATCD CHAR 6 CHAR S FK AYA2CD CHAR 6 FK AYBSTX CHAR 25 CHARY6 FK 5 6 FK AYATCD 6 AYBGCD 6 AZBWTX CHAR 25 D CHAR S 25 FK 25 FK CHAR 25 FK CHAR 1 Ref from For Manager AXADSG DECIMAL 7 0 Model Subject Ares
15. 25 AVANVA DECIMAL 11 2 AVAOVA DECIMAL 11 2 AVAZST CHAR 1 AVAOST CHAR 1 AVAYCD CHAR 6 FK AVBPTX CHAR 25 FK AVBQTX CHAR 25 FK AVBRTX CHAR 25 FK AVACTM DECIMAL 6 0 FK AVAGDT DECIMAL 7 0 FK AVANVN CHAR 10 FK AGDT DECIMAL 7 X ANVN CHAR 10 AXAOVN CHAR 10 AXAPVN CHAR 10 AXADSG DECIMAL 7 0 sees ORE Owt 6 A3A9CD CHAR 6 FK A3BACD CHAR 6 FK 8 A3A1CD CHAR 6 FK 6 A3AYCD CHAR 6 FK f amp BITX CHAR 25 CHAR 25 BKTX CHAR 25 6 ADA3CD CHAR 6 FK 6 ADASCD CHAR 6 CHAR 25 V Y 6 AYASCD CHAR 8 AYBACD CHAR 6 FK AYAICD CHAR 6 AYBSTX CHAR 25 AYA2ST CHAR 1 AYBTTX CHAR 25 FK AYBUTX CHAR 25 FK AYBVTX CHAR 25 AYASCD CHAR 6 FK AYA2CD CHAR 6 FK AYA CD CHAR 6 FK AYATCD CHAR 8 FK CHAR 6 FK AYBGCD CHAR 6 FK iSeries Confidential Page 10 Copyright 2012 by HawkBridge Pty Ltd 31 March 2012 Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 Relationship Detail showing Rolenames r 22 Mam E 0 Relationship Employee Ref from For Manager Employee New Delete General Definition Rolename RI Actions UDP Rolename Info Migrated Key Primary Key Migrated Attribute Rolename Emplovee Manager
16. 400000000 12 Attributes in Physical Edit Mode with Entity Details essere nennen nnne 13 Attributes in Physical Edit Mode with Domain Hierarchy eee 13 All Attributes in Logical Edit Mode with Alternate Diagram Convention esee 14 Attributes in Physical Edit Mode with Alternate Diagram Convention eene 14 Relationship Detail showing Rolenames eese eene enne AEE EE ER EEE anaE a i 15 Key Group Detail showing Member Attributes sese nee ennt enne nee 15 Interface Issues and Design Standard sees 16 CA 2E Str cture Files nte tao e e fre en een te ait Gide eq Peter ERRARE 16 CA 2E Includes Relation nun oet tad et e tei a ete Des tea tet ite ee tutes 16 CA 2E Span Access Paths e re ede te et e te eerte eth a e ito TESS 16 CA 2E Structure and Record File Access Paths essere inea ener etre 16 ERwin 7 3 and beyond Unique Domain 16 CA 2E Structure File in Physical Data Model eeseeeeeeseeeeeeeeeneeene nennen enne nete 16 Command Referente nersini ue 17 Create ERwin Import File 2 1 2 2 110004000000000000000000000000000000000000000000 00 17 Confident
17. AK HBAWCPLO j AK HBAWCPL1 IE HBAWCPP j 4 XIFIHBAWCPP 4 XIF2HBAWCPP Parent Relationships Extends HBAVREP Child Relationships Audit Trail im HBAVREP Zf Stored Procedures Script Templates HBAXCPP HBAYREP 8 A2AESG 0 FK A2AZCD CHAR 6 FK A2ACQT DECIMAL 5 0 ATAZCD CHAR 6 ATBMTX CHAR 25 HBAUCPP AUAZCD CHAR e amp DECIMAL 7 0 AUAMVA DECIMAL 11 2 AWAT1ST CHAR 1 AWACTM DECIMAL 6 0 AWAGDT DECIMAL 7 0 FK AWANVN CHAR 10 FK Bead Physical amp ATAESG DECIMALI7 0 ATAIDT DECIMAL 7 0 ATA3ST CHAR 1 DECIMAL 11 2 CHAR 10 CHAR 10 AXADSG DECIMAL 7 0 6 AZA3CD CHAR 6 AZBWTX CHAR 25 CHAR 6 A1BDCD CHAR 6 FK A1BECD CHAR 6 FK CHAR 6 Ret_from Ret from fem La AVAQCD CHAR 6 AVBNTX CHAR 25 AVBOTX CHAR 25 AVANVA DECIMAL 11 2 AVAOVA DECIMAL 11 2 AVAZST CHAR 1 CHAR 1 AVAYCD CHAR 6 FK AVBPTX CHAR 25 FK AVBQTX CHAR 25 FK AVBRTX CHAR 25 FK AVACTM DECIMAL 6 0 FK AVAGDT 0 AVANVN CHAR 10 FK Audit Trail Ref from For Sales Rep amp ASAYCD CHAR E ASBLTX CHAR 25 8 A3ASCD CHAR E FK A3BACD CHAR
18. Audit Trail Extends Last Updated Time Extended by Last Updated Date Included by Last Updated User Includes Address Address Line 1 NP Address Line 2 AE Address Line 3 Order Total Amount THE Product Price Ap Narrative text THE Number amp Object text Ht Percentage or market index Price ortamif Pure numeric value eg line number EHE Quantity Order Quantity ABP Status ARE String ef from For Managerj Customer Time Zone Refers to For Manager Last Updsted Time Last Updated Date Last Updated User FK Ref from For Mentor Refers to For Mentor Confidential 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Page 8 Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 All Attributes in Physical Edit Mode with Entity Details A File Edit View Format Model Database ModelMart Tools Window Help e amp fs Domains BE Model Sources Validation Rules Default Values 9 01 Stored Procedures Script Templates T Transforms Tables Address ic Audit_Trail HBADREP m HBATREP HBA2CPP HBA3REP HBASREP HBATREP HBAUCPP HBAVREP HBAWCPP Columns AWADCD AWAIST AWACTM AWAGDT AWANVN Q indexes XPKHBAWCPP j
19. Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Application area APP Specifies the name of the application area used to build the list of files to include in the CA ERwin import file The list of files used to build the database relations for import into CA ERwin will be derived from the application area files SELECT A single value indicating that the application area is selected using an interactive display function application area Specify the 3 character name of the application area Model object list MDLLST Specifies the name and library of the model object list used to identify the files to be used by the command The possible library values are MDLLIB Indicates that the first data model library found in the current job s library list is used model library name Specify the name of data model library Edit list EDIT Specifies whether or not the model object list is to be displayed in edit mode after it is built and before the extract takes place The possible values are Indicates that the model object list is not to be edited 5 Indicates that the model object list is to be edited Import file FILE Specifies the name and library of the database file to which the output of the command is directed If the file does not exist this command creates a database file in the specified library The possible li
20. Coy Div FK Refers to For Sales Rep ff Address 39 Order Sales Rep Coy Dept FK Company Department NS Order Sales Rep FK eco D Trail M parri 9 8 Company Department Company Department t 19 81 Company Division Ref Ref ium Company Department Customer Refets to Refefs to Ref from For Costing Ref from For Chsting Alternate Dept Ea 4 gp ReferstoForCosting Refers to For Cpsting Alternate Dept B les Customer Customer 48 Customer Employee Customer Time Zone Employee Company Division FK Customer Name Employee Tenitaly if Employee Company Dept FK by Customer Telephone Employee Company Division FK MENS Last Updated Date Customer a P Employee Company Dept Employee Name Last Updated User NF Product enne ee Moe AF Employee FK Employee Title EQ Key Groups Effective Date M i Teritory FK i Employee Address Line 1 FK H Primary Key 3M m i Employee Address Line 2 FK Foreign Comer M ere Manager Co Dept FX 88 48 Foreign Key2 NS Customer Address Line 2 FK M Ed IE Physical file tertiaire Y Employee Costing Coy Div FK HAK Retrieval index Last Updated Date FK cae AK Update index Last Updated User FK i Employee Alt Coy Dept FK E m Parent Relationships NE qM Included by Extends Cu
21. Import File to the PC eene entren nennen nee 6 Import File into CA BRwWwIn Hp HERR REL ETE FEDT EE HO UE RE EET REPRE 6 Adjust Default Layoutsand Detail e eet ttem ter Rv a n YE 7 Example AllFusion ERwin 4 1 Screen 5 8 All Attributes in Logical Edit Mode with Entity Details essere ene 8 All Attributes in Logical Edit Mode with Domain Hierarchy esee nennen rennen 8 Attributes in Physical Edit Mode with Entity Details sese nee enne enne 9 Attributes in Physical Edit Mode with Domain Hierarchy eese ener 9 All Attributes in Logical Edit Mode with Alternate Diagram Convention esee 10 All Attributes in Physical Edit Mode with Alternate Diagram Convention seen 10 Relationship Detail showing Rolemames cccccesscssscesseeseeeeceseceaeceaecaaecaeecaeeeseeececeesesesecaecaecaecnaecaeecaeeeseeeneeenees 11 Key Group Detail showing Member Attributes esses 11 Example CA ERwin 7 3 Screen Shots 4 rioris utat penati ocu os cupa EE Ea nenna 12 Attributes in Logical Edit Mode with Entity Details esses 12 Attributes in Logical Edit Mode with Domain Hierarchy 1 1 000000000100000000000000000000000000
22. K uded i Last Updated User Includes ATADCD CHAR 6 Rei from For Sales Rep ATBFCD 6 FK ATBDCD CHAR 6 FK ATBECD CHAR 6 FK ATAIDT DECIMAL 7 0 5 CHAR 1 QA3CD DECIMAL 11 2 emi bred m ASBLTX CHAR 25 HAVADCD CHAR S AVBPTX CHAR 25 T AYASCD CHAR S FK AVBQTX CHAR 25 FK AVACTM DECIMALIS d FK TRA3A9CD CHAR 6 S AUAZCD CHAR 6 FK AVAGDT DECIMAL 7 0 FK 3 CHAR 6 FK AYBTTX 25 FK BAUAHDT DECIMAL 7 0 AVANVN CHAR 10 BA3AICD CHAR 6 P AYBUTX CHARQS FK 4 CHAR S FK CHAR 25 FK AVAYCD CHAR 6 FK AVBNTX CHAR 25 AYAGCO CHAR AVBOTX CHAR 25 AYBSTX CHAR 25 AVANVA DECIMAL 11 2 AYA2ST CHAR 1 DECIMAL 11 2 AYABCD CHAR E AVAZST CHAR 1 AYASCD CHAR 6 AVAOST CHAR 1 AYATCD CHAR 6 AYBGCD CHAR 6 FK HBAWCPP BAWADCD CHAR S FK DECIMAL 7 0 AWACTM DECIMAL 6 0 FK ANVN AWAGDT DECIMAL 7 0 FK 10 5 CHAR 10 AWANVN CHAR 10 BAXAPVN CHAR 10 15 CHAR 1 AXADSG DECIMAL 7 0 Confidential Page 14 Copyright 2012 by HawkBridge Pty Ltd 31 March 2012 Freedom ERwin Integrating CA 2E to CA ERwin ERD
23. Updated Time Last Updated Date ie Address Line 1 Address Line 2 Address Line 3 Company Division f Company Division Company Division Name 5 Company Division FK 4 Company Department inb Alternate Dept B Alternate Dept X Employee Company Division FK 4 Employee Company Dept FK Employee XS Employee Title Employee Address Line 1 FK Employee Address Line 2 FK Employee Address Line 3 FK X Employee Manager Coy Dept FK Employee Manager FK Employee Costing Coy Div FK X Employee Costing Coy Dept FK Employee Mentor X Employee Ctg Alt Coy Dept FK dar from For Manager Refers to For Manager Refers to For Mentor Display Ready iSeries AG File Edit View Format Model Database ModelMart Tools Window Help D e a cm TB g Gagmu e Physia 2 5 DECIMAL 7 0 FK A2AZCD CHARI FK 2 DECIMAL 5 0 ATAZCD CHAR 6 ATBMTX CHAR 25 AUAZCD CHAR 6 FK amp AUAHDT 0 AUAMVA DECIMAL 11 2 AWADCD CHAR 6 FK AWA1ST CHAR 1 AWACTM DECIMAL 6 0 FK AWAGDT DECIMAL 7 0 FK AWANVN CHAR 10 FK A1AESG DECIMAL 7 0 DECIMAL 7 0 A1A3ST CHAR 1 DECIMAL 11 2 CHAR 6 FK A1BDCD CHAR 6 FK A BECD CHAR 6 FK A1BFCD CHAR 6 FK AVAOCD CHAR 8 AVBNTX CHAR 25 AVBOTX CHAR
24. al a B 3 HBUTLMDL i Ref from For Sales Rep Customer FI 5 B Default Values sari m ns roii en Refers to For Sales Rep Domains iwOrder Sales Rep Coy Div FK B E Entities Order Quantity awed Rep Coy Dept FK 9 Address Audit Trail oe PiOrder Total Amount E Company Department by 59 Company Division Customer Pres Bortom Customer Export E Refers to For Costitg Alternate Dept ff Attributes leProduct Name 4 j T Customer yc Em Customer Time Zone 1 fp pail Last Updated Date Owntd by Paer Ades Line 1 10 Employes Company Dem b Last Updated Time ine bios estes Employee Ref from For Costing Last Updated User Product Price Updated Tine FK Sesion Emp Division FK ES Refers th Far Casing E T Child Relations Last Updated Date FK vmm SEM b ty Audi Trail Included by Cus ir A Tenton FK Employee Address Line 3 FK Sa Customer Owns Customer eiii Employes Manager PK 77 70 Ei Key Groups ustomer Telephone TREE w9 Physical file 5 Credit Limit e e pe trae na ployee Manager Coy Dept FK Ownfd by Type Employee Costing Coy Dept FK i heEmployee Cig Alt Fi 8 40 XIF2Customer Export l E m g XPKCustomer Export by Mad Uf Parent Relations Refers to For Mentor ka Customer Export Extends
25. at the relation names will be inverted Generate ACP key groups GENKEYGRP Specifies whether or not CA 2E access paths will be generated as CA ERwin key groups in the generated XML Only key fields and ascending or descending sequence are exported for CA 2E access paths Other attributes of CA 2E access paths are not supported in the default templates of CA ERwin The possible values are Indicates that ERwin key groups will not be generated 5 Indicates that CA ERwin key groups will be generated Generate domain defaults GENDOMDFT Specifies whether or not CA 2E domain field default conditions will be generated as CA ERwin default values in the generated XML Confidential Page 21 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 In order to mimic the behaviour of CA 2E as much as possible within CA ERwin 7 3 and beyond the domain default values are not cascaded from domain down to attributes AllFusion ERwin 4 1 does not support the ability to disable the cascading of domain defaults to attributes The possible values are Indicates that ERwin domain default values will not be generated YES Indicates that CA ERwin domain default values will be generated Generate domain validation GENDOMVAL Specifies whether or not CA 2E domain check conditions will be generated as CA ERwin domain validation rules i
26. be generated Generate relation verb phrases GENVRBPHR Specifies whether or not verb phrases will be generated for relationships AllFusion ERwin 4 1 does not support parent to child verb phrases in the generated XML which means that using PARENT or ALL for this parameter will not generate a parent to child verb phrase The parent to child verb phrase within AllFusion ERwin 4 1 comes from the relationship name element in the generated XML Confidential Page 20 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 The possible values are Indicates that no verb phrases will be generated PARENT Indicates that parent to child verb phrases will be generated CHILD Indicates that child to parent verb phrases will be generated Indicates that both parent to child and child to parent verb phrases will be generated Invert relation names INVRELNAM Specifies whether or not the relation names will be inverted in the generated XML CA 2E relationships are inverse to those defined in CA ERwin and earlier versions of Freedom ERwin did not invert the CA 2E relation names to map correctly to CA ERwin relations This options provides an ability for the user to control the ability to invert relation names The possible values are Indicates that the relation names will not be inverted 5 Indicates th
27. brary values are GENLIB Indicates that the library of the database file is the generation library for the data model library name Confidential Page 19 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Specify the library where the file is located Member options MEMBER Specifies the name of the database file member that receives the output of the command The possible member name values are FILE Indicates that the name of the member is the same as that of the database file that contains the member specified in the Import file prompt FILE parameter If the member does not exist this command creates it member name Specify the name of the file member that receives output If the member does not exist this command creates it The possible option values are REPLACE Indicates that the member will be cleared and new import records will be added ADD Indicates that new import records will be added to the end of the existing records CA ERwin XML file version ERWXMLVER Specifies which CA ERwin version of XML will be generated The possible values are 4 Indicates that AllFusion ERwin 4 1 compliant version of the XML will be generated ERW7 Indicates that a CA ERwin 7 3 compliant version of the XML will be generated ERW8 Indicates that a CA ERwin 8 0 compliant version of the XML will
28. by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Prerequisites The following prerequisites must be satisfied in order to use the tool e 05 400 5 2 0 or above installed 2 8 0 8 1 or 8 5 Data Model e AllFusion ERwin 4 1 ERwin 7 3 CA ERwin 8 0 or later OS 400 V5R2M0 or above The AS 400 objects in this release have been saved for 5 2 0 If you are on an earlier release then contact us for a version that supports your version of OS 400 Objects have been saved in a format that will enable Freedom ERwin to be restored to V6R1 and V7R1 of OS 400 CA 2E 8 0 8 1 or 8 5 The tool has been developed for Release 8 0 8 1 and 8 5 of CA 2E If you are on a later release then contact us for the upgraded version of the tool Prior releases may work but may not due to internal file changes to the CA 2E data model Allfusion ERwin 4 1 CA ERwin 7 3 CA ERwin 8 0 or above The tool has been developed for Allfusion ERwin 4 1 CA ERwin 7 3 CA ERwin 8 0 or later Earlier versions of CA ERwin are not supported in this product CA ERwin 7 1 is not supported for direct import via Freedom ERwin If you wish to continue to use CA ERwin 7 1 then you will need to import the XML into AllFusion ER win 4 1 and save the model as an file so that it can opened in CA ERwin 7 1 Otherwise you can upgrade to CA ERwin 7 3 where direct import is supported This is due the sign
29. del object list prompt MDLLST parameter Model function name FUNNAM Specifies the name of the function used to build the list of files to include in the CA ERwin import file The function specified will be expanded to the maximum level to include all DBF and DEV type functions except PMTRCD function types The list of files used to build the database relations for import into CA ERwin will be derived from the owning files of the expanded list of functions This parameter consists of two elements that together identify a function SELECT A single value indicating that the function is selected using an interactive display function function owner name Specify the 25 character name of the model file that owns the function function name Specify the 25 character name of the function Model function surrogate FUNSGT Specifies the internal surrogate of the function used to build the list of files to include in the CA ERwin import file The function specified will be expanded to the maximum level to include all DBF and DEV type functions except PMTRCD function types The list of files used to build the database relations for import into CA ERwin will be derived from the owning files of the expanded list of functions SELECT A single value indicating that the function is selected using an interactive display function function surrogate Specify the 7 digit surrogate of the function Confidential Page 18 31 March 2012
30. ial Page 2 31 March 2012 Copyright 2012 by HawkBridge Pty Lid Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Overview The text based modeling language of CA 2E is quite powerful yet it is very difficult to understand and appreciate the object relationships It is often necessary to convert it to a more conventional Entity Relationship Diagramming tool such as CA ERwin where a picture conveys a thousand words To make it easier to convert your CA 2E database relations to CA ERwin diagrams we have developed Freedom ERwin that will create a CA ERwin XML import file from one of your CA 2E data models Shareware This product is distributed as Shareware You may install and use the product for 45 days on a trial basis Should you wish to use the product after the 45 day trial you are required to purchase a license from HawkBridge Pty Ltd for your AS 400 The authorization will then enable you to install and use the product on a single AS 400 only Shareware products are provided without warranty either implied or expressed It is your responsibility to ensure that the software is appropriate for your installation This shareware product has been restricted to only allow a maximum of five CA 2E files to be imported into CA ERwin in any single import file The fully licensed version has no restrictions imposed apart from running on a single nominated AS 400 Confidential Page 3 31 March 2012 Copyright 2012
31. ificant issues and changes required around the new XML format in CA ERwin 7 1 Confidential Page 4 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating 2E to ERwin ERD User Guide 3 1 Using the Freedom ERwin Integration Tool To use the Freedom ERwin integration tool to import into AllFusion ERwin 4 1 follow these steps Create a Model Object List Prompt the command YBLDMDLLST to build a model list as follows then press Enter Build Model Object List YBLDMDLLST Model object name Object owner generic gt SELECT Object name generic Object type ALL ACP APP ARR for more values _ Model object list 4 gt HCRTERWERD Name MDLPRF USER MDLLIB Name MDLLIB GOR oara ae Soak REPLACE REPLACE ADD Bottom From the Select Multiple Model Objects display that next appears select one or more files to add to the model object list When complete press F12 to exit the process Select Multiple Model Objects Model HBUTLMDL Out list HCRTERWERD FEL lt Select Opt Object Address Audit Trail Company Department Company Division Customer Customer Export Employee Employee Territory Last Used Surrogate Order Order Product Confidential Page 5 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating 2E to
32. n the generated XML In order to mimic the behaviour of CA 2E as much as possible within CA ERwin 7 3 and beyond the domain validation rules are not cascaded from domain down to attributes AllFusion ERwin 4 1 does not support the ability to disable the cascading of domain validation rules to attributes The possible values are Indicates that ERwin domain validation rules will not be generated YES Indicates that CA ERwin domain validation rules will be generated END OF DOCUMENT Confidential Page 22 31 March 2012 Copyright 2012 by HawkBridge Pty Lid
33. r Date Order Status Order Tots Amount 4 Customer FK r File Field Company Division NS Company Division NS Company Division Name Ref from For Sales Rep A Order Sales Rep Coy Div FK X Order Sales Rep Coy Dept FK Order Sales Rep FK Customer Telephone Customer Credit Limit Customer Account Balance AE Customer Status Refers to For Sales Rep Employee Territory Employee Company Division FK Employee Company Dept FK MP Employee FK 4 Company Division FK AF Company Department Company Department P Employee a Employee Employee Title EQ Job date Effective Date hy Territory FK MF Employee Address Line 1 FK Last Updated Date PA ise tare Employee Address Line 2 FK iere ded AF Employee Address Line 3 FK Effective Date Customer Address Line 1 FK Customer Address Line 2 FK i Employee Manager Coy Dept FK 3 Order Date Mc pista 4 Employee Manager FK Q Datetime if Employee Costing Coy Div FK HawkBridge Binary 4 Age deographic text E H Monetary value HF Customer Account Balance HE Customer Credit Limit Last Updated Time FK 2 Last Updated Date FK Last Updated User FK T Ind by Employee Costing Coy Dept FK i Employee Mentor FK Employee Alt Coy Dept FK Indi
34. sistance CA ERwin 7 3 or later may prompt the ERwin Data Modeler message box to indicate the results of the import and default naming of the data model file Adjust Default Layout and Detail By default the diagram does not layout the shapes with enough space between them To adjust the layout choose the menu option Format Preferences to display the format preferences dialog box Click the Layout Entire Diagram button A warning message may display Click Yes to proceed and adjust the layout Click the OK button to return to your diagram Confidential Page 7 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to CA ERwin ERD User Guide 3 1 Example AllFusion ERwin 4 1 Screen Shots All Attributes in Logical Edit Mode with Entity Details A File Edit View Format Model ModelMart Tools Window Help DBE x E Company Division Order WE Company Division Order f Field Company Division Name Validation Rules O Order Date Order FK AS Order Status T Values Product FK Order Total Amount 4 Owng ransforms NE Customer FK Ref from For Sales Rep Order Quanti Entities Order Sales Rep
35. stomer pies 4 am Relationships Audit Trail Address Wn Inciudes Audit Extends Last Updated Time Address Line 1 Owned by Customer AE Customer Time Zone Extended by Last Updated Date Address Line 2 Refers to For Manager H E Employee Last Updated Time included by Last Updated User 36 Address Line 3 Q Last Updated Date FK R Employee Temitory NP Last Updated User FK __ For Menta 9 81 Last Used Surrogate H Order EB Order Product EB Product EB Product Price 9 81 m Subject Areas Display Read iSeries A File Edit View Format Model ModelMart Tools Window Help TAARA eS Domains unknown f Age Alphameric code value E A Company Department Employee Company Dept Employee Costing Coy Dept Aye Employee Alt Coy Dept Aye Employee Manager Coy Dept Aye Order Sales Rep Coy Dept Abe Company Division Teritory Aye Customer Territory Name riis 25e 9 Employee ing Altern Product Customer nd 4 Customer Employee Company Division FK Peu e Bo oana A Employee Company Dept FK Date in 150 format YYYY MM DD intemally Date in pure numeric format YYYYMMDD inter E G Date in system date format YYMMDD intemalt x Order FK Product FK AE Product FK Logical Orde
36. t then the key group name will be prefixed with based on file name of the access path CA 2E Structure and Record File Access Paths CA 2E access paths defined on structure and record files will not be generated as CA ERwin key groups as they cannot be generated within CA 2E CA ERwin 7 3 and beyond Unique Domain Names CA ERwin 7 3 requires that domain names are unique within the data model Where a CA 2E field name is the same as a CA 2E field attribute or a CA ERwin default domain the field name will be suffixed with the field surrogate to provide a unique domain name CA 2E Structure File in Physical Data Model Earlier releases of Freedom ERwin set the properties of all Structure files to not be visible in the physical data model This has an adverse effect on the list of entries on related files whereby the fields on the structure file would be dropped from the display CA ERwin has the capability to drop the entity but include the relationship to retain the entries on includes relations on related files But testing revealed an issue with this setting corrupting the data model entries when saved and restored For the mean time all Structure files will appear on the physical data model to enable the correct representation of the generated tables in CA 2E Confidential Page 16 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 Command Reference Create ER
37. win ERD Import File HCRTERWERD HCRTERWERD SELECT FUN FUNSGT MDLLST ERW4 ERW7 Purpose The Create ERwin ERD Import File HCRTERWERD command builds an import file of the database relations for use with CA ERwin Select object type SELECT Specifies type of object used to build the list of files to include in the CA ERwin import file APP Indicates that the type of object used to build the list of files to include in the CA ERwin import file is an application area identified by the application area name specified on the Application area prompt APP parameter Confidential Page 17 31 March 2012 Copyright 2012 by HawkBridge Pty Ltd Freedom ERwin Integrating CA 2E to ERwin ERD User Guide 3 1 FUN Indicates that the type of object used to build the list of files to include in the CA ER win import file is a function identified by the function owner and function name specified on the Model function name prompt FUNNAM parameter FUNSGT Indicates that the type of object used to build the list of files to include in the CA ERwin import file is a function identified by the function surrogate specified on the Model function surrogate prompt FUNSGT parameter MDLLST Indicates that the type of object used to build the list of files to include in the CA ERwin import file is a model object list identified by the model object list specified on the Mo
Download Pdf Manuals
Related Search