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.
- 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.