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...
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...
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...
by Andrew Cave | Apr 10, 2017 | How To, Main Blog, Resources
Pentaho offers a step that handles the process of connecting to an SFTP server and putting and getting files, and (as always) orchestrating the steps leading up to and after the file transfer. The step relies on the Java implementation of the SSH2 connectors done by...
