 | Level: Intermediate Torsten Bittner (tbittner@us.ibm.com), Software Engineer, IBM
07 Sep 2006
You can use the SQL/XML query language to transform relational data into XML
format. Since it is cumbersome to manually write SQL/XML queries, IBM®
Rational® Data Architect simplifies this work by automatically
generating SQL/XML queries based on graphically defined mappings. Get an introduction to the SQL/XML generation component of Rational Data Architect.
Objectives
After taking this tutorial, you should be able to use Rational
Data Architect and its mapping editor to generate and run
SQL/XML queries.
Prerequisites
This tutorial assumes familiarity with relational databases, preferably DB2.
You should also have a good understanding of the XML and XSD standards. Basic knowledge of the SQL/XML query language is required. Basic knowledge of
Rational
Data Architect is beneficial, but not required. (Consult the article "Use Rational Data Architect to integrate data
sources" (developerWorks, March 2006) and part one of this series, "Access and integrate enterprise metadata with Rational Data Architect" (developerWorks, July 2006), for reference.)
System requirements
In order to execute the steps that are described in this tutorial, it is necessary
to have Rational Data Architect 6.1 and DB2 installed. You can download trial
versions of Rational Data Architect 6.1 and DB2 V8.2.
Formats html, pdf
Tutorial overview
This tutorial shows you, step by step, how to:
- Graphically define a mapping model between a relational
database model as the source and an XML schema definition
as the target
- Generate an SQL/XML query based on this mapping model
- Execute the SQL/XML query and analyze the result
- Define joins between multiple source columns
- Add transformation functions to the mapping model
| | | |
