Configuring the components - 6.5

MySQL

author
Talend Documentation Team
EnrichVersion
6.5
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 ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > MySQL components
Data Quality and Preparation > Third-party systems > Database components > MySQL components
Design and Development > Third-party systems > Database components > MySQL components
EnrichPlatform
Talend Studio

Procedure

  1. A tRowGenerator is used to generate random data. Double-click on the tRowGenerator component to launch the editor.
  2. Define the schema of the rows to be generated and the nature of data to generate. In this example, the clients file to be produced will contain the following columns: ID, First Name, Last Name, Address, City which all are defined as string data but the ID that is of integer type.
    Some schema information don't necessarily need to be displayed. To hide them away, click on Columns list button next to the toolbar, and uncheck the relevant entries, such as Precision or Parameters.
    Use the plus button to add as many columns to your schema definition.
    Click the Refresh button to preview the first generated row of your output.
  3. Then select the tMap component to set the transformation.
  4. Drag and drop all columns from the input table to the output table.
  5. Apply the transformation on the LastName column by adding .toUpperCase() in its expression field.
    Then, click OK to validate the transformation.
  6. Double-click on the tMysqlOutputBulk component.
  7. Define the name of the file to be produced in File Name field. If the delimited file information is stored in the Repository, select it in Property Type field, to retrieve relevant data. In this use case the file name is clients.txt.
    The schema is propagated from the tMap component, if you accepted it when prompted.
  8. In this example, don't include the header information as the table should already contain it.
  9. Click OK to validate the output.
  10. Then double-click on the tMysqlBulkExec component to set the INSERT query to be executed.
  11. Define the database connection details. We recommend you to store this type of information in the Repository, so that you can retrieve them at any time for any Job.
  12. Set the table to be filled in with the collected data, in the Table field.
  13. Fill in the column delimiters in the Field terminated by area.
  14. Make sure the encoding corresponds to the data encoding.