Slawomir Chodnicki

To code, to ETL, or to SQL?

Whether you’re wrangling data to perform one-off analysis, ingesting data into a data-lake, or building a data…

Converting a MySQL dump to CSV files

I needed to migrate a set of tables from MySQL/MariaDB to a different SQL database recently. My source was not an actual live connection to the source database, but a SQL dump created by the mysqldump backup utility.

Improving startup time of Pentaho Data Integration

The price and value of analytic models

More often than not there is a semantic gap between the data an operational system works with, and metrics that are based on that data.

On entry points for ETL projects

ETL solutions tend to be opaque to the operators running them. Any non-trivial ETL solution has…

What is a data warehouse anyway?

The business intelligence world breeds plenty of jargon and acronyms. This story is about the core…

Testing strategies for data integration

Data integration processes benefit from automated testing in the same way any other…

The cost of ETL failures

ETL processes have the tendency to be brittle. They rely on other systems being up. They need data to be available…