September 17th 2008 06:08 pm
Getting started with Kettle
For those people starting with Kettle (Pentaho Data Integration) we created a Getting Started page on our Wiki.
Since I realized that for some people, simple and easy can never be simple and easy enough I created 8 mini-flash demos :
- Create a new transformation - create a step
(flash demo, 0′20″) - Create a hop between 2 steps (flash demo, 0′20″)
- Create a database connection (flash demo, 0′45″)
- Read a CSV file (flash demo, 1 minute 0′20″)
- Write to a database table (flash demo, 1′00″)
- Name and describe a transformation (flash demo, 0′40″)
- Execute a transformation (flash demo, 1′20″)
- Debug a transformation (flash demo, 1′00″)
The idea is that you get an idea of how things work in under 10 minutes.
Let me know what all y’all think. If there are videos/flash demos you like to share, please please feel free to let me know!
Until next time,
Matt
8 Comments »
Feris Thia on 18 Sep 2008 at 12:19 #
Hi Matt,
I created this very simple sample months ago… but it is in Indonesian. But maybe it could help,
http://sample.phi-integration.com/kettle/kettle_simple_transformation_flv.html
Regards,
Feris
Peter Schmidt on 18 Sep 2008 at 16:01 #
Morning Matt,
I think that these are very nice (short, simple, to the point) and address the target audience that you were going after.
Nice Job!
Peter
Matt Casters on 18 Sep 2008 at 16:26 #
Thanks Feris, I added it to the comments section of the Getting Started page. We’ll find a better spot for it over time.
sylvain on 18 Sep 2008 at 23:38 #
Hi matt,
Very good thing these “flash quick starts”
This week, I’ve downloaded Kettle 3.1 RC1, and I thank you for this very nice version :
- A better interface with performance graph, zoom function, a very cool ergonomics
- Some really nice steps like “split fields to row” (a very great idea: i’ve used dozens times the javascript step to do the same thing with rowClone method)
- Performance of the lookup step, with the new checkbox “load all data from table”
I’ll write a detailed article on my blog as soon as possible because…
… I get married on Saturday !!!!
All the best
Sylvain
Matt Casters on 18 Sep 2008 at 23:41 #
> … I get married on Saturday !!!!
Nothing beats that Sylvain! Congratulations to both of you!
Harris Ward on 20 Sep 2008 at 2:28 #
Hi Matt!
Great work mate! Im really impressed!!
As you know i am aiming for the same idea (video tutorials) and i saw you were using wink + Kubuntu. Its a little off topic but when you get the chance we need to have a chat about it
Anyhow, Take care and speak to you later!
Harris
kyle on 24 Sep 2008 at 17:20 #
Where were these videos when I started many months ago
Matt Casters on 25 Sep 2008 at 1:34 #
Kyle, they were in my (ever growing) backlog of-course