Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

Midstream XML Transformations Overview

Midstream XML Transformations Overview

XML definitions read or create XML data. However, sometimes you need to extract or generate XML inside a pipeline. For example, you might want to send a message to a TIBCO target containing an XML document as the data field. In this case, you need to generate an XML document before sending the message to TIBCO. Use a XML transformation to generate the XML.
You can create the following types of midstream XML transformation:
  • XML Parser transformation.
    The XML Parser transformation reads XML from one input port and outputs data to one or more groups.
  • XML Generator transformation.
    The XML Generator transformation reads data from one or more sources and generates XML. The XML Generator transformation has a single output port.
Use a midstream XML transformation to extract XML data from messaging systems, such as TIBCO, WebSphere MQ, or from other sources, such as files or databases. The XML transformation functionality is similar to the XML source and target functionality, except the midstream XML transformation parses the XML or generates the document in the pipeline.
Midstream XML transformations support the same XML schema components that the XML Wizard and XML Editor support. In addition, XML transformations support the following functionality:
  • Pass-through ports
    . Use pass-through ports to pass non-XML data through the midstream transformation. These fields are not part of the XML schema definition, but you use them to generate denormalized XML groups. You use these fields in the same manner as top-level XML elements. You can also use a pass-through field as a primary key for the top-level group in the XML definition.
  • Real-time processing.
    Use a midstream XML transformation to process data as BLOBs from messaging systems.
  • Support for multiple partitions.
    You can generate different XML documents for each partition.

0 COMMENTS

We’d like to hear from you!