Scenario: Inserting data in MySQL database - 6.3

Talend Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes a two-component Job which carries out the same operation as the one described for tMysqlOutputBulk properties and tMysqlBulkExec properties, although no data is transformed.

  • Drop a tRowGenerator and a tMysqlOutputBulkExec component from the Palette to the design workspace.

  • Connect the components using a link such as Row > Main.

  • Set the tRowGenerator parameters the same way as in Scenario: Inserting transformed data in MySQL database. The schema is made of four columns including: ID, First Name, Last Name, Address and City.

  • In the workspace, double-click the tMysqlOutputBulkExec to display the Component view and set the properties.

  • Define the database connection details in the corresponding fields, if necessary. Consult the recommendations detailed in Scenario: Inserting transformed data in MySQL database, concerning the conservation of connection details in the Repository, under the Metadata node. In the component view, select Repository in the Property Type field and then select the appropriate connection in the adjacent field. The following fields will be filled in automatically.

For further information, see Talend Studio User Guide.

  • In the Action on table field, select the None option as you want to insert the data into a table which already exists.

  • In the Table field, enter the name of the table you want to populate, the name being clients in this example.

  • In the Local filename field, indicate the access path and the name of the file which contains the data to be added to the table. In this example, the file is clients.txt.

  • Click on the Advanced settings tab to define the component's advanced parameters.

  • In the Action on data list, select the Insert records in table to insert the new data in the table.

  • Press F6 to run the Job.

The result should be pretty much the same as in Scenario: Inserting transformed data in MySQL database, but the data might differ as these are regenerated randomly everytime the Job is run.