Defining the data source

Procedure

In the design workspace, select tMysqlInput, and click the Component tab to define the basic settings for tMysqlInput.
Set the Property type to Repository and click the [...] button to select the relevant DB entry from the list. The connection details along with the schema get filled in automatically.
In the Table Name field, either type your table name or click the [...] button and select your table name from the list. In this scenario, the Mysql input table is called "rss_talend" and the schema is made up of four columns, TITLE, Description, PUBDATE, and LINK.
In the Query field, enter your DB query paying particular attention to properly sequence the fields in order to match the schema definition, or click Guess Query.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!