If you do not have a WSDL from which to import a web service source or target definition, you can create the definition from a relational or flat file source or target. You can also manually define the ports for the source or target and specify the datatype and the occurrence.
When you create web service source and target definitions from other sources and targets or from manually defined columns, the Designer creates the views in the entity relationship mode. You cannot create web service sources or targets from other sources or targets in hierarchical relationship mode.
You can create web service source and target definitions from relational sources and targets created from the following relational databases:
Oracle
DB2
Informix
Teradata
Microsoft SQL Server
Sybase
When you create a web service source or target definition from relational or flat file sources or targets, the Designer lists the sources and targets available in the folder, including shortcuts to sources and targets.
Create the source and target definitions in the same process. After you create a web service source or target based on relational or flat file source or target, you can edit the columns of the source or target definition in the Designer workspace.
When you import a web service source or target definition from a WSDL, you can select the following options: