Data Governance > Third-party systems > ESB components > ESB REST components
Data Quality and Preparation > Third-party systems > ESB components > ESB REST components
Design and Development > Third-party systems > ESB components > ESB REST components
Last publication date
2024-02-21
About this task
To do this, proceed as follows:
Procedure
Double-click tMysqlInput to
display its Basic settings
view:
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.
Leave the Schema list as
Built-in and click the
[...] button next to the
Edit schema field.
In the schema editor, define the schema exactly like the one of
the tFixedFlowInput.
In the Table Name field, fill in
the name of the table in which the data are stored: users.
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")
