CODEWITHSUNDEEP
javaimportexportkettle
Koby
Koby

Reputation: 615

Import/Export data using ETL or Java Freamework

We want to add the ability to Import/Export data in our java webapp (implemented using Spring and Hibernate). Our webapp contains hierarchical data along with LOB data loaded from files. The requirement is to export the data into XML/binary files, bundle everything up in a ZIP file and import it into another instance of our application.

Do you have any experience or suggestions on which frameworks should I use in order to implement this (if any exist)?

I taught of using Pentaho's data integration (Kettle), but I think that it would be hard to test and maintain it, so I'm looking for any other java framework that might do the trick in order to compare between the two.

Upvotes: 2

Views: 1128

Answers (1)

James
James

Reputation: 1571

If you are using Oracle then I suggest that you use the data pump features of SQL Developer to do it. This will be much more reliable and straight forward then trying to implement something yourself and in my experience it's best to use the native migration features of your database.

I have some experience with Kettle and that could be a good option if you need to do some transformation, i.e., actual ETL, as part of the migration although, like you said, it's more difficult to test.

EDIT: If you need to make this part of a whole environment setup then I suggest you combine it with Puppet or Chef which can bootstrap the whole lot including app server, properties files, database scripts, etc.

Upvotes: 1

Related Questions