Configuring the tMysqlInput component

ESB REST

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend ESB
Talend Big Data Platform
Talend MDM Platform
Talend Data Services Platform
Talend Real-Time Big Data Platform
Talend Data Management Platform
Talend Data Integration
Talend Open Studio for Data Integration
Talend Data Fabric
Talend Open Studio for MDM
Talend Open Studio for ESB
Talend Big Data
Talend Open Studio for Big Data
task
Data Quality and Preparation > Third-party systems > ESB components > ESB REST components
Data Governance > Third-party systems > ESB components > ESB REST components
Design and Development > Third-party systems > ESB components > ESB REST components
EnrichPlatform
Talend Studio

About this task

To do this, proceed as follows:

Procedure

  1. Double-click tMysqlInput to display its Basic settings view:
  2. From the Property Type list, leave Built-in and fill in the Host, Port, Database, Username and Password fields manually. If you centralized your connection information to the database in the Metadata > DB Connections node of the Repository, you can select Repository from the list and the fields will be automatically filled in.
    For more information about storing metadata, see Talend Studio User Guide.
  3. Leave the Schema list as Built-in and click the [...] button next to the Edit schema field.
  4. In the schema editor, define the schema exactly like the one of the tFixedFlowInput.
  5. In the Table Name field, fill in the name of the table in which the data are stored: users.
  6. Leave the Query Type list as Built-in and fill in the Query field with the following SQL query allowing to explore the database data with the URI query set in the tRESTRequest component:
    "select * from users where id >= " + globalMap.get("getUsers.from") + " and id <= " + globalMap.get("getUsers.to")