Writing and reading data in an H2 database with an SQL statement - Cloud - 8.0

Database (Mediation)

Version
Cloud
8.0
Language
English
Product
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components (Mediation)
Data Quality and Preparation > Third-party systems > Database components (Mediation)
Design and Development > Third-party systems > Database components (Mediation)
Last publication date
2023-08-17

This scenario applies only to Talend Open Studio for ESB, Talend ESB, Talend Data Services Platform, Talend MDM Platform, Talend Real Time Big Data Platform, and Talend Data Fabric.

For more technologies supported by Talend, see Talend Mediation Components.

This scenario shows how to:
  • declare a reusable database connection,
  • create a database table with an SQL statement,
  • insert data in a table with an SQL statement extracted from Route message body,
  • read data from a database.

To execute this use case, you need an H2 database engine to be started.