by Andrew Cave | Aug 6, 2018 | Analytics Products, How To, News, Troubleshooting
The Pentaho ETL tools are really powerful, flexible and useful. However, being so complex they are prone to sometimes throwing errors that aren’t that easy to interpret. To assist others with this, I’m posting some of these error strings and how I managed...
by Andrew Cave | May 14, 2018 | Data Engineer, How To
Creating a read-only user is one of those simple tasks you do once in a blue moon. Normally you can Google it and find somebody else’s script and away you go. Not the case with AWS Redshift! It’s spread all over the place, so I thought I would publish a...
by Andrew Cave | Apr 4, 2018 | Analytics at Operational Scale, Analytics Products, Data Engineer, How To, Main Blog
The Pentaho Business Analytics (BA) server is a production level application for storing, scheduling, creating and running all the Pentaho report types through your web-browser. But sometimes, you need to work on the commandline and put things precisely where you want...
by Andrew Cave | Jan 24, 2018 | Analytics Products, How To, Pentaho
Spoon: variable substitution in string A in the Calculator step This post is going to look at using the Calculator step to do variable or parameter interpolation into a string. In other words, we can use the Calculator step to do variable substitution instead of...
by Andrew Cave | Aug 26, 2017 | How To, Pentaho
The week before last I delivered the Pentaho DI1000 training to a group to our North Sydney office and I got asked a question that (it turned out) had an easy answer. And as with a lot of things, I hadn’t read it, somebody had told me. The question was: When...
