Teradata XML Services - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata XML Services allow the transformation of XML structures to and from relational structures. XML Services refers to the concepts of 'publishing' as the ability to convert from a relational data model and types to an XML data mode and types and to 'shredding' as the ability to convert from the XML data model and types to a relational data model and types.

Feature Description
Generate XML Schema Definition File SQL Editor command option that allows you to generate an XML Schema Definition (XSD) file from an SQL statement.
Generate XML Stylesheet Transformation SQL Editor command option that launches the Generate XSLT Wizard that allows you to create an XSLT Stylesheet. XSLT Stylesheets translate from one XML schema to another when publishing SQL result sets as XML.
XSLT Generator User interface that allows you to generate an XSLT (Extensible Stylehsheet Language Transformation), mapping elements from a source schema to a target schema.
XSLT Stylesheet List The Object Viewer displays the list of XSLT Stylesheets within a Teradata database. The display also provides actions to view, register, replace, edit, and delete XSLT Stylesheets.
Java Bean Wizard The XML Services transform the data of an SQL result set to an XML structure used to display the data. The Java Bean Wizard takes you through the steps of creating a JavaBean[TM] from an SQL statement. It generates the canonical (or source XML Schema), allows you to select a target XML Schema, invokes the XSLT Generator to allow you to create the mappings between the source and target schema (generating the XSLT), and finally generates the JavaBean source code. The JavaBean source code contains calls to the Teradata XML Services to 'publish' an SQL result set. The resulting data resides in an XML structure transformed by the Teradata XML Services.
Teradata Plug-in for Eclipse features require that the Unicode version of the Teradata XML Services package is installed. You can verify the installation of the Unicode version by looking in the SYSXML database for the '_U' routines and tables.