Blogspot - rpbouman.blogspot.com - Roland Bouman's blog
General Information:
Latest News:
A Generic Normalizer step for Kettle 21 Mar 2012 | 08:15 am
Abstract Kettle (a.k.a. Pentaho Data Integration) offers the standard Row Normalizer step to "unpivot" columns to rows. However, this step requires some configuration which presumes its input stream i...
Running Pentaho BI Server behind a proxy 20 Mar 2012 | 08:45 pm
To whom it may concern - a quick hands-on guide for running the Pentaho BI server behind a proxy Prerequisites This post assumes you're running Ubuntu linux (or at least a Debian) and that you have ...
Common Schema: dependencies routines 2 Dec 2011 | 09:17 am
Are you a MySQL DBA? Checkout the common_schema project by Oracle Ace Shlomi Noach. The common_schema is an open source MySQL schema that packs a number of utility views, functions and stored procedu...
MySQL Hacks: Preventing deletion of specific rows 22 Oct 2011 | 01:00 am
Recently, someone emailed me: I have a requirement in MYSQL as follows: we have a table EMP and we have to restrict the users not delete employees with DEPT_ID = 10. If user executes a DELETE statemen...
Fighting Spam: Word Verification 7 Oct 2011 | 06:50 pm
Hi All, this is a quick note to let you know that from now on, commenters on this blog will need to complete a word verification (captcha) step. Personally, I regret to have to take this measure. Le...
Re-implementing udf_init_error in MySQL 5.5 and up 25 Aug 2011 | 08:40 am
To whom it may concern - Today, I received an email from a user of the udf_init_error UDF (which resides in the lib_mysqludf_udf library). The purpose of this UDF is to generate an error condition, w...
Proposals for Codebits.EU 15 Aug 2011 | 07:45 pm
Codebits is an annual 3-day conference about software and, well, code. It's organized by SAPO and this year's edition is to be held on November 10 thru 12 at the Pavilhão Atlântico, Sala Tejo in Lisbo...
Regarding the MySQL Conference and Expo 2012 12 Aug 2011 | 09:59 pm
Last week, Baron Schwartz announced the Percona Live MySQL Conference and Expo 2012. Percona organized MySQL related conferences and seminars before, and from what I've heard, with considerable succe...
Working with namespaces and namespace prefixes in XSLT 1.0 22 Jun 2011 | 10:13 am
To whom it may concern - I'm currently developing a Xslt 1.0 stylesheet for analysis of XML Schema documents. As part of this work, I developed a couple of templates for working with namespace names ...
HPCC vs Hadoop at a glance 18 Jun 2011 | 08:22 pm
Yesterday I noticed this tweet by Andrei Savu: . This prompted me to read the related GigaOM article and then check out the HPCC Systems website. If you're too lazy to read the article or visit that ...
