Business Intelligence and Data Warehousing with Kettle
summary
Overview of Kettle, an open-source (LGPL) Java ETL tool for building and distributing data warehouses, covering its four modules (Spoon GUI, Pan batch executor, Chef job designer, Kitchen batch job runner), metadata-driven transformations, ~35 transformation steps and ~10 job types, broad database support (MySQL, SQL Server, Oracle, DB2, PostgreSQL, etc.), and optimized features for inserts, batch updates, slowly changing dimensions (Kimball Types I–III) and junk dimensions. Demonstration of Kettle in a Data Warehouse build, description of its plugin mechanism (example: SAP R/3 connector by Proratio), project status (downloads, contributors) and future development including Pentaho integration and commercial support.
AI-written summary · about
related talks
32mHow to Build a Data Warehouse?
04mbig data blueprints
30mData Engineering building your BI infrastructure from scratch
41mRole of Private Data Lake for Sustainable Business Growth
26mModernize your Enterprise Data Warehouse & generate value from data
01h 01mModern Data Warehousing Strategy
38mReigniting the ETL vs. ELT Debate - Which Better Supports the Business?
42mWeb Development To Big Data. A Journey