SSIS vs Pentaho Cage Match

If you’re interested in a no holds barred, knock-down, drag-out,┬ácompetition of a leading commercial piece of software vs it’s open source counterpart….

You might have to look elsewhere. :-(

Not to completely disappoint you, but I have written a in-depth whitepaper about the features and abilities of Pentaho Kettle and Microsoft SSIS.



Microsoft SSIS and Pentaho Kettle:

A Comparative Study for Three-Tier Data Warehouses

Michael L Grecol

Georgia Southern University


Extraction, Transformation, and Loading (ETL) tools integrate heterogeneous schemata, extracting, transforming, cleansing, validating, filtering and loading data from sources into a data warehouse[1]. The ETL process and the associated tools may be used in a greatly varied number of situations where data must be cleaned and moved between data sources. The subject of ETL tools is too broad for a whitepaper; therefore, this whitepaper will only cover the use of two ETL tools (Microsoft SSIS and Pentaho Kettle) within the purview of data warehouse design and implementation.

This entry was posted in Database Technology, Published Works and Research and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

× 2 = fourteen

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>