How To Create an XSL Transformation

When the service data schema is different from an external data schema received from or being sent to an external system, we must map the data in the external schema to the service schema. To achieve this task we use a mapping tool.

In the following example, we are using the Microsoft BizTalk Mapper to create an XSL Transformation (XSLT) script that describes the transformation; however, other transformation tools available on the market can be used. This example assumes that there is a file with customer contact information to be uploaded into the Oracle Utilities Customer Care and Billing customer contact table. It assumes that XML schemas for the input file and for the customer contact service already exist.

• Launch the Microsoft BizTalk Mapper.
• Enter the name of the input schema file as the source, e.g., CustomerContactsUploadSchema.xml.
• Enter the name of the service schema file as the target (e.g., CustomerContactAddRequestSchema.xml).
• BizTalk Mapper allows you to drag elements from the source XML to the target XML.
• When you are finished mapping elements, compile the transformation map.
• Save the transformation script with an appropriate name, e.g., CustomerContactsUpload.xsl.
• After saving the XSL script you need to edit it in Notepad and save it in ANSI encoding.

This XSL transformation script is now available for use as the Record XSL on the XAI Inbound Service - Staging page.