Gobán Saor

Posted in BI, ETL, Proto, RSSBus, SQLite, Talend, data, excel, kettle | Tagged AmazonAWS | 4 Comments

4 Responses

1. on November 14, 2007 at 9:15 pm | Reply Brian Johnson

   Thanks for sharing your experiences with Kettle and Talend. Have you looked at or tried Jitterbit? I have narrowed my list to these three and was looking for someone that might have tried it.

   
   
2. on November 14, 2007 at 10:03 pm | Reply gobansaor

   Brian,

   I’ve had it on my list for some time now to try out Jitterbit (that and Splunk http://www.splunk.com). My first impressions were of a high-end tool-set more suitable for very large organisations rather than the micro-ETL that I’m more interested in, so I’m unlikely to make time in the short-term (especially as it doesn’t support SQLite!!!) but if I do I’ll make sure to blog about it.

   Tom

   
   
3. on July 10, 2008 at 9:32 am | Reply I.Kato

   Apatar introduces a concept that is quite interesting though it is not designed so as to deal with large amounts of data. Indeed, the “no code” solution has its advantages but there are strings attached: it does hide the complexity of integration, but it also limits the flexibility of the software.

   In any case, Apatar is, indeed, more geared towards data mashups. In order to perform ETL, a tool that can manage great quantities of data is required, and in the open source world I do have been running into Talend Open Studio a couple times.

   
   
4. on July 10, 2008 at 1:03 pm | Reply gobansaor

   @I.Kato

   Yes, Talend (or Pentaho PDI aka Kettle) is what you need if you intend to do serious heavy lifting of data, but to be fair to Apatar, their product has improved a lot since I wrote this (including the addition of an Excel component!). Even so, even for ’simple’ mashups, I find Talend a more rewarding tool to use, particularly now that I’ve “rediscovered” Groovy as a scripting language for Talend.

   Tom