Adding and linking the components – Docs for ESB 6.x
Adding and linking the components Drop the following components from the Palette onto the design workspace: tMysqlConnection, tFixedFlowInput, tMysqlOutput, tCreateTable, tCombinedSQLInput, tCombinedSQLFilter, tCombinedSQLAggregate, tCombinedSQLOutput, tMysqlCommit, tMysqlInput and tLogRow. Connect tMysqlConnection to tFixedFlowInput using a Trigger > On Subjob Ok link Do the same to connect tFixedFlowInput to tCreateTable, tCreateTable to tCombinedSQLInput, tCombinedSQLInput to tMysqlCommit, and…
Adding the components – Docs for ESB 6.x
Adding the components Create a Job and drop the node RFC_READ_TABLE in the SAP Bapi folder of the SAP connection onto the design workspace as a tSAPBapi component to reuse the connection to the SAP system. Add the following components to the Job by typing theirs names in the design workspace or dropping them from…
Advanced settings of tMDMOutput – Docs for ESB 6.x
Advanced settings of tMDMOutput In the Component view, click Advanced settings to set the advanced parameters for the tMDMOutput component. Select the Extended Output check box if you want to commit master data in batches, and specify the number of lines per batch in the Rows to commit field. Click the […] next to Configure…
Basic settings of tMDMOutput – Docs for ESB 6.x
Basic settings of tMDMOutput In the design workspace, click tMDMOutput to open its Basic settings view. In the Input Schema list, select Built-In and then click the […] button next to the Edit Schema field to define the structure of the master data you want to load into the MDM server. The tMDMOutput component basically…
Building access to BigQuery – Docs for ESB 6.x
Building access to BigQuery Double-click tBigQueryOutput to open its Component view. Click Sync columns to retrieve the schema from its preceding component. In the Local filename field, enter the directory where you need to create the file to be transferred to BigQuery. Navigate to the Google APIs Console in your web browser to access the…
Classifying the output data with aggregate element – Docs for ESB 6.x
Classifying the output data with aggregate element In your Studio, open the Job used in , and double-click the tXMLMap component to open its Map Editor. Right-click the customer element in the output table and select Remove group element from the contextual menu. On the top of the output table, click the wrench icon and…
Closing the connection to the FTP server – Docs for ESB 6.x
Closing the connection to the FTP server Configure the tFTPClose component to close the connection to the FTP server. Double-click the tFTPClose component to open its Basic settings view. From the Component list drop-down list, select the tFTPConnection component that opens the connection you need to close. In this example, only one tFTPConnection component is…
Configuring data retrieval from hash cache and data output – Docs for ESB 6.x
Configuring data retrieval from hash cache and data output Double-click tHashInput to display its Basic settings view. Select Built-In from the Schema drop-down list. Click Edit schema to define the data structure, which is the same as that of tHashOutput. Select tHashOutput_1 from the Component list drop down list. Double-click tFileOutputDelimited to display its Basic…
Configuring data retrieving and display – Docs for ESB 6.x
Configuring data retrieving and display Double-click the tNeo4jInput component to open its Basic settings view. Select the Use an existing connection check box to reuse the connection opened by the tNeo4jConnection component. Click the […] button next to Edit schema and define the schema corresponding to the node properties you want to retrieve and display….
Configuring key generation – Docs for ESB 6.x
Configuring key generation Double-click tGenKey to display the Basic settings view and define the component properties. You can click and import blocking keys from the match rules created with the VSR algorithm and tested in the Profiling perspective of Talend Studio and use them in your Job. Otherwise, define the blocking key parameters as described…