Talend Open Studio for ESB

Setting up the connection to the Alfresco server – Docs for ESB 6.x

Setting up the connection to the Alfresco server In the design workspace, double-click tAlfrescoOutput to display its basic settings. In the Alfresco Server area, enter the Alfresco server URL and user authentication information in the corresponding fields. In the TargetLocation area, either type in the base name where to put the document in the server,…

Setting the sorting condition – Docs for ESB 6.x

Setting the sorting condition Double-click tPigSort to open its Basic settings view. Click Sync columns to retrieve the schema structure from the preceding component. Click the [+] button beneath the Sort key table to add a new sort key. Select Age from the Column list and select ASC from the Order list. This sort key…

Setting up the connection to the Sage X3 Web server – Docs for ESB 6.x

Setting up the connection to the Sage X3 Web server 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…

Creating a Job to extract named entities from text data – Docs for ESB 6.x

Creating a Job to extract named entities from text data In this Job, tNLPPredict predicts named entities and automatically labels text data divided into tokens, using a classification model. Drop the following components from the Palette onto the design workspace: tMySQLInput, tNLPPredict, tFilterColumns and tFileOutputDelimited. Connect the components using Row > Main connections. Document get…

Setting up the child Jobs – Docs for ESB 6.x

Setting up the child Jobs Create a new Job named ChildJob1, and add a tFixedFlowInput component and a tLogRow component to it. Connect the tFixedFlowInput component to the tLogRow component using a Row > Main connection. Double-click the tFixedFlowInput component to open its Basic settings view. Click the […] button next to Edit schema and…

Training the model using Random Forest – Docs for ESB 6.x

Training the model using Random Forest Double-click tRandomForestModel to open its Component view. From the Label column list, select the column that provides the classes to be used for classification. In this scenario, it is label, which contains two class names: spam for junk messages and ham for normal messages. From the Features column list,…

Transforming messages to words – Docs for ESB 6.x

Transforming messages to words Double-click the tModelEncoder component labelled Tokenize to open its Component view. This component tokenize the SMS messages into words. Click the Sync columns button to retrieve the schema from the preceding one. Click the […] button next to Edit schema to open the schema editor. On the output side, click the…

Setting the schema and selecting an address provider – Docs for ESB 6.x

Setting the schema and selecting an address provider Double-click tBatchAddressRowCloud to display the Basic settings view and define the component properties. If required, click Sync columns to retrieve the schema defined in the input component. Click the Edit schema button to open the schema dialog box. tBatchAddressRowCloud proposes several predefined read-only address columns as shown…

Set up a query – Docs for ESB 6.x

Set up a query From the Basic settings view of tSAPBWInput, fill the Table Name field with the table name. In this scenario, table name “Measures” is for demonstration only. Fill the Query area with the query script. In this example, we use:

Note: Due to the limitations of the supported SQL queries, the…

Testing the KMeans model – Docs for ESB 6.x

Testing the KMeans model Double-click tPredict to open its Component view. Select the Define a storage configuration component check box and select the tHDFSConfiguration component to be used. From the Model type drop-down list, select Kmeans model. Select the Model on filesystem radio button and enter the directory in which the KMeans model is stored….