PDA

View Full Version : kettle for kiddies



kettle_bijugv
03-09-2006, 03:58 AM
Attachment: wishes2.jpg (http://forums.pentaho.org/archived_att/kettle/wishes2.jpg) Hi kettle team,


Kettle is indeed a remarkable project and has so many features that makes it is superior to most other ETL tools. However I feel that it is still a tool for the techies and not for kiddies. Most of the users i face in everyday life has no clue of java or javascript.



The more and more I work on kettle I wish these features were available so that even non-system specialist could benifit from using this tool.....



1. I wish you had a GUI mapping tool to dag-drop mapping between stream fields and table output columns.



2. I wish you had a drop down toolbox of the most commonly used string/numeric/date... functions (like concat,substring, lpad,rpad, str, format, to_date, etc... ) along with their syntax directly available in the calculator or javascript step rather than looking up the docs. A GUI tool to do this might be too much of asking.



3. It took me days to come up with a solution on how to convert a date from mm/dd/yyyy format to dd-mmm-yyyy format that oracle requires. (only because i'm not a javascript guru) I wish there was a simple built-in function to convert formats.



The list of wishes goes on.... Any dreams on these lines....



Regards
Biju.

MattCasters
03-09-2006, 03:58 AM
Hi Biju,

The features you requested have already been logged as trackers and will ALL be implemented in the future.

Rome wasn't built in a day and so far Kettle has been the result of after-hours programming for 4-5 years.
In the near future, more time can be allocated to enhance Kettle to be more user friendly.

In the mean time, please understand that Kettle is indeed meant for technical people, more to the point data warehouse architects and administrators. It is not meant for the kiddies. BTW, I dare you to name 1 ETL tool that is ...

Also: the next time you need to convert a String to a date, consult the Forum, check the manual or simply ask.

Finally, please understand that when I'm replying to mails such as this one, i'm not coding...

Peace,
Matt