Configuring the input data - 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. Double-click the tRowGenerator component to open the Row Generator editor.
  2. Click the [+] button to add four columns and set their properties:
    • id, type Integer, 2 characters long.

    • firstName, type String, 15 characters long

    • lastName, type String, 15 characters long

    • city, type String, 15 characters long

  3. Define the function for each column:
    • For the id column, select Numeric.sequence from the Function list to generate sequence numbers.

    • For the firstName column, select TalendDataGenerator.getFirstName from the Function list to generate random first names.

    • For the lastName column, select TalendDataGenerator.getLastName from the Function list to generate random family names.

    • For the city column, select TalendDataGenerator.getUsCity from the Function list to generate random city names.

  4. In the Number of Rows for RowGenerator field, specify the number of data rows you want to generate, 10 in this example.
  5. Click the Preview button on the Preview tab to validate the generator settings.
  6. When done, click OK to close the editor and click Yes when prompted to propagate the schema to the next component.