How to Set Up Pentaho Community Build Framework IntroductionPentaho BI Server Setup with CBFJava, Tomcat and AntSet environment variablesUsing the GUIUsing Command LineCheck Ant and Java are workingCreating the .ant directoryXMLTask.jarSubversionDatabaseCBF Build XMLDownload a BI Server BuildCreate build.propertiesStart Hypersonic DBCreate the buildUbuntu (Linux) SetupUsing Applications > Ubuntu Software CenterUsing TerminalCreate the .ant DirectoryXMLTask.jarCBF Build XMLDownload a BI Server BuildCreate build.propertiesCreate patchesMac...
Saturday, 27 November 2010
Kettle: Handling Dates with Regular ExpressionThis is the second tutorial that focuses on using regular expressions with Pentaho Kettle (PDI). This is again a demonstration on how powerful regular expression acutally are.In this example we are dealing with a simplified data set containing date values. The problem is, that the date doesn't have a standard format. We have following values:date2010/1/22010/01/22010/1/022010/01/0220100102We assume for...
Friday, 26 November 2010
A short review of the "Pentaho Kettle Solutions" bookMatt Casters, Roland Bouman and Jos van Dongen's Kettle bible was released about 3 months ago and I finally managed to finish reading it (600+ pages!!!). This is the second book about Kettle: At the beginning of this year María Carina Roldán released "Pentaho 3.2 Data Integration: Beginner's Guide" (my review here), which is written in quite a hands-on/step by step approach. "Pentaho Kettle Solutions" is more a theoretical piece of work, mixed with a lot of examples (jobs and transformation...
Thursday, 18 November 2010
Pentaho Kettle Data Input: Pivoted DataI found quite an interesting example about importing a pivoted data set with an unknown amount of columns on the Pentaho forum. Matt Casters demonstrated a neat solution on how to import this data set. As this example is quite hidden away in the forum, I thought it would be a good idea to publish a short tutorial based on it.Our data set looks like this (download here) (Screenshot shows only part of the whole...
Friday, 12 November 2010
Using regular expressions with Pentaho Data Integration (Kettle)There are quite some transformations steps that allow you to work with regular expressions: Replace in string, Regex Evaluation, Modified Java Script Value to name a few. Today we will look at one (pretty unrealistic) example using the "Replace in string" step. Basically, we will cut the first word off a text (Note: This can be achieved by using other steps as well, but as we want...
Monday, 1 November 2010
Pentaho Data Integration Plugins Agile BIThis extremly useful plugin can be downloaded from the Pentaho website (plugin for PDI 4, plugin for PDI 4.1 RC1). [Due to the fact that this plugin is not open source, PDI doesn't have it installed by default. Pentaho was so kind to make it available for the community version for free.]Unzip the file into the data-integration/plugins/spoon directory. It will create a folder in there named agile-bi. Start spoon and the new capabilities will automatically be available.Once you have done this, fire up...
Subscribe to:
Posts (Atom)
