MySQL has been one of the most popular databases amongst the Pentaho community. We receive questions and comments regularly about setting up and writing solutions for Pentaho on MySQL, which tells me people are putting MySQL to work in the business intelligence space. These questions were the catalyst for our Tech Tips, a collection of very useful how-to's for the Pentaho platform and Pentaho tools.
Today, I published a short tech tip regarding how to move the Pentaho sample data from HSQLDb to MySQL. Not rocket science, yet definitely made much easier with a Kettle transformation donated by Nic Guzaldo - thanks again Nic! Check it out, it's a good example of moving data with Kettle and also is a great utility tool to stick in your Pentaho toolbox. That one transformation can be tweaked to move the Pentaho sample data to just about any JDBC compliant database.
Nic's full contribution is actually a complete reporting solution that comprehensively covers a plethora of Pentaho features - secure filters, parameters, variable replacements, more MySQL 5.0 tricks just to name a few. In my next posts I'll talk more about the "Guzaldo mini-series", look for it!
Friday, August 11, 2006
Subscribe to:
Post Comments
(
Atom
)
About Me
- Gretchen Moran
- Hi, I'm Gretchen. My career, for more than 20 years, has revolved around the ever changing landscape of software engineering, specifically building commercial products to move, transform and build value from data. Today, while I love to stay close to technology and like to say my coding skills are just current enough to be dangerous, my passion is now focused on building world class software development teams.
4 comments :
Hi Gretchen,
I'm really thrilled to see your blog!
Much to my regret, I did not find enough much time to continue my series on making MySQL Samples for Pentaho. I hope I will find some time next week (holiday).
I'm getting quite some private emails concerning Pentaho in response to the articles I wrote thusfar, and what else can I do but direct them to your community pages or sales department ;)
Keep it up!
Cheers,
Roland Bouman
I would be very interested in looking at this moving to mysql thing but the link in your blog no longer works.
Thanks
Rob,
My apologies! We recently moved alot of our web site content, and now it looks like I need to do some blog updating! This entry is fixed now :)
The URL you want is corrected in the post.
all the best,
G
Post a Comment