Octopus Write Up
Today, I downloaded and fired up Octopus from ObjectWeb. I just recently had some issues with Kettle, and wanted to try out another Open Source ETL tool before attempting my own.I spent a few minutes fumbling with the installation scripts and RPM's (the RPM's don't seem to work on a Fedora Core 4 system). I grabbed the tar file, uncompressed it, and put it where it should go. Another ten minutes was spent trying to figure out what the developers were trying to do with the configure scripts.
I got the GUI (OctopusGenerator) up and going as the documentation explained, and spent only a few seconds actually setting up the JDBC connections ... within minutes I actually had the project working.
Although I can see the potential in using this project (or Kettle) -- by the time one has learned the ins and outs of the database, the tool, and built all of the necessary Java transformation / translation classes, you'll certainly wonder why you didn't just write your own. That being said, Octopus has some interesting use of what appears to be Rhino, allowing one to code Javascript transforms. Why not Beanshell? Groovy? These might make writing the actual Transforms a little less cumbersome.
We'll probably use it in the future ... as necessity dictates our requirements.
0 Comments:
Post a Comment
<< Home