If it's a dump, it just might be easier (as you said already) to import it directly into one database and then use SQL to pull what you want out (you may already have the SQL to do that, for example..
I blogged previously on the ease of use of GroovySql, which is Groovy‘s easy-to-use JDBC-based data access approach. In another blog post, I covered the utility of OracleXMLQuery, a class which easily ...