WIXLIB

developerWorks ibm.com/developerWorksFigure 10. Map Generator Wizard – Page 2 – Destination Folder'8.When the input and output cards and the maps have been built, ClickFinish to end the wizard.Review the generated artifactsYou can now review the artifacts that have been generated by the Map Generatorfor WPS/WESB Wizard.The Map Generator Wizard generated a new XSD file with the nameCustomerDelimited.xsd that contains the top level element definition that isrequired by WebSphere Transformation Extender.1.Open the Schema Files folder in the Extender Navigator.2.Right-click CustomerDelimited.xsd and select Open With TextEditor as shown below in Figure 11.Figure 11. Opening CustomerDelimited.xsd in a Text Editor3.Examine the contents of the file.4.Close the Text Editor.The Map Generator Wizard generated a map source file with the nameCustomerDelimited.mms which contains two maps(CustomerDelimitedToXML and CustomerXMLToDelimited).Generating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 10 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks 5.Open the Maps folder in the Extender Navigator.6.Double-click on the CustomerDelimited.mms Map Source File to openit in the Map Editor. Notice that Figure 12 shows theCustomerXMLToDelimited map displayed in the Map Editor. This mapwill be used to transform data from the Customer Business Object formatto the delimited format.Figure 12. The CustomerXMLToDelimited Map7.Use the Outline Viewer to display the CustomerDelimitedToXML mapin the Map Editor by double-clicking on CustomerDelimitedToXML.Figure 13. The Outline Viewer with CustomerDelimitedToXMLhighlightedNotice that the CustomerDelimitedToXML map is displayed in the MapEditor. This map will be used to transform data from the delimited formatto the Customer Business Object format.Figure 14. CustomerDelimitedToXML MapGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 11 of 33

developerWorks ibm.com/developerWorksImport the Delimited Type TreeThe Type Tree that defines the delimited data has been provided for you. In thissection you will import the Type Tree into the CustomerMapProject ready for use inthe newly created Maps.1.Use a File System Import to import the Type Tree that representsdelimited (delimitedCustomer.mtt) version of Customer from the LabFiles \Type Trees directory into the CustomerMapProject folder.The result should be as shown in Figure 17.Figure 15. The newly imported Type Tree is visible in the ExtenderNavigatorReview the CustomerXML Input and Output CardsThe inputs and outputs of a WebSphere Transformation Extender Map are definedusing Cards. In this section you will review the automatically generated Cards thatGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 12 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks represent the XML data.1.Expand the contents of the Outline Viewer and note that theCustomerDelimitedToXML map has an automatically generated OutputCard (CustomerXML) and that the CustomerXMLToDelimited map hasan automatically generated Input Card (CustomerXML).Figure 16. Expanded Outline Viewer2.Right-click on the CustomerXML Output Card of theCustomerDelimitedToXML map and select Edit.3.Examine the card. This Output Card tells WebSphere TransformationExtender to create an XML document using the CustomerDelimited XMLSchema. Notice that the TypeTree for this card is set toCustomerDelimited.xsd and that the same file is used to provideMetadata (that determines the Name Spaces that will be generated atruntime).Figure 17. CustomerXML Output CardFigure 17. CustomerXML Output CardGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 13 of 33

developerWorks ibm.com/developerWorks4.Click Cancel on the Edit Output Card dialog5.Right-click on the CustomerXML Input Card of theCustomerXMLToDelimited map and select Edit.6.Examine the card. This Input Card tells WebSphere TransformationExtender to expect an XML document that conforms to theCustomerDelimited XML Schema as input at runtime. Notice that theTypeTree for this card is set to CustomerDelimited.xsd and that thesame file is used to provide Metadata (that determines the Name Spacesthat should be expected at runtime). The other value of note here is theFetchAs Integral value that specifies the internal technology thatWebSphere Transformation Extender should use when processing theinput data.Figure 18. CustomerXML Input CardGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 14 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorks7.developerWorks Click Cancel on the Edit Input Card dialogCreate the CustomerDelimited Input CardThe CustomerDelimitedToXML Map requires an Input Card that tells WebSphereTransformation Extender to expect input data that conforms to theCustomerDelimited.mtt Type Tree. In this section you will create a new Input Cardfor the CustomerDelimitedToXML Map and set some required values.1.Right-click on Input Cards of the CustomerDelimitedToXML map in theOutline Viewer and select New as shown in Figure 19.Figure 19. Create a new Input Card for the CustomerDelimitedToXMLmapGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 15 of 33

developerWorks ibm.com/developerWorks2.Set the CardName to CustomerDelimited3.Set the TypeTree to the delimitedCustomer.mtt file by clicking in theTypeTree input box and then clicking the button as shown in Figure 20.Navigate to the delimitedCustomer.mtt file in the Project Browser andthen click OK. The result should be as shown in Figure 21.Figure 20. TypeTree Browse buttonFigure 21. TypeTree value set correctly4.Set the Type to Record0 Record Data by clicking in the Type input boxand then clicking the button as shown in Figure 22. Navigate to theRecord0 attribute in the Select Type dialog as shown in Figure 23 andthen click OK. The result should be as shown in Figure 24.Figure 22. Type Browse buttonGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 16 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks Figure 23. Selecting Record0Figure 24. Type value set correctly5.Set the GET Source to Application by clicking in the Source input boxand using the drop-down list to select Application.6.Set the GET Source Command to -Overridden by typing in the inputbox. The result should be as shown in Figure 25.Figure 25. Command value set correctlyGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 17 of 33

developerWorks 7.ibm.com/developerWorksClick OK on the New Input Card DialogCreate the CustomerDelimited Output CardThe CustomerXMLToDelimited Map requires an Output Card that tells WebSphereTransformation Extender to create output data that conforms to theCustomerDelimited.mtt Type Tree. In this section you will create a new OutputCard for the CustomerXMLToDelimtied Map and set some required values.1.Right-click Output Cards of the CustomerXMLToDelimited map in theOutline Viewer and select New.2.Set the CardName to CustomerDelimited3.Set the TypeTree to the delimitedCustomer.mtt file by clicking in theTypeTree input box and then clicking the button as shown in Figure 26.Navigate to the delimitedCustomer.mtt file in the Project Browser (asshown in Figure 35) and then click OK. The result should be as shown inFigure 27.Figure 26. TypeTree Browse buttoFigure 27. TypeTree value set correctlyGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 18 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorks4.developerWorks Set the Type to Record0 Record Data by clicking in the Type input boxand then clicking the button as shown in Figure 27. Navigate to theRecord0 attribute in the Select Type dialog as shown in Figure 28 andthen click OK. The result should be as shown in Figure 29.Figure 27. Type Browse buttonFigure 27. Type Browse buttonFigure 28. Selecting Record0Figure 29. Type value set correctly5.Set the PUT Target to Application by clicking in the Target input boxand using the drop-down list to select Application. The result should beas shown in Figure 41.Figure 30. Target value set correctlyGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 19 of 33

developerWorks ibm.com/developerWorks6.Set the PUT Target Command to -Overridden by typing in the input box.The result should be as shown in Figure 31.Figure 31. Command value set correctly7.Click OK on the New Output Card Dialog8.Verify that your CustomerDelimited Map now matches the configurationshown below in Figure 32 and then Save your changes.Figure 32. Completed Map CardsGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 20 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks Complete the CustomerDelimitedToXML MapNow that the CustomerDelimitedToXML Map has an Input Card and an Output Card,the data mappings that transform data from the delimited format into the XMLformat can be completed.1.Double-click the CustomerDelimitedToXML map in the Outline Viewerto open the map in the main editor window. The main editor window isshown below in Figure 33.Figure 33. CustomerDelimitedToXML map open in the main editorwindowGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 21 of 33

developerWorks ibm.com/developerWorksThe main editor window is split into two sections: Rules (upper) andMappings (lower). For this tutorial we are only interested in themappings section. The mappings section shows the From Type Tree(left) and the To Type Tree (Right). In the next few steps we will beusing a simple drag-and-drop methodology to complete the mappingsbetween the two Type Trees.2.Expand the CustomerDelimited tree and the CustomerXML type treesby right-clicking on the top element of the type tree (CustomerDelimitedand CustomerXML) in the mappings section and selecting Show All fromthe menu as shown below in Figure 34 and Figure 35.Figure 34. Expanding the CustomerDelimited Type TreeFigure 35. Expanding the CustomerXML Type TreeGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 22 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks There is a section of the CustomerXML Type Tree that is used byWebSphere Transformation Extender to generate the xml line atbeginning of the XML document that it creates. It is necessary tohardcode values into the fields in the Prolog section so that the xml line is created correctly.3.Select the version field in the Prolog (0:1) section of the CustomerXMLtype tree and enter ”1.0”Figure 36. Populating the version fieldGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 23 of 33

developerWorks ibm.com/developerWorks4.Select the encoding (0:1) field in the Prolog (0:1) section of theCustomerXML type tree and enter ”UTF-8”.5.Select the standalone (0:1) field in the Prolog (0:1) section of theCustomerXML type tree and enter ”no”.6.Right-click the pcdata (0:1) field in the misc (0:1) Elem section andselect Insert NONE from the menu. Validate that the CustomerXML TypeTree now looks like Figure 37.Figure 37. CustomerXML Type TreeNow that the constant values have been set, the next step is to completethe mappings that will move data from the CustomerDelimited TypeTree to the CustomerXML Type Tree. We will use drag-and-drop tocreate the mapping rules.7.Select the id Field line in the CustomerDelimited type tree and drag anddrop it onto the id (0:1) line in global Customer sequence section of theGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 24 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks CustomerXML type tree as shown in Figure 38. The result should be asshown in Figure 39.Figure 38. Drag-and-drop mapping from CustomerDelimited toCustomerXMLFigure 39. id (0:1) mapping8.Select the firstName Field line in the CustomerDelimited type tree anddrag and drop it onto the firstName (0:1) line in global Customersequence section of the CustomerXML tree.9.Select the lastName Field line in the CustomerDelimited type tree anddrag and drop it onto the lastName (0:1) line in global Customersequence section of the CustomerXML tree. Validate that theCustomerXML Type Tree now looks like Figure 40.Figure 40. Complete CustomerXML MappingGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 25 of 33

developerWorks ibm.com/developerWorks10. Save your changes.Complete the CustomerXMLToDelimited MapNow that the CustomerXMLToDelimited Map has an Input Card and an Output Card,the data mappings that transform data from the XML format into the delimitedformat can be completed.1.Double-click the CustomerXMLToDelimted map in the Outline Viewerto open the map in the main editor window.2.Expand the CustomerXML tree and the CustomerDelimited type treesby right-clicking on the top element of the type tree (CustomerXML andCustomerDelimited) in the mappings section and selecting Show All fromthe menu.The delimited format has a BOName field that needs to be hard coded toGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 26 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks “Customer”.3.Enter the text ”Customer” in the BOName field of theCustomerDelimited tree as shown in Figure 41.Figure 41. CustomerDelimited Type Tree with BOName value hardcoded4.Select the id (0:1) line in global Customer sequence section of theCustomerXML type tree and drag and drop it onto the id Field line inthe CustomerDelimited tree as shown in Figure 42. The result should beas shown in Figure 43.Figure 42. Drag-and-drop mapping from CustomerXML toCustomerDelimitedFigure 43. id mappingGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 27 of 33

developerWorks ibm.com/developerWorks5.Select the firstName (0:1) line in global Customer sequence section ofthe CustomerXML type tree and drag and drop it onto the firstNameField line in the CustomerDelimited tree.6.Select the lastName (0:1) line in global Customer sequence section ofthe CustomerXML type tree and drag and drop it onto the lastNameField line in the CustomerDelimited tree. Validate that the CustomerType Tree now looks like Figure 54.Figure 44. Completed CustomerDelimited mapping7.Save your changes.Build the Map ExecutablesNow that the data transformation mappings have been completed for both theCustomerXMLToDelimited and the CustomerDelimitedToXML maps, it isnecessary to Build the Map Executable files.This can be thought of as compiling the map source into an executable format.The result of this task will be two .mmc files (CustomerDelimitedToXML.mmc andCustomerXMLToDelimited.mmc) that are the map executables.1.Double-click the CustomerDelimitedToXML map in the Outline Viewerto open the map in the main editor window.2.Right-click on CustomerDelimitedToXML map in the Outline Viewerand select Build.3.Double-click the CustomerXMLToDelimited map in the Outline Viewerto open the map in the main editor window.Generating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 28 of 33 Copyright IBM Corporation 1994, 2008. All rights reserved.

ibm.com/developerWorksdeveloperWorks 4.Right-click on CustomerDelimitedToXML map in the Outline Viewerand select Build.5.Verify that the Map Executables have been created in the MapExecutables folder of the Extender Navigator.Figure 45. Map ExecutablesUpdate WTXLibIn this section you will copy the artifacts that are required at runtime from theWebSphere Transformation Extender development to the WTXLib Library.The generated CustomerDelimted.xsd file that contains XSD definition that wasused for the CustomerXML Type Tree must be copied into the root directory ofWTXLib (the same location as the Customer.xsd file).The Map Executables: CustomerDelimitedToXML.mmc andCustomerXMLToDelimited.mmc must be available to the WebSphereTransformation Extender data binding at runtime in a pre-defined location (/WTXfolder) and therefore must be present in either a library or a module.1.Close any open Maps2.Switch to Business Integration Perspective.3.Switch to the Physical Resources Tab in the Business IntegrationPerspective.4.Expand the CustomerMapProject and WTXLib projects as shown inFigure 46.Figure 46. Expanded Physical Resources ViewGenerating the WTX maps for use with WebSphere Process Server and WebSphere ESB Copyright IBM Corporation 1994, 2008. All rights reserved.Page 29 of 33

developerWorks ibm.com/developerWorks5.Copy the CustomerDelimited.xsd file from the CustomerMapProjectand Paste it into WTXLib. (DO NOT DRAG AND DROP. YOU MUSTUSE CUT AND PASTE). The result should be as shown in Figure 47.Figure 47. Updated WTXLib6.Create a new folder named WTX in the WTXLib library.7.Copy the CustomerDelimitedToXML.mmc andCustomerXMLToDelimited.mmc files from the CustomerMapProjectand paste them into the WTX folder of the WTXLib. (DO NOT DRAGAND DROP. YOU MUST USE CUT AND PASTE). The result should beas shown in Figure 48.Generating the WTX maps for use with WebSphere Process Server and WebSphere ESBPage 30 of 33 Cop

WebSphere Transformation Extender V8.x maps using the WebSphere ESB and WebSphere Process Server V6.1 WebSphere Transformation Extender Data Binding. In this tutorial, you'll create WebSphere Transformation Extender maps using the WebSphere Transfo