Transforming Data Using the XQuery Mapper

XQuery Mapper Overview

Data Transformation

BEA XQuery Mapper

What Happened to DTF Files?

Transforming Data Using XQuery

Launching XQuery Mapper

To Launch Eclipse

XQuery Mapper Sample Project

To Launch the Sample Project

Creating a XQuery Mapper Project

To Create a XQuery Mapper Project

Creating and Importing Schema Files

Importing XML Schemas

To Import XML Schemas

Creating XML Schema Files Using XML Schema Editor

To Create an XML Schema File

Creating WSDL Files Using WSDL Editor

To Create a WSDL File

Importing MFL Schemas

To Import MFL Schemas

To Create MFL Files

Selecting Source and Target Data Types to Generate XQuery

To Select Source and Target Data Types

Using the Design View to Create Data Transformations

Creating Basic Element Transformations

To Create an Element to Element Transformation

Creating Basic Attribute Transformations

To Create an Attribute to Element Transformation

Creating Complex Map Transformations

To Create a Repeating Group to Repeating Group Transformation

Editing Map Transformations

Viewing and Editing Generated XQuery Files

To Open, View, and Edit an XQuery File

Using the Constraints Tab

Using the Target Expression Tab

Using the Target Expression Tab to Edit XQuery Code of a Link

To Edit the XQuery Code of a Link

Using the Target Expression Tab to Add If-Then-Else Constructs to a Link

Inserting Calls to XQuery Functions

Invoking XQuery Functions in a Query

To View the XQuery Functions and Variables in Eclipse

To Invoke an XQuery Function

Using Expression Variables

Using the Property Editor When Editing an XQuery file

Testing Map Transformations

XQuery Mapper Testing Functionality Overview

Validating During Design Time

Understanding Design View Graphical Representations

Link Menu Options

Understanding Map Representations

Understanding Map Transformation Links

XML Global Elements, Global Types, Local Elements, and Attributes

Examples: Manipulating and Constraining Data Using XQuery

Combining Data From Different Schemas

To Combine Data from Different Schemas

Mapping Repeating Elements and Creating a Join

Step 1. Create a New XQuery File

Step 2. Add a Conditional Constraint

To Add a Constraint

Step 3. Add Links to Populate Empty Element

To Populate the QuoteResponse Element

Step 4. Calculate Total Cost

To Calculate Total Cost

Step 5. Add a Constraint With Multiple Conditions

To Add a Constraint with Multiple Conditions

To Test the XQuery

Using the Union Option of the Constraints Tab

To Combine Sets of Data of the Same Type

Creating a Transformation Between a Repeating Source and Non-Repeating Target

To Create a Map Between a Repeating Source Group and a Non-Repeating Target Element

Creating a Transformation Between a Non-Repeating Source and Repeating Target

To create and a Non-Repeating Source Element and a Repeating Target Group

Creating a Nested If-Then-Else Expression

Step 1. Create New XQuery Transformation

To Create a New XQuery Transformation

Step 2. Create First If Condition

To Create the First If Expression

Step 3. Create First Nested If-Then-Else Condition

To Create the First Nested If-Then-Else Condition

Step 4. Create Second Nested If-Then-Else Condition

To Create the Second Nested If-Then-Else Condition

Using Recursive Schemas

To Create a Transformation Using Recursive Schemas

Creating Group By Key Fields XQuery Constructs

To Create a Group By XQuery Construct

Testing the Group By Key Fields XQuery Construct

Testing XQuery Files

Using Auto-Generated XML Files for Testing

Using Custom XML Files for Testing

Using Custom MFL (Non-XML) Files for Testing