Scenario: Using query key to extract data from a given Sage X3 system - 6.1

Talend Open Studio for Big Data Components Reference Guide

Talend Open Studio for Big Data
Data Governance
Data Quality and Preparation
Design and Development
Talend Studio

This scenario describes a two-component Job used to extract one row of data from a given Sage X3 system. The object method is to be called, that means the variable elements of this object thus are attributes. The data used in this scenario can be found in the example provided by Sage X3.

Setting up the Job

  1. Drop the tSageX3Input component and the tLogRow components onto the workspace from Palette.

  2. Connect the tSageX3Input component to the tLogRow component using a Row > Main link.

Configuring the schema of tSageX3Input

  1. Double-click tSageX3Input to set its properties in the Basic Settings view.

  2. In the Schema field, select Built-In and click the three-dot button next to Edit schema to open the schema editor.

  3. In this editor, click the plus button 12 times beneath the schema table to add 12 rows into this table.

  4. Type in the names you want to use for each row. In this example, these rows are named after the publication names of the object attributes set in the Sage X3 Web server. These columns are used to map the corresponding attribute fields in the Sage X3 system.

  5. In the Type column, click the IMG row to display its drop-down list.

  6. From the drop-down list, select List as this attribute appears twice or even more and do the same to switch the types of the TIT2NBLIG row, the ITMLNK row and the ZITMLNK row to List as well for the same reason.

  7. Click OK to validate this change and accept the propagation prompted by a pop-up dialog box.

Configuring the connection to the Sage X3 Web server

  1. 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

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

  3. 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.

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

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

Setting up the mapping and configuring the query condition

  1. In the Group ID column and the Field name column of the Mapping table, type in values corresponding to the attribute group IDs and the attribute publication names defined in the Sage X3 Web server. In this example, the values are presented in the figure below.


    In the Mapping table, the Column column has been filled automatically with the columns you created in the schema editor.

  2. Select the Query condition check box to activate the Conditions table.

  3. Under the Conditions table, click the plus button to add one row into the table.

  4. In the Key column, type in the publication name associated with the object attribute you need to extract data from.

  5. In the Value column, type in the value of the attribute you have selected as the key of the data extraction. In this scenario, it is CONTS00059, one of the product references.

Job execution

  1. Press Ctrl+S to save your Job.

  2. Press F6 or click Run on the Run tab to execute the Job.

    The results are displayed on the Run console: