How to Send Reports to a Slack Channel

Vince IarusciKnodeo, Pentaho, ReportingLeave a Comment

My work colleague Steven, often tells me that it bothers him when he’s forced to visit and log into many places to get the company reports he needs. He wants to avoid logging into separate reporting portals, intranet sites, file shares or native apps and would rather have his info prepared specifically for him on the communication tools he currently … Read More

Track Automated ETL Jobs in Pentaho

Vince IarusciData Integration, PentahoLeave a Comment

Overview You’ve set-up your Pentaho jobs and schedule them from the task scheduler or cron scheduler. The next day and each day after that, you get a flood of success and failure emails from your jobs that run overnight or every hour. We found that our developers spent just as much time wrangling these emails than troubleshooting the run issues. So … Read More

Generating a Date Dimension Table with Pentaho Data Integration

Vince IarusciBusiness Intelligence, Data Integration, Pentaho1 Comment

Overview A good date dimension is essential for any data warehouse or reporting database. If you don’t have the right tools, you’ll often find yourself generating this date dimension in Excel, which can be tedious. This reusable Pentaho Data Integration transformation lets you create a date dimension with a user-defined start date and the number of days. Feel free to … Read More