Ingesting XML Files & SQL Database Tables in Pentaho PDI | Lesson 6
Welcome to Lesson 6 of the complete Pentaho Data Integration (PDI) Masterclass. In this second installment of our Data Extraction deep-dive, we transition from basic flat files to enterprise-grade data ingestion.
You will learn how to extract data from hierarchical XML files using XPath mapping, and how to establish secure JDBC connections to relational databases (SQL) to pull live tables directly onto your Spoon canvas.
What we cover in this lesson:
-- Master the "XML input" step: Reading complex schemas, handling namespaces, and defining loop paths using XPath.
-- Setting up Database Connections: Adding JDBC drivers, configuring connection pooling, and testing your SQL environment.
-- Utilizing the "Table input" step: Writing efficient SQL queries, using parameters, and previewing relational tables.