Table of Contents

Search

  1. Preface
  2. Web Service Concepts
  3. Understanding the Web Services Provider
  4. Using the Web Services Hub Console
  5. Batch Web Service Operations
  6. Writing Client Applications
  7. Working with Web Service Sources and Targets
  8. Editing Web Service Sources and Targets
  9. Working with Web Service Mappings
  10. Working with Web Service Workflows
  11. Appendix A: Web Service Sample Client Applications
  12. Appendix B: Configure the Web Browser

Web Services Provider Guide

Web Services Provider Guide

Creating a Source or Target from a Relational or Flat File Source or Target

Creating a Source or Target from a Relational or Flat File Source or Target

Use this procedure to create a web service source or target in one of the following ways:
  • From a flat file source or target
  • From a relational source or target
  • By manually adding a column and specifying its name, datatype, and precision
To create a web service source or target from a relational or flat file source or target:
  1. To create a web service source, in the Source Analyzer, click Sources > Web Services Provider > Create Web Service Definition. To create a web service target, in the Target Designer, click Targets > Web Services Provider > Create Web Service Definition.
  2. Enter a name for the web service mapping where you plan to use the source and target definition.
    The Designer uses the web service definition name as the name of the source and target definitions. It adds the suffix
    _input
    to the source definition name or
    _output
    to the target definition name.
    If you know the columns you want to include in the web service source or target definition, you can add them directly to the source or target definition. If you have relational or flat file sources or targets in the folder, you can create the source or target definition based on the relational or flat file columns.
  3. To add a column to the list, click the Add button and specify the column name, datatype, and precision.
    The Web Services Hub ignores the Not Null property when you create a web service source with multiple occurring elements or when you create a web service target.
  4. To create a web service source or target based on the columns in a relational or flat file source or target definition, click the Import from Source/Target button and select a source or target definition.
    The Designer lists the columns found in the selected source or target.
  5. Click OK.
  6. Edit the column names and the precision of string columns if necessary.
    You can add columns to the definition and define their data types and properties. You can delete columns you do not want to use.
    You can specify whether the columns you define in the source or target definition occur once or multiple times.
  7. If the columns occur multiple times, select Multiple occurring elements.
    This option indicates that the columns as a group occur more than once. When you select this option, the Designer generates an element view that contains all the columns.
  8. If you are creating a source definition and you also want to create the target definition, click Create Target and repeat steps 3 to 7 to add the ports to the target definition.
    If you are creating a target definition and you also want to create the source definition, click Create Source and repeat steps 3 to 7 to add the ports to the source definition.
  9. To add message and client ports to the source or target definition, click Add message ports.
    The Designer adds the message and client ports to the envelope view of the source or target definition. If you are creating source and target definitions in the same process, the Designer adds the message and client ports to the envelope views of the source and target definitions.
  10. Click OK.
    The Designer creates the web service source or target definition.
Review the XML views in the source and target definitions to verify that the views and ports match your web service mapping requirements. To add, delete, or modify the columns, edit the source or target definition in the Designer workspace.

0 COMMENTS

We’d like to hear from you!