Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5.6
  • All Products

Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for Web Services
  3. Configuring PowerExchange for Web Services
  4. Web Service Sources and Targets
  5. Web Services Consumer Transformation
  6. Creating and Configuring Web Service Workflows
  7. Appendix A: Datatype Reference

PowerExchange for Web Services User Guide for PowerCenter

PowerExchange for Web Services User Guide for PowerCenter

Back Next

Configuring a Session with a Web Services Consumer Mapping

Configuring a Session with a Web Services Consumer Mapping

When you configure PowerExchange for Web Services workflows, you can configure web service source, target, and transformation session properties.
You can configure the following session properties:
  • Web Service application connection information.
     Optionally, specify a Web Service application connection for web service sources, targets, and Web Services Consumer transformations. If you do not specify a Web Service application connection, or if the Web Service application connection does not have an endpoint URL, the PowerCenter Integration Service uses the endpoint URL contained in the WSDL file. The endpoint URL also appears in the Web Services Consumer Properties when you edit a transformation.
  • Empty XML element handling.
     Specify whether to treat empty XML elements as null characters.
  • SOAP request data.
     Override the SOAP request that the PowerCenter Integration Service generated for the web service source.
  • SOAP action.
     Override the SOAP action value specified in the web service source or target definition or Web Services Consumer transformation.
  • Date-time format.
     Choose the local time or Greenwich Mean Time time format for date-time values that the session passes to a web service target or Web Services Consumer transformation.
  • Duplicate parent row handling.
     Specify whether the PowerCenter Integration Service fails the session or passes the first or last row when there are duplicate parent rows.
  • Orphan row handling.
     Specify whether the PowerCenter Integration Service logs an error or ignores orphan rows.
  • Reset and restart.
     You can reset the generated key sequence values or restart them at 1 for sources and transformations at the end of a session.
  • SOAP request cache directory and cache size.
     Specify the storage directory for and initial size of intermediate files for targets and transformations created during SOAP request generation.
  • SOAP fault handling.
     If a SOAP fault occurs, you can configure the session to fail or to write the fault message to a target.
  • SOAP response compression.
     You can configure SOAP response compression for web service sources and targets and Web Service Consumer transformations.
To configure session properties for PowerExchange for Web Services:
  1. Double-click a PowerExchange for Web Services session to open the session properties.
  2. Click the Mapping tab.
  3. If the mapping includes a web service source definition, click the Sources node.
  4. From the Connections settings on the Mapping tab (Sources node), optionally select a connection value for Application Multi-Group Source Qualifiers for web service sources.
  5. From the Properties settings, optionally modify the following properties:
    Property
    Description
    Treat Empty Content as Null
    Treat empty XML elements as null characters.
    Reset
    Reset the value of generated key sequence values for sources and transformations at the end of a session.
    Restart
    Restart generated key sequence values for sources and transformations at 1.
    SOAP Action
    Enter the URI for another web service operation to override the URI for the web service operation you imported for this source definition.
    Treat Fault as Error
    The PowerCenter Integration Service treats a SOAP fault as a row error and continues the session. When this property is disabled, the fault is sent as output to the data pipeline. Default is enabled.
    SOAP Request
    Enter a modified SOAP request to override the SOAP request that the PowerCenter Integration Service sends to the web service source. You can view the SOAP request in the Edit Tables dialog box for the web service source definition.
    SOAP Response Compression
    Select All if you want the PowerCenter Integration Service to enable HTTP response compression. If you select None, the PowerCenter Integration Service uses no compression. If the PowerCenter Integration Service connects to an IIS web server, set SOAP Response Compression to None.
  6. If the mapping includes a web service target definition, click the Targets node.
  7. From the Connections settings, optionally select a connection value for web service targets.
  8. From the Properties settings, optionally modify the following properties:
    Property
    Description
    XML DateTime Format
    Choose one of the following date-time formats for data that the session passes to a web service target or Web Service transformation:
    • Local Time. The time according to the PowerCenter Integration Service server time zone.
    • Local Time with Time Zone. The difference in hours between the PowerCenter Integration Service time zone and Greenwich Mean Time.
    • UTC. Greenwich Mean Time.
    Duplicate Parent Row Handling
    Choose one of the following values to indicate how the PowerCenter Integration Service handles duplicate parent rows during a session:
    • First Row
      .
       The PowerCenter Integration Service passes the first duplicate row to the target. The PowerCenter Integration Service rejects rows with the same primary key that it processes after this row.
    • Last Row
      .
      The PowerCenter Integration Service passes the last duplicate row to the target.
    • Error
      .
      The PowerCenter Integration Service passes the first row to the target. Rows that follow with duplicate primary keys increment the error count. The session fails when the error count exceeds the error threshold.
    Orphan Row Handling
    Choose one of the following values to indicate how the PowerCenter Integration Service handles orphan rows during a session:
    • Ignore. The PowerCenter Integration Service ignores orphan rows.
    • Error. The session fails when the error count exceeds the error threshold.
    SOAP Action
    Enter the URI for another web service operation to override the URI for the web service operation that you imported for this target definition.
    SOAP Request Cache Dir
    Directory that contains the temporary files that the PowerCenter Integration Service creates to generate a SOAP request.
    SOAP Request Cache Size
    Size, in bytes, of the directory that contains the files that the PowerCenter Integration Service creates to generate a SOAP request.
    Treat Fault as Error
    The PowerCenter Integration Service treats a SOAP fault as a row error and continues the session. When this property is disabled, the fault is sent as output to the data pipeline. Default is enabled.
    Null Content Representation
    Choose how to represent null content in the target.
    • No Tag. Do not output a tag.
    • Tag with Empty Content. Output just the tag.
    Default is No Tag.
    Empty String Content Representation
    Choose how to represent null content in the target.
    • No Tag. Do not output a tag.
    • Tag with Empty Content. Output just the tag.
    Default is Tag with Empty Content.
    SOAP Response Compression
    Select All if you want the PowerCenter Integration Service to enable HTTP response compression. If you select None, the PowerCenter Integration Service uses no compression. If the PowerCenter Integration Service connects to an IIS web server, set SOAP Response Compression to None.
  9. If the mapping includes a Web Services Consumer transformation, click the transformation under the Transformations node.
  10. From the Connections settings, optionally select a connection value.
  11. From the Properties settings, optionally modify the properties.
    Property
    Description
    Treat Empty Content as NULL
    Treat empty XML elements as null characters.
    Reset
    Reset the value of generated key sequence values for sources and transformations at the end of a session.
    Restart
    Restart generated key sequence values for sources and transformations at 1.
    SOAP Action
    Enter the URI for another web service operation to override the URI for the web service operation you imported for this source definition.
    SOAP Request Cache Dir
    Directory where intermediate files are stored for targets and transformations during SOAP request generation.
    SOAP Request Cache Size
    Initial size of intermediate files created for SOAP request generation.
    Treat Fault as Error
    The PowerCenter Integration Service treats a SOAP fault as a row error and continues the session. When this property is disabled, the fault is sent as output to the data pipeline. Default is enabled.
    Null Content Representation
    Choose how to represent null content in the target.
    • No Tag. Do not output a tag.
    • Tag with Empty Content. Output just the tag.
    Default is No Tag.
    Empty String Content Representation
    Choose how to represent null content in the target.
    • No Tag. Do not output a tag.
    • Tag with Empty Content. Output just the tag.
    Default is Tag with Empty Content.
    SOAP Response Compression
    Select All if you want the PowerCenter Integration Service to enable HTTP response compression. If you select None, the PowerCenter Integration Service uses no compression. If the PowerCenter Integration Service connects to an IIS web server, set SOAP Response Compression to None.
  12. Click OK.
0 COMMENTS
We’d like to hear from you!