The visual nature of Spoon makes it accessible to business analysts, while the ability to inject JavaScript, Java, or Python steps ensures it has the "pro-code" flexibility that developers need. 3. Massive Connectivity Out of the box, PDI Community can talk to almost anything:
If you are looking to create content for the Community Edition (also known as Kettle), focus on its flexibility for modern ETL and AI-readiness . pentaho data integration community
MySQL, PostgreSQL, Oracle, SQL Server. NoSQL: MongoDB, Cassandra. Cloud: AWS S3, Google Drive, Azure Blob Storage. Files: CSV, Excel, XML, JSON, Avro, Parquet. Key Concepts: Transformations vs. Jobs The visual nature of Spoon makes it accessible
: Extract the folder and run the following based on your OS: : Double-click Linux/macOS ./spoon.sh from the terminal. 2. Core Concepts MySQL, PostgreSQL, Oracle, SQL Server
The primary desktop application used to design "Transformations" (data flow) and "Jobs" (workflow orchestration).
Documentation for (Java) Developers * PDI SDK: see "Embedding and Extending Pentaho Data Integration" within the Developer Guides. atlassian.net
: Show how to use the "REST Client" step to send data to OpenAI or Anthropic APIs for sentiment analysis or categorization before loading it into a database.
