Dear Kettle friends,
Will Gorman and Mike D’Amour, Senior Developers at Pentaho, are presenting Pentaho’s Google integration work at the Google I/O Developer Conference. (at the Sandbox area to be specific) Yesterday, Pentaho announced that much.
Here are a few of the integration points:
Dear Kettle fans,
As expected there was a lot of interest in cloud computing at the MySQL conference last week. It felt really good to be able to pass the Bayon Technologies white paper around to friends, contacts and analysts. It’s one thing to demonstrate a certain scalability on your blog, it’s another entirely to have a smart man like Nicholas Goodman do the math.
Sorting massive amounts of rows is hard problem to take on. Making it scale on low-cost EC2 instances is interesting as it …
[Read more]Dear Kettle & MySQL fans!
I’m really looking forward to go to the MySQL User Conference next week, not just because I’m speaking in 2 sessions again, but perhaps also because these are “interesting” times for MySQL and Sun Microsystems. Pivotal times it would seem.
Here are the 2 sessions I’m going to do:
Dear reader,
In a little over 3 weeks, April 2nd and 3rd, we’re organizing a Pentaho Partner Summit at the Quadrus Conference Center in Menlo Park near San Francisco.
If you are (as the invitation describes) an “Executive, luminary, current or prospective partner from around the world” and if you come over you’ll meet myself, Julian Hyde and perhaps a couple of other architects as well. That is outside of a host of other interesting people like Zack Urlocker (MySQL) and of course Richard Daley our CEO. We’ll be doing a couple of lengthy sessions on Kettle and Mondrian …
[Read more]
Quick tip - suppose you need the result set of a MySQL stored procedure in your Pentaho Data
Integration (a.k.a. Kettle) Transformation, what do you
do?
A Call DB Procedure sounds promising, but as it
turns out, you can't use it to retrieve any result sets. Rather,
this type of step is meant have an input stream from another
source:
So, what can we do? The answer is simpler than might be
expected.
Just use an ordinary …
Hello Kettle fans,
Like Roland I got confirmation earlier this week that I could present my talk on “MySQL and Pentaho Data Integration in a cloud computing setting”, at the next MySQL user conference.
I’m very excited about the work we’ve done on the subject and it’s going to be great talking about it in April.
See you there!
Matt
Good news Kettle fans!
Our community is bound to become a bit larger as a whole group of students (38) at the Katholieke Hogeschool Mechelen (Batchelor level) will receive a one day workshop with Pentaho Data Integration (Kettle). This workshop will take place in early November, most likely the 4th.
It’s interesting to see that during that day we’ll be able to go through most of the work involved in reading and staging the data, data cleansing and a few slowly changing dimensions with a fact table. On top of that we’ll explain how to use Pentaho Data Integration in that setting. When time permits we’ll show how to set up a metadata model on top of that data to create reports on it. On top of that the students will get an idea about what exactly open source is all about.
Obviously, the …
[Read more]
I just read this post on Matt Casters' blog. Here, Matt describes why
Element
61's Jan Claes is dead wrong in the way he assesses the maturity of open source ETL tools.
Well, I've just read Jan Claes' article in the "research and insights" area of the Element61
website, and frankly, it is pretty easy to see how
unsubstantiated it is. Some may be tempted to classify the
article as …
Belgian consultancy company Element 61 has just posted an opinion piece under the disguise of a review on open source ETL.
What a load of utter nonsens. Try reading this:
Instead of using SQL statements to transform data, an Open Source ETL tool gives the developer a standard set of functions, error handling rules and database connections. The integration of all these different components is done by the Open Source ETL tool provider. The straightforward transformations can be implemented very quickly, without the hassle of writing queries, connecting to data sources or writing your own error handling process. When there are complex transformations to make, Open Source ETL tools will often not offer out-of-the-box solutions.
Well Mr Jan Claes, we’re perfectly capable of handling …
[Read more]Roland Bouman and I will be doing a presentation together at T-Dose on October 25th:
Building Open Source BI solutions with Pentaho and MySQL
It’s a free conference, feel free to join us there for a chat and/or a drink!
Until then,
Matt
