Setting up an advanced schema

Talend Open Studio for ESB User Guide

EnrichVersion
6.4
EnrichProdName
Talend Open Studio for ESB
task
Design and Development
EnrichPlatform
Talend Studio

This section describes how to define an Advanced WebService schema. For information about how to define a Simple WSDL schema, see Setting up a simple schema.

Defining general properties

  1. In the Repository view, expand the metadata node.

  2. Right-click Web Service and select Create WSDL schema from the context menu list.

  3. Enter the generic schema information, such as its Name and Description.

  4. Click Next to select the schema type in step 2.

Selecting the type of schema (Advanced)

In this step, you must indicate whether you want to create a Simple or an Advanced schema. In this example, an Advanced schema is created.

  1. In the dialog box, select the Advanced WebService option.

  2. Click Next to defineprecise Web Service parameters.

Defining the port name and operation

  1. Type in the URI of the Web Service WSDL file manually by typing in the WSDL field, or click the Browse... button to browse your directory if your WSDL is stored locally.

  2. Click the Refresh button to retrieve the list of port names and operations available.

  3. Select the port name to be used, in the Port Name zone, countrySoap12 in this example.

  4. Select the operation to be carried out in the Operation zone.

    In this example, select GetCountryByCountryCode(parameters):string to retrieve the country name for a given country code.

Next, you need to define the input and output schemas and schema-parameter mappings in the Input mapping and Output mapping tabs.

Defining the input schemas and mappings

To define the input schema and mappings, do the following:

  1. Click the Input mapping tab to define the input schema and set the parameters required to execute the operation.

  2. In the table to the right, select the parameters row and click the [+] button to open the [ParameterTree] dialog box.

  3. Selectthe parameter you want to use and click OK to close the dialog box.

    A new row appears showing the parameter you added, CountryCode in this example.

  4. In the table to the left, click the Schema Management button to open the [Schema] dialog box.

  5. Define the input schema.

    In this example, the schema has only one column: CountryCode.

  6. Click OK to validate this addition and close the dialog box.

  7. Create mappings between schema columns and parameters.

    In this example, drop the CountryCode column from the left table onto the parameters.CountryCode row to the right.

    A red line shows that the column is mapped.

    Note

    If available, use the Auto Map button situated to the top of the tab, to carry out the mapping automatically.

Defining the output schemas and mappings

To define the output schema and mappings, proceed as follows:

  1. Click the Output mapping tab to define the output schema and set its parameters.

  2. In the table to the left, select the parameter row and click the [+] button to add a parameter.

    The [ParameterTree] dialog box opens.

  3. Select the parameter and click OK to close the dialog box.

    A new row appears showing the parameter you added, GetCountryByCountryCodeResult in this example.

  4. In the table to the right, click [...] to open the [Schema] dialog box.

  5. Define the output schema.

    In this example, the schema has only one column: Result.

  6. Click OK to validate your addition and close the dialog box.

  7. Create output parameter-schema mappings.

    In this example, drop the parameters.GetCountryByCountyCodeResult row from the table to the left onto the Result column to the right.

  8. Click Next to finalize the schema.

Note

Depending on the type of the output, you can choose to normalize or denormalize the results by clicking the Normalize and Denormalize buttons.

Finalizing the end schema

In this step the wizard displays the output schema generated.

You can customize the metadata by changing or adding information in the Name and Comment fields and make further modifications using the toolbar, for example:

  1. Add or delete columns using the and buttons.

  2. Change the column order by clicking the and arrows.

  3. Click Finish to finalize your advanced schema.

    The new schema is added to the Repository under the corresponding Web Service node. You can now drop it onto the design workspace as a tWebService component in your Job.