Configuring the components - 7.1

Executing Jobs

author
Talend Documentation Team
EnrichVersion
Cloud
7.1
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
Deployment > Deploying > Executing Jobs
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tMysqlInput to open its Basic Settings view in the Component tab.
  2. In the Table Name field, enter the name of the table from which the data will be retrieved. In this example, it is student.
  3. Click the [...] button next to Edit schema to open the Schema dialog box and define the schema of the table student by adding two columns: sid of Integer type and sname of String type.
  4. Click the Guess Query button to fill the Query field with the SQL query statement to be used to retrieve data from the specified table.
  5. Select the Specify a data source alias check box and in the Data source alias field displayed enter the data source alias specified in the data source configuration file datasource-mysql.xml on Talend Runtime side. In this example, it is jdbc/sample.
  6. Double-click the tLogRow component to open its Basic settings view.
  7. In the Mode area, select Table (print values in cells of a table) for better readability of the result.