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:
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.
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.
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.
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.
Click OK.
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.
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.
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.
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.
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.