Scenario: Utilizing .NET in Talend – Docs for ESB 6.x
Scenario: Utilizing .NET in Talend This scenario describes a three-component Job that uses a DLL library containing a class called Test1.Class1 Class and invokes a method on it that processes the value and output the result onto the console. Document get from Talend https://help.talend.com Thank you for watching.
Scenario: Using PreparedStatement objects to query data – Docs for ESB 6.x
Scenario: Using PreparedStatement objects to query data This scenario describes a four component job which allows you to link a table column with a client file. The MySQL table contains a list of all the American States along with the State ID, while the file contains the customer information including the ID of the State…
Scenario: Using tMysqlSP to find a State Label using a stored procedure – Docs for ESB 6.x
Scenario: Using tMysqlSP to find a State Label using a stored procedure The following job aims at finding the State labels matching the odd State IDs in a Mysql two-column table. A stored procedure is used to carry out this operation. Drag and drop the following components used in this example: tRowGenerator, tMysqlSP, tLogRow. Connect…
Scenario: Using query key to extract data from a given Sage X3 system – Docs for ESB 6.x
Scenario: Using query key to extract data from a given Sage X3 system 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: Using the Oracle MERGE function to update and add data simultaneously – Docs for ESB 6.x
Scenario: Using the Oracle MERGE function to update and add data simultaneously This scenario describes a Job that allows you to add new customer information and update existing customer information in a database table using the Oracle MERGE command. Document get from Talend https://help.talend.com Thank you for watching.
Scenario: Using tJavaRow to handle file content based on a dynamic schema – Docs for ESB 6.x
Scenario: Using tJavaRow to handle file content based on a dynamic schema This scenario applies only to a subscription-based Talend solution. This scenario describes a three-component Job that uses Java code through a tJavaRow component to display the content of an input file and pass it to the output component. As all the components in…
Scenario: Using context parameters when reading a table from a database – Docs for ESB 6.x
Scenario: Using context parameters when reading a table from a database In this scenario, MySQL is used for demonstration purposes. We will read a table from a MySQL database, using a context parameter to refer to the table name. Document get from Talend https://help.talend.com Thank you for watching.
Scenario: Using a pivot column to aggregate data – Docs for ESB 6.x
Scenario: Using a pivot column to aggregate data The following scenario describes a Job that aggregates data from a delimited input file, using a defined pivot column. Document get from Talend https://help.talend.com Thank you for watching.
Scenario: Using a Sage X3 Web service to insert data into a given Sage X3 system – Docs for ESB 6.x
Scenario: Using a Sage X3 Web service to insert data into a given Sage X3 system 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….
Scenario: Using MongoDB functions to create a collection and write data to it – Docs for ESB 6.x
Scenario: Using MongoDB functions to create a collection and write data to it This scenario applies only to a Talend solution with Big Data. This scenario creates the collection blog and writes post data to it through the MongoDB functions. Document get from Talend https://help.talend.com Thank you for watching.