Configuring the database and the response parameters - 7.3

ESB REST
Version
7.3
Language
English
Product
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 Real-Time Big Data Platform
Module
Talend Studio
Content
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

Procedure

  1. Double-click the tMysqlOutput component to open its Basic settings view.
  2. Leave the Property Type as Built-in and fill in the database connection details manually in the Host, Port, Database, Username and Password fields.
    If you have centralized your connection information to the database in the Metadata > DB Connections node of the Repository, you can select Repository from the Property Type list and browse to the centralized connection to have the fields automatically filled in. For more information about storing metadata, see Talend Studio User Guide.
  3. Fill in the Table field with the target database table name, users in this example.
  4. Select the actions to be carried out on the database table and data according to your needs from the corresponding lists. In this example, the target table will be created if it does not exist in the specified database, and data from client requests will be inserted, or updated if it already exists, to the database table.
  5. Click the Sync columns button to synchronize the table schema with the input schema.
  6. Double-click the tXMLMap component to open the Map Editor.
  7. Rename the root node in the output table: right-click the node, select Rename from the contextual menu, and specify a new name in the pop-up dialog box, user in this example.
  8. Select all the three columns in the input table and drop them onto the user node, and select the Create as sub-element of target node option from the pop-up dialog box to set these columns as sub-elements of the user node. When done, click OK to validate the mappings and close the Map Editor.
  9. Double-click the tRESTResponse component and set the response parameters according to your needs. In this example, we keep the default settings for all the parameters.