Scenario: Using a Sage X3 Web service to insert data into a given Sage X3 system - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes a two-component Job used to generate one row of data and insert the data into a given Sage X3 system. You can find the data used in this scenario in the example provided by Sage X3. The Sage X3 Web service is used to access an object.

Setting up the Job

  1. Drop the tFixedFlowInput and the tSageX3Output components onto the workspace from Palette.

  2. Connect the tFixedFlowInput component to the tSageX3Output component using a Row > Main connection.

Configuring the schema for the input data

  1. Double-click the tFixedFlowInput component to set its Basic Settings in the Component view

  2. Click the three-dot button next to Edit schema to open the schema editor.

  3. In the schema editor and then under the schema table, click the plus button four times to add four rows.

  4. Click OK to validate this changes and then accept the propagation prompted by the pop-up dialog box. The four rows appear automatically in the Values table of the Component view.

  5. In the Values table within the Mode area, type in the values for each of the four rows in the Value column. In this scenario, the values downward are:

    CONTS00059, Screen 24\" standard 16/10, Screen 24\" standard 28/10, 2

    .

    Warning

    These values in the Value column must be put between quotation marks.

Setting up the connection to the Sage X3 Web server

  1. Double-click tSageX3Output to set its properties from the Basic Settings view.

  2. In the Endpoint address field, type in the URL address of the Web service provided by the Sage X3 Web server. In this example, it is http://10.42.20.168:28880/adxwsvc/services/CAdxWebServiceXmlCC

  3. In the User field, type in the user name of the given Sage X3. In this example, it is ERP.

  4. In the Language field, type in the name of the X3 language code used to start a connection group. In this example, it is FRA.

  5. In the Pool alias field, type in the name of connection pool to be used. In this example, this connection pool is called TALEND.

  6. In the Publication name field, type in the publication name of the object to be called. In this scenario, the publication name is ITMDET.

  7. In the Action field, select insert from the drop-down list.

Setting up the mapping

  1. In the Field name column of the Mapping table, type in the field names of the attributes the selected data action is exercised on.

  2. In the Group ID column of the Mapping table, type in values corresponding to group IDs of the selected attributes. These IDs are defined in the Sage X3 Web server

    Note

    In the Mapping table, the Column column has been filled automatically with the columns retrieved from the schema of the preceding component.

Job execution

Press CTRL+S to save your Job and press F6 to execute it.

To verify the data that you inserted in this scenario, you can use the tSageX3Input component to read the concerned data from the Sage X3 server.

For further information about how to use the tSageX3Input component to read data, see Scenario: Using query key to extract data from a given Sage X3 system.