Table of Contents

Search

  1. Preface
  2. Introducing B2B Gateway
  3. B2B Gateway administration
  4. Project and asset management
  5. EDI X12 and EDIFACT Messages
  6. Custom files with custom mappings
  7. Inbound Custom Files with Intelligent Structure Discovery
  8. File transfer tasks
  9. Partners
  10. Tracking and Monitoring Events
  11. B2B Gateway REST APIs
  12. Glossary

B2B Gateway

B2B Gateway

Step 4. Create Hierarchy Parser transformations

Step 4. Create Hierarchy Parser transformations

Create Hierarchy Parser transformations to transform source hierarchical data to relational database data. Create a transformation for each type of inbound message that you want to map.
  1. Add a
    Hierarchy Parser
    transformation to the mapping canvas and connect the
    Filler
    transformation of the relevant message type to the
    Hierarchy Parser
    transformation.
  2. In the
    Properties
    panel select the
    Input Settings
    tab, select the
    File
    input type, and then click
    Select
    .
    The
    Select Schema
    dialog box shows.
  3. Select the schema of the message type to add to the inbound flow. For example, if you create a mapping for an EDI X12 810 message, select the
    TS_810
    level. Click
    OK
    .
  4. Click the
    Input Field Selection
    tab and map the field
    FILE_PATH
    from the
    Incoming Fields
    column to the
    Hierarchical Schema Input Fields
    column.
  5. Click the
    Field Mapping
    tab. In the
    Schema Structure
    table expand the
    interchanges
    element, expand the
    interchange
    element, and then map fields to the
    Relational Fields
    area.
    For details, see the "Hierarchy Parser Transformation" section of the
    Data Integration Transformation Guide
    .

0 COMMENTS

We’d like to hear from you!