I've used Pentaho Data Integrator (PDI) in the past for ETL type activities but I have recently been trying to find the fastest way to extract fields from XML for a REST response.
I did a search and found this video about using PDI to extract XML to SQL.
https://www.youtube.com/watch?v=112uo7uorvA
Now to find all those unbounded errors in my XML...