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