Writing and reading data in an H2 database with an SQL statement
This scenario applies only to Talend ESB, Talend Data Services Platform, Talend MDM Platform, Talend Real-Time Big Data Platform, and Talend Data Fabric.
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.