ETL Example
The ETL (Extract, Transform, Load) example shows how to load data into a database using Camel.
Overview
This example lives in the examples/camel-example-etl directory and will poll for XML files in the child src/data directory. When the files are detected, they are converted, using the fallback JAXB Type Converter to a PersonDocument class. This POJO is then transformed using a custom Type Converter into a CustomerEntity bean using the CustomerTransformer class. Then this bean is stored in the database via the JPA component.
Try looking at the source code which breaks down as follows
Java Class |
Purpose |
---|---|
CustomerEntity |
The JPA entity bean (i.e. a POJO with @Entity) |
PersonDocument |
The JAXB2 POJO used to parse the XML |
CustomerTransformer |
The custom Type Converter used to convert a PersonDocument into a CustomerEntity |
EtlRoutes |
The Camel routing DSL to define the flow from the files to the converter to the JPA endpoint |
Running the example
To run the example we use the Camel Maven Plugin. For example from the source or binary distribution the following should work
cd examples/camel-example-etl mvn camel:run