Skip to main content

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.

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!