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.
Drop the tFixedFlowInput and the tSageX3Output components onto the workspace from Palette.
Connect the tFixedFlowInput component to the tSageX3Output component using a Row > Main connection.
Double-click the tFixedFlowInput component to set its Basic Settings in the Component view
Click the three-dot button next to Edit schema to open the schema editor.
In the schema editor and then under the schema table, click the plus button four times to add four rows.
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.
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
These values in the Value column must be put between quotation marks.
Double-click tSageX3Output to set its properties from the Basic Settings view.
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
In the User field, type in the user name of the given Sage X3. In this example, it is ERP.
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.
In the Pool alias field, type in the name of connection pool to be used. In this example, this connection pool is called TALEND.
In the Publication name field, type in the publication name of the object to be called. In this scenario, the publication name is ITMDET.
In the Action field, select insert from the drop-down list.
In the Field name column of the Mapping table, type in the field names of the attributes the selected data action is exercised on.
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
In the Mapping table, the Column column has been filled automatically with the columns retrieved from the schema of the preceding component.
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.