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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
