Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Configuring the transformation

Configuring the transformation

When you configure the web services transformation, you connect a source object, configure properties for the transformation, map incoming fields to requested fields for the web service, and map the response to output fields to create one or more success groups.
Data Integration
creates a fault group automatically but you can choose whether to map it to the output fields.
  1. Create a mapping and add the source objects you want to work with.
  2. Add a Web Services transformation to the canvas.
  3. Connect the source to the Web Services transformation.
  4. Select the business service and operation in the
    Web Service
    tab.
  5. On the
    Request Mapping
    and
    Response Mapping
    tabs, create the field mappings between the source fields and the web service request.
    For an illustration of the mapping process, see Web Services transformation example.
  6. On the
    Output Fields
    tab, review the success groups, fault group, and field details. You can edit the field metadata, if needed. The success groups contain the SOAP response from the web service. The fault group contains SOAP faults with the fault code, string, and object name that caused the fault to occur.
  7. Define the advanced properties.
  8. Save and run the mapping.
For additional information about the mapping process, see the following sections:

Advanced properties

The following table describes the properties available for the Web Services transformation from the
Advanced
tab:
Property
Description
Cache Size
Memory available for the web service request and response. If the web service request or response contains a large number of rows or columns, you might want to increase the cache size. Default is 100 KB.
Allow Input Flush
The
mapping
task creates XML when it has all of the data for a group. When enabled, the
mapping
task flushes the XML after it receives all of the data for the root value. When not enabled, the
mapping
task stores the XML in memory and creates the XML after it receives data for all the groups.
You cannot select the option to allow input flush if you are connecting to multiple source objects.
Transaction Commit Control
Control to commit or roll back transactions based on the set of rows that pass through the transformation. Enter an IIF function to specify the conditions to determine whether the
mapping
task commits, rolls back, or makes no transaction changes to the row. Use the transaction commit control if you have a large amount of data and you want to control how it is processed.
You cannot configure a transaction commit control if you are connecting to multiple source objects.

Mapping incoming fields

When you define the request mapping, you can configure relationships between more than one source object. You configure relationships between the response mapping and the output fields separately.
When you map incoming fields, note the following guidelines:
  • If you need to apply an expression to incoming fields, use an Expression transformation upstream of the Web Services transformation.
  • To ensure that a web service request has all the required information, map incoming derived type fields to fields in the request structure.
You can map the incoming fields to the request mapping as shown in the following image:
The image shows incoming field "item_int_id" mapped to the "internalid" element in the request structure.
Drag each incoming field onto the node in the request structure where you want to map it.

Working with multiple source objects

If you have multiple sources, note the following requirements:
  • Any source fields you want to designate as primary key and foreign key must use the data type Bigint or String. If needed, you can edit the metadata in the Source transformation.
    If the Bigint data type is not available for a source, you can convert the data with an Expression transformation upstream of the Web Services transformation.
  • Ensure that the source data is sorted on the primary key for the parent object and sorted on the foreign key and primary key for child objects.
  • Map one of the fields or a group of fields to the recurring elements. In the incoming fields, you can see where each recurring element is mapped.
  • Map at least one field from each child object to the request structure.
  • You must map fields from the parent object to fields in the request structure that are higher in the hierarchy than fields from the child object.
  • For child objects, select a primary key and a foreign key.
    • On the
      Incoming Fields
      tab, select the source object you want to designate as the parent object.
    • Right-click on an incoming field in the tree to designate the primary key and foreign key.
    • For the foreign key, specify the parent object.
  • Do not choose a foreign key for the parent object.

Mapping outgoing fields

On the
Response Mapping
tab, you map the response structure to the output fields you want to use. You can choose relational or denormalized format for the output fields.
When you choose
Relational
, the transformation generates the following output groups:
  • One output group for the parent element.
  • One output group for each element in which the cardinality is greater than one.
  • FaultGroup, if it is supported by the connection type you are using.
When you choose
Denormalized
, the transformation generates the following output groups:
  • Output group for the parent element. In denormalized output, the element values from the parent group repeat for each child element.
  • FaultGroup, if it is supported by the connection type you are using.
Right-click the node in the node of the response where you want to map the response to output fields. You can choose to map all descendants or only the immediate children, as shown in the following image:
The image shows the choices you have when you right-click a node in the response. You can map all descendants, map immediate children, unmap all descendants, or unmap immediate children.