# Pentaho Academy ## Pentaho Academy - [Pentaho Academy](https://academy.pentaho.com/pentaho-academy.md) ## NEW - Pentaho 11 - [Pentaho 11 Installation](https://academy.pentaho.com/pentaho-11-installation-en/overview/readme.md): Pentaho Enterprise 11 Installation .. - [Whats New ..](https://academy.pentaho.com/pentaho-11-installation-en/overview/whats-new-...md): Pentaho 11 - [Getting Started](https://academy.pentaho.com/pentaho-11-installation-en/installation/getting-started.md): Archive installation of Pentaho Enterprise on Linux - Ubuntu 24.04 LTS .. - [Components](https://academy.pentaho.com/pentaho-11-installation-en/installation/getting-started/components.md): Overview of Pentaho Enterprise components .. - [Archive Installation](https://academy.pentaho.com/pentaho-11-installation-en/installation/archive-installation.md): Recommended installation option .. - [Prepare Environment](https://academy.pentaho.com/pentaho-11-installation-en/installation/archive-installation/prepare-environment.md): Preflight tasks .. - [Install Pentaho Server](https://academy.pentaho.com/pentaho-11-installation-en/installation/archive-installation/install-pentaho-server.md): Installation of Pentaho Server components .. - [Server Plugins](https://academy.pentaho.com/pentaho-11-installation-en/installation/archive-installation/install-pentaho-server/server-plugins.md): Installation of Pentaho User Console Plugins .. - [Install Client Tools](https://academy.pentaho.com/pentaho-11-installation-en/installation/archive-installation/install-client-tools.md): Installation of Clients Tools .. - [Kettle Plugins](https://academy.pentaho.com/pentaho-11-installation-en/installation/archive-installation/install-client-tools/ee-plugins.md): Extend functionality with EE plugins .. - [Post Installation Tasks](https://academy.pentaho.com/pentaho-11-installation-en/installation/post-installation-tasks.md): Hardening & performance .. - [Pentaho Upgrade & Patches](https://academy.pentaho.com/pentaho-11-installation-en/installation/pentaho-upgrade-and-patches.md): Pentaho Upgrade Installer .. - [Windows Installation](https://academy.pentaho.com/pentaho-11-installation-en/installation/evaluation-installation.md): Windows Evaluation Wizard .. - [Containers](https://academy.pentaho.com/pentaho-11-installation-en/installation/containers.md) - [Docker](https://academy.pentaho.com/pentaho-11-installation-en/installation/containers/docker.md): Docker deployment - Pentaho 11 + PostgreSQL 15 repository .. - [K3s](https://academy.pentaho.com/pentaho-11-installation-en/installation/containers/k3s.md): Lightweight Kubernetes .. - [Ubuntu Pentaho Lab](https://academy.pentaho.com/pentaho-11-installation-en/setup/ubuntu-pentaho-lab.md): Setup Pentaho Server + Plugins on Ubuntu .. - [Windows Pentaho Lab](https://academy.pentaho.com/pentaho-11-installation-en/setup/windows-pentaho-lab.md) - [Pentaho Containers](https://academy.pentaho.com/pentaho-11-installation-en/setup/pentaho-containers.md) - [Common Questions](https://academy.pentaho.com/pentaho-11-installation-en/faqs/common-questions.md) - [Pentaho Support](https://academy.pentaho.com/pentaho-11-installation-en/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/pentaho-11-installation-en/pentaho-support/pentaho-support/pentaho-support-utility.md) ## Pentaho 10 - [Pentaho 10 Installation](https://academy.pentaho.com/pentaho-10-installation/overview/readme.md): Archive Installation of Pentaho Pro Platform .. - [Pentaho Support](https://academy.pentaho.com/pentaho-10-installation/overview/pentaho-support.md) - [Getting Started](https://academy.pentaho.com/pentaho-10-installation/installation/getting-started.md): Archive installation of Pentaho Enterprise on Linux - Ubuntu 22.04 LTS .. - [Components](https://academy.pentaho.com/pentaho-10-installation/installation/getting-started/components.md): Overview of Pentaho Pro components .. - [Linux Installation](https://academy.pentaho.com/pentaho-10-installation/installation/archive-installation.md): Recommended installation option .. - [Prepare Environment](https://academy.pentaho.com/pentaho-10-installation/installation/archive-installation/prepare-environment.md): Preflight tasks .. - [Install Pentaho Server](https://academy.pentaho.com/pentaho-10-installation/installation/archive-installation/install-pentaho-server.md): Installation of Pentaho Server components .. - [Server Plugins](https://academy.pentaho.com/pentaho-10-installation/installation/archive-installation/server-plugins.md): Installation of Reporting Plugins .. - [Install Client Tools](https://academy.pentaho.com/pentaho-10-installation/installation/archive-installation/install-client-tools.md): Installation of Clients Tools .. - [Post Installation Tasks](https://academy.pentaho.com/pentaho-10-installation/installation/post-installation-tasks.md): Hardening & performance .. - [Pentaho Upgrade & Patches](https://academy.pentaho.com/pentaho-10-installation/installation/pentaho-upgrade-and-patches.md): Pentaho Upgrade Installer .. - [Windows Installation](https://academy.pentaho.com/pentaho-10-installation/installation/evaluation-installation.md): Windows Installation .. - [EE Plugins](https://academy.pentaho.com/pentaho-10-installation/installation/ee-plugins.md) - [Ubuntu Pentaho Lab](https://academy.pentaho.com/pentaho-10-installation/setup/ubuntu-pentaho-lab.md): Setup Pentaho Server + Plugins on Ubuntu .. - [Common Questions](https://academy.pentaho.com/pentaho-10-installation/faqs/common-questions.md) - [Pentaho Support](https://academy.pentaho.com/pentaho-10-installation/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/pentaho-10-installation/pentaho-support/pentaho-support/pentaho-support-utility.md) ## NEW - Pipeline Designer - [Pipeline Designer](https://academy.pentaho.com/pipeline-designer/pipeline-designer.md) - [Concepts & Terminology](https://academy.pentaho.com/pipeline-designer/concepts-and-terminology.md) - [Hello World](https://academy.pentaho.com/pipeline-designer/concepts-and-terminology/hello-world.md): Simple Transformation .. ## Client - Data Integration - [Pentaho Data Integration](https://academy.pentaho.com/pentaho-data-integration/overview/readme.md): Become an expert in creating automated data pipelines .. - [Getting Started](https://academy.pentaho.com/pentaho-data-integration/data-integration/getting-started.md): Get up and running .. - [Components](https://academy.pentaho.com/pentaho-data-integration/data-integration/components.md): Components, User Interface, Configuration options .. - [Configuring PDI UI](https://academy.pentaho.com/pentaho-data-integration/data-integration/components/configuring-pdi-ui.md): PDI UI configuration settings .. - [KETTLE Variables](https://academy.pentaho.com/pentaho-data-integration/data-integration/components/kettle-variables.md): The kettle.properties file contains global variables for KETTLE. - [Concepts & Terminology](https://academy.pentaho.com/pentaho-data-integration/data-integration/concepts-and-terminology.md): Understanding the key concepts & lingo .. - [Hello World](https://academy.pentaho.com/pentaho-data-integration/data-integration/concepts-and-terminology/hello-world.md): Simple transformation to illustrate key concepts .. - [Logging](https://academy.pentaho.com/pentaho-data-integration/data-integration/concepts-and-terminology/logging.md): Set the transformation logging level .. - [Error Handling](https://academy.pentaho.com/pentaho-data-integration/data-integration/concepts-and-terminology/error-handling.md): Handling errors in a transformation .. - [Projects](https://academy.pentaho.com/pentaho-data-integration/data-integration/projects.md): Configure a group of assets into a Project .. - [Project - Sales DWH](https://academy.pentaho.com/pentaho-data-integration/data-integration/projects/project-sales-dwh.md): PDI Lifecycle Management .. - [Data Sources](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources.md): Flat files, databases, storage, big data, and notebooks. - [Flat Files](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files.md): How Data Integration handles Flat files .. - [Text](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/text.md): Ingesting Text Files .. - [Text File Input](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/text/text-file-input.md): Ingest semi-structured text files into clean rows. - [Text File Output](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/text/text-file-output.md): Output text files .. - [Excel](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/excel.md): Time for some smoke & mirrors .. - [Excel Writer](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/excel/excel-writer.md): Working with Excel .. - [XML](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/xml.md): Data exchange & storage .. - [Read XML](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/xml/read-xml.md): XML data sources .. - [JSON](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/json.md): JavaScript Object Notation .. - [Read JSON](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/json/read-json.md): Read JSON objects. - [RSS Feed](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/flat-files/rss-feed.md): RSS reader .. - [Databases](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases.md): Steel Wheels .. - [CRUID](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid.md): CRUID database operations are a set of five basic functions that allow us to manipulate data in a persistent storage system, such as a relational database .. - [Database Connections](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/database-connections.md): Database connections .. - [Create DB table](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/create-db-table.md): Create tables .. - [Read DB table](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/read-db-table.md): Read shipped orders from a database table using Table Input. - [Update DB table](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/update-db-table.md): Update employees in the EMPLOYEES table using the Update step. - [Insert / Update DB](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/insert-update-db.md): Insert new employees and update existing employees using the Insert/Update step. - [Delete DB table](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/delete-db-table.md): Delete rows from STG\_SALES\_DATA using transformation-driven criteria. - [Data Cleansing](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/cruid/data-cleansing.md): Traditional data cleansing techiques .. - [SCDs](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/scds.md): Slowly Changing Dimensions .. - [SCDs](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/databases/scds/scds.md): Slowly Changing Dimensions .. - [Storage](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/storage.md) - [MinIO](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/storage/minio.md): Access S3 type Object Store - VFS (Virtual File System) .. - [MinIO](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/storage/minio/minio.md): Hands-on workshops using MinIO as an S3-compatible object store. - [SMB](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/storage/smb.md): File sharing .. - [SMB](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/storage/smb/smb.md): File sharing .. - [Hitachi Content Platform](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/storage/hitachi-content-platform.md): S3 Compatible Object Storage .. - [Big Data](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/big-data.md) - [Snowflake](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/big-data/snowflake.md) - [Apache Hadoop](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/big-data/apache-hadoop.md): Big Data stuff .. - [Apache Hadoop](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/big-data/apache-hadoop/apache-hadoop.md) - [Jupyter Notebook](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/jupyter-notebook.md): Jupyter notebooks are used for data science tasks such as exploratory data analysis (EDA), data cleaning and transformation, data visualization, statistical modeling, machine learning, and so on .. - [PDI to Jupyter Notebook](https://academy.pentaho.com/pentaho-data-integration/data-integration/data-sources/jupyter-notebook/pdi-to-jupyter-notebook.md) - [Enrich Data](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data.md): Enhance the quality of the data .. - [Merge](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/merge.md): When you merge rows and streams check the number of fields, data types and order. - [Merge Streams](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/merge/merge-streams.md) - [Merge Rows (diff)](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/merge/merge-rows-diff.md): Compare merging records .. - [Joins](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/joins.md): Pentaho Joins .. - [Cross Join](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/joins/cross-join.md): Good old Cartesian Join .. - [Merge Join](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/joins/merge-join.md): Standard SQL joins .. - [Database Join](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/joins/database-join.md): A self join or recursive join .. or is it ? - [XML Join](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/joins/xml-join.md): Join XML streams .. - [Lookups](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/lookups.md) - [Database Lookups](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/lookups/database-lookups.md) - [Scripting](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/scripting.md) - [Formula](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/scripting/formula.md) - [Modified JavaScript Value](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/scripting/modified-javascript-value.md) - [User Defined Java Class](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/scripting/user-defined-java-class.md) - [Executors](https://academy.pentaho.com/pentaho-data-integration/data-integration/enrich-data/scripting/executors.md) - [Enterprise Solution](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution.md): Scale out your Solution .. - [Jobs](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/jobs.md): A process flow that consists of one or more steps that execute tasks such as transformations, scripts, email notifications, file transfers, etc - [Job - Hello World](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/jobs/job-hello-world.md): What's a Pentaho Job .. - [Backward Chaining](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/jobs/backward-chaining.md): Rules when executing in multiple threads .. - [Parallel](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/jobs/parallel.md): Rule when executing in parallel .. - [Parameters & Variables](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/parameters-and-variables.md) - [Parameters](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/parameters-and-variables/parameters.md): Passing parameters .. - [Variables](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/parameters-and-variables/variables.md): Add flexibility / portability with variables .. - [Scalability](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/scalability.md): Static & Dynamic Carte Clusters - [Run Configurations](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/scalability/run-configurations.md): Execute Jobs / Transformations on specific nodes or in a Pentaho Cluster .. - [Partition](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/scalability/partition.md) - [Monitoring & Scheduling](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/monitoring-and-scheduling.md): Monitoring and Scheduling your Jobs & Transformations .. - [Monitoring & Scheduling](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/monitoring-and-scheduling/monitoring-and-scheduling.md): Schedule Pentaho Jobs / Transformations and Monitor results .. - [Logging](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/logging.md) - [Logging](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/logging/logging.md): Implement database logging .. - [Dockmaker](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/dockmaker.md): Pentaho cloud, hybrid-cloud containerized deployments .. - [BA & DI Servers](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/dockmaker/ba-and-di-servers.md): Build & Deploy BA & DI Pentaho Server Containers .. - [Metadata Injection](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/metadata-injection.md): Metadata Injection .. - [MDI](https://academy.pentaho.com/pentaho-data-integration/data-integration/enterprise-solution/metadata-injection/mdi.md): Overview of Metadata Injection .. - [Kettle Plugins](https://academy.pentaho.com/pentaho-data-integration/data-integration/ee-plugins.md): Enterprise Plugins .. - [Hierarchical Data Type](https://academy.pentaho.com/pentaho-data-integration/data-integration/ee-plugins/hierarchical-data-type.md): handling Hierarchical Data Types - JSON & YAML .. - [Kafka](https://academy.pentaho.com/pentaho-data-integration/data-integration/ee-plugins/kafka.md): Streaming platform .. - [AI-PDI Pipelines](https://academy.pentaho.com/pentaho-data-integration/use-cases/ai-pdi-pipelines.md): Key concepts behind interacting with a LLM - Chatbot .. - [GenAI](https://academy.pentaho.com/pentaho-data-integration/use-cases/ai-pdi-pipelines/genai.md): Generative artificial intelligence (GenAI) can create certain types of images, text, videos, and other media in response to prompts .. - [LLM Integration](https://academy.pentaho.com/pentaho-data-integration/use-cases/ai-pdi-pipelines/llm-integration.md): Integrate LLMs into your pipelines .. - [LangExtract](https://academy.pentaho.com/pentaho-data-integration/use-cases/ai-pdi-pipelines/langextract.md): Extract structured fields from unstructured text with LangExtract and load them with PDI. - [Agent-as-a-Service](https://academy.pentaho.com/pentaho-data-integration/use-cases/ai-pdi-pipelines/agent-as-a-service.md): Pattern reasoning across unstructured data .. - [Machine Learning](https://academy.pentaho.com/pentaho-data-integration/use-cases/machine-learning.md): Algorithms .. Credit Card Fraud - [Prerequisite tasks](https://academy.pentaho.com/pentaho-data-integration/use-cases/machine-learning/prerequiste-tasks.md): Configure Google Colab and Pentaho Data Integration (PDI) for machine learning. - [AutoML](https://academy.pentaho.com/pentaho-data-integration/use-cases/machine-learning/automl.md): Use PDI + H2O AutoML in Colab to prototype a credit-card fraud model. - [Credit Card](https://academy.pentaho.com/pentaho-data-integration/use-cases/machine-learning/credit-card.md): ML - Gradient Boosting (GBM) - [RESTful API](https://academy.pentaho.com/pentaho-data-integration/use-cases/restful-api.md): Using weather REST API .. - [Streaming Data](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data.md): Streaming data from IOT devices .. - [MQTT](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/mqtt.md): Publish / Subscribe - [EMQX](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/mqtt/mosquitto.md): Use Case: Predictive maintenance - [HiveMQ](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/mqtt/hivemq.md): Use Case: Manufacturing .. - [AMQP](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/amqp.md): Advanced Message Queuing Protocol (AMQP) is an open source published standard for asynchronous messaging by wire .. - [RabbitMQ](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/amqp/rabbitmq.md): Allows for messages to be queued, received, and delivered asynchronously .. - [Kafka](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/kafka.md) - [Use Cases](https://academy.pentaho.com/pentaho-data-integration/use-cases/streaming-data/kafka/use-cases.md) - [Jenkins](https://academy.pentaho.com/pentaho-data-integration/use-cases/jenkins.md): Used as an open-source scheduler .. - [Data Lineage](https://academy.pentaho.com/pentaho-data-integration/use-cases/data-lineage.md): Automate pipelines with Apache Airflow .. - [Data Sources](https://academy.pentaho.com/pentaho-data-integration/setup/data-sources.md) - [Databases](https://academy.pentaho.com/pentaho-data-integration/setup/data-sources/databases.md) - [Storage](https://academy.pentaho.com/pentaho-data-integration/setup/data-sources/storage.md): Setup Object Stores & SMB .. - [Big Data](https://academy.pentaho.com/pentaho-data-integration/setup/data-sources/big-data.md): Setup .. - [Apache Hadoop](https://academy.pentaho.com/pentaho-data-integration/setup/data-sources/big-data/apache-hadoop.md): Setup Apache Hadoop on Windows, Linux & Mac OS .. - [Jupyter Notebook](https://academy.pentaho.com/pentaho-data-integration/setup/data-sources/jupyter-notebook.md): Setup Jupyter Notebook .. - [Kettle EE plugins](https://academy.pentaho.com/pentaho-data-integration/setup/kettle-ee-plugins.md): Installation of EE plugins .. - [Use Cases](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases.md) - [LangExtract](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/langextract.md): Set up LangExtract with Ollama and expose it as a local API for PDI. - [Agent-as-a-Service](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/agent-as-a-service.md): Set up a local maintenance assessment agent with FastAPI and Ollama. - [Streaming](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/streaming.md) - [EMQX](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/streaming/mosquitto.md): Setup EMQX MQTT broker .. - [Hive](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/streaming/hive.md) - [RabbitMQ](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/streaming/rabbitmq.md) - [Machine Learning](https://academy.pentaho.com/pentaho-data-integration/setup/use-cases/machine-learning.md) - [Common Questions](https://academy.pentaho.com/pentaho-data-integration/faqs/common-questions.md) - [Pentaho Support](https://academy.pentaho.com/pentaho-data-integration/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/pentaho-data-integration/pentaho-support/pentaho-support/pentaho-support-utility.md) ## NEW - Semantic Model Editor - [Semantic Model Editor](https://academy.pentaho.com/semantic-model-editor/overview/semantic-model-editor.md) - [Getting Started](https://academy.pentaho.com/semantic-model-editor/semantic-model-editor/getting-started.md) - [Key Concepts & Terminology](https://academy.pentaho.com/semantic-model-editor/semantic-model-editor/key-concepts-and-terminology.md) - [Schemas](https://academy.pentaho.com/semantic-model-editor/semantic-model-editor/schemas.md) - [Steel Wheels](https://academy.pentaho.com/semantic-model-editor/semantic-model-editor/schemas/steel-wheels.md): Walk-through of existing model .. - [Classic Models](https://academy.pentaho.com/semantic-model-editor/semantic-model-editor/schemas/classic-models.md) ## Schema WorkBench - [Schema WorkBench](https://academy.pentaho.com/schema-workbench/overview/schema-workbench.md): Business Analytics .. - [Key Concepts & Terminology](https://academy.pentaho.com/schema-workbench/schema-workbench/key-concepts-and-terminology.md): Why OLAP .. - [Schemas](https://academy.pentaho.com/schema-workbench/schema-workbench/schemas.md): Mapping Start / Snowflake databases .. - [SteelWheels](https://academy.pentaho.com/schema-workbench/schema-workbench/schemas/steelwheels.md): Overview of a Mondian Schema v3 .. - [Basic Model](https://academy.pentaho.com/schema-workbench/schema-workbench/schemas/basic-model.md): Create a Classic Orders model .. - [Standard Model](https://academy.pentaho.com/schema-workbench/schema-workbench/schemas/standard-model.md): Apply your schema creation skills .. - [Extend Model](https://academy.pentaho.com/schema-workbench/schema-workbench/extend-model.md) - [Extended Model](https://academy.pentaho.com/schema-workbench/schema-workbench/extend-model/extended-model.md): Adding advanced model capabilities .. - [Calculations](https://academy.pentaho.com/schema-workbench/schema-workbench/extend-model/calculations.md): Measures .. - [MDX Query](https://academy.pentaho.com/schema-workbench/schema-workbench/mdx-query.md) - [MDX Query](https://academy.pentaho.com/schema-workbench/schema-workbench/mdx-query/mdx-query.md): MDX Query .. - [Named Sets](https://academy.pentaho.com/schema-workbench/schema-workbench/mdx-query/named-sets.md): Grouping members .. - [Data Security](https://academy.pentaho.com/schema-workbench/schema-workbench/data-security.md) - [Mondrian Security](https://academy.pentaho.com/schema-workbench/schema-workbench/data-security/mondrian-security.md): RBAC in Mondrian .. - [Localization](https://academy.pentaho.com/schema-workbench/schema-workbench/localization.md) - [FR Localization](https://academy.pentaho.com/schema-workbench/schema-workbench/localization/fr-localization.md): Localize your Schema .. - [MongoDB Reports](https://academy.pentaho.com/schema-workbench/use-cases/mongodb-reports.md): Create Analyzer & Interactive Reports from MongoDB .. - [Common Questions](https://academy.pentaho.com/schema-workbench/faqs/common-questions.md) - [Schema Workbench](https://academy.pentaho.com/schema-workbench/resources/schema-workbench.md): Mondrian Resources .. - [Pentaho Support](https://academy.pentaho.com/schema-workbench/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/schema-workbench/pentaho-support/pentaho-support/pentaho-support-utility.md) ## Metadata Editor - [Metadata Editor](https://academy.pentaho.com/metadata-editor/overview/metadata-editor.md): Business Analytics .. - [Getting Started](https://academy.pentaho.com/metadata-editor/metadata-editor/getting-started.md) - [Components](https://academy.pentaho.com/metadata-editor/metadata-editor/components.md): Interactive Reporting Models .. - [Domains & Models](https://academy.pentaho.com/metadata-editor/metadata-editor/domains-and-models.md): What is a Metadata Domain ..? - [SteelWheels](https://academy.pentaho.com/metadata-editor/metadata-editor/domains-and-models/steelwheels.md): Walk through of SteelWheels domain .. - [OrdersME](https://academy.pentaho.com/metadata-editor/metadata-editor/domains-and-models/ordersme.md): Create an Orders Domain .. - [Query Builder](https://academy.pentaho.com/metadata-editor/metadata-editor/domains-and-models/query-builder.md): Query the data .. - [Properties](https://academy.pentaho.com/metadata-editor/metadata-editor/properties.md): Extending metadata properties .. - [OrderStarCustomer](https://academy.pentaho.com/metadata-editor/metadata-editor/properties/orderstarcustomer.md): Manipulating Metadata Properties .. - [Concepts](https://academy.pentaho.com/metadata-editor/metadata-editor/concepts.md): Concepts are bundled metadata properties .. - [Concepts](https://academy.pentaho.com/metadata-editor/metadata-editor/concepts/concepts.md): Bundled Metadata Properties .. - [Security & Data Access](https://academy.pentaho.com/metadata-editor/metadata-editor/security-and-data-access.md) - [Security & Data Access](https://academy.pentaho.com/metadata-editor/metadata-editor/security-and-data-access/security-and-data-access.md): Restrict access to metadata objects .. - [MongoDB Reports](https://academy.pentaho.com/metadata-editor/use-cases/mongodb-reports.md): Create Analyzer & Interactive Reports from MongoDB .. - [Common Questions](https://academy.pentaho.com/metadata-editor/faqs/common-questions.md) - [Metadata Editor](https://academy.pentaho.com/metadata-editor/resources/metadata-editor.md) - [Pentaho Support](https://academy.pentaho.com/metadata-editor/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/metadata-editor/pentaho-support/pentaho-support/pentaho-support-utility.md) ## Data Source Wizard - [Data Source Wizard](https://academy.pentaho.com/data-source-wizard/overview/data-source-wizard.md): Business Analytics .. - [Data Source Wizard](https://academy.pentaho.com/data-source-wizard/data-modeling/data-source-wizard.md) - [Data Model](https://academy.pentaho.com/data-source-wizard/data-modeling/data-source-wizard/data-model.md): Creating a model from various Data Sources .. - [Common Questions](https://academy.pentaho.com/data-source-wizard/faqs/common-questions.md) - [Pentaho Support](https://academy.pentaho.com/data-source-wizard/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/data-source-wizard/pentaho-support/pentaho-support/pentaho-support-utility.md) ## Business Analytics - [Pentaho Business Analytics](https://academy.pentaho.com/pentaho-business-analytics/overview/readme.md): Business Analytics .. - [Getting Started](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/getting-started.md): Pentaho Business Analytics Pro Suite .. - [User Console](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/user-console.md): Gateway to reporting plugins & Pentaho Server services .. - [PUC](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/user-console/puc.md): Tour of User Console .. - [Interactive Reports](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/interactive-reports.md): Standard Corporate Reports .. - [Sales Territory](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/interactive-reports/sales-territory.md): Corporate Reports .. - [Orders - NA & EMEA](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/interactive-reports/orders-na-and-emea.md) - [Ships & Trains](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/interactive-reports/ships-and-trains.md): Another Interactive Report .. - [Analyzer Reports](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/analyzer-reports.md): Slice & Dice a MDX cube .. - [Sales Analysis](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/analyzer-reports/sales-analysis.md): Slice & Dice the data set .. - [EMEA Quantity](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/analyzer-reports/emea-quantity.md): Quantity sold in EMEA for 2004 .. - [Dashboard Designer](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/dashboard-designer.md): Templated Interactive, Analyzer & Report Designer Reports together with Queries & URLs .. - [Vendor Sales](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/dashboard-designer/vendor-sales.md): Report based dashboard .. - [Inventory](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/dashboard-designer/inventory.md): Create dashboard content .. - [Product Performance](https://academy.pentaho.com/pentaho-business-analytics/business-analytics/dashboard-designer/product-performance.md): Linking dashboard content .. - [MongoDB Reports](https://academy.pentaho.com/pentaho-business-analytics/use-cases/mongodb-reports.md): Create Analyzer & Interactive Reports from MongoDB .. - [Common Questions](https://academy.pentaho.com/pentaho-business-analytics/faqs/common-questions.md) - [Pentaho Support](https://academy.pentaho.com/pentaho-business-analytics/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. ## CTools - [CTools ..](https://academy.pentaho.com/pentaho-ctools/overview/ctools-...md): Pentaho CTools .. - [Getting Started](https://academy.pentaho.com/pentaho-ctools/c-tools/getting-started.md): Components, requirements and templated dashboard .. - [First Steps](https://academy.pentaho.com/pentaho-ctools/c-tools/getting-started/first-steps.md): Before you begin .. - [My First Dashboard](https://academy.pentaho.com/pentaho-ctools/c-tools/getting-started/my-first-dashboard.md): 15min dashboard .. - [Community Data Access](https://academy.pentaho.com/pentaho-ctools/c-tools/community-data-access.md): Access data sources .. - [Creating a CDA](https://academy.pentaho.com/pentaho-ctools/c-tools/community-data-access/creating-a-cda.md): Data Connection & Access in one file .. - [Parameters](https://academy.pentaho.com/pentaho-ctools/c-tools/community-data-access/creating-a-cda/parameters.md): It's all about being flexible .. - [CDA API](https://academy.pentaho.com/pentaho-ctools/c-tools/community-data-access/creating-a-cda/cda-api.md): CDA API Reference .. - [CDA Data Sources](https://academy.pentaho.com/pentaho-ctools/c-tools/community-data-access/creating-a-cda/cda-data-sources.md): Community Data Access .. - [Community Dashboard Framework](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-framework.md) - [CDF Dashboard](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-framework/cdf-dashboard.md) - [CDF Dashboards](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-framework/cdf-dashboards.md) - [Community Dashboard Editor](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-editor.md): Dashboards made easy .. - [UI Overview](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-editor/ui-overview.md): Visual approach to dashboard creation .. - [Carrier Dashboard](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-editor/ui-overview/carrier-dashboard.md): Wireless Carrier dashboard .. - [Components](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-editor/components.md): Link between data sources and layout .. - [Carrier Dashboard](https://academy.pentaho.com/pentaho-ctools/c-tools/community-dashboard-editor/components/carrier-dashboard.md): CTools components .. - [Community Graphics Generator](https://academy.pentaho.com/pentaho-ctools/c-tools/community-graphics-generator.md) - [Carrier Dashboard](https://academy.pentaho.com/pentaho-ctools/c-tools/community-graphics-generator/carrier-dashboard.md): Setting CGG Chart values with postFetch .. - [Retail Sales](https://academy.pentaho.com/pentaho-ctools/use-cases/retail-sales.md) - [Sales Analysis Dashboard](https://academy.pentaho.com/pentaho-ctools/use-cases/retail-sales/sales-analysis-dashboard.md) - [Common Questions](https://academy.pentaho.com/pentaho-ctools/faqs/common-questions.md) - [Pentaho Support](https://academy.pentaho.com/pentaho-ctools/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/pentaho-ctools/pentaho-support/pentaho-support/pentaho-support-utility.md) ## Data Catalog - [Pentaho Data Catalog ..](https://academy.pentaho.com/pentaho-data-catalog-en/overview/pentaho-data-catalog-...md): Why Pentaho Data Catalog .. - [Management](https://academy.pentaho.com/pentaho-data-catalog-en/snippet/management.md): Manage your Catalog implementation .. - [Data Identification Methods](https://academy.pentaho.com/pentaho-data-catalog-en/snippet/management/data-identification-methods.md): Data Dictionaries & Patterns .. - [Business Rules](https://academy.pentaho.com/pentaho-data-catalog-en/snippet/management/business-rules.md): Data Quality Rules - Identify non-compliant rows in your data .. - [Workers](https://academy.pentaho.com/pentaho-data-catalog-en/snippet/management/workers.md) - [Getting Started](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/getting-started.md): Walk-through of Pentaho Data Catalog .. - [Reference Data](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/getting-started/reference-data.md) - [Data Lineage](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/getting-started/data-lineage.md): Journey of data from origin to endpoint .. - [Overview](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/getting-started/overview.md): What are the benefits of using a data catalog ..? - [Adventure Works](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/adventure-works.md): Data Governance .. - [AW Organization](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization.md): Keycloak-PDC integration with business-aligned Communities .. - [PDC JWT Token](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/pdc-jwt-token.md): Understanding the WHO & WHAT .. - [AW Groups](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/aw-groups.md): Create Adventure Works Groups in Keycloak .. - [AW Roles & Attributes](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/aw-roles-and-attributes.md): Keycloak custom Roles & Attributes .. - [Map AW Roles to Groups](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/map-aw-roles-to-groups.md): Add Custom Roles to Groups .. - [Role Mappers](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/role-mappers.md): Map PDC default roles to AW Custom Roles .. - [AW Users](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/aw-users.md): Add Adventure Works users .. - [Communities](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/aw-organization/communities.md): Fine tune authorization to assets .. - [Data Discovery](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-discovery.md): Connect to a data source .. - [Connect AW Database](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-discovery/connect-aw-database.md): Connect to AW DW .. - [Other Data Sources](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-discovery/connect-aw-database/other-data-sources.md): Adding Data Sources .. - [Permissions & Scope](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-discovery/permissions-and-scope.md): Who has access to What .. - [Request Access](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-discovery/request-access.md) - [Glossaries, Terms & Tags](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/glossaries-terms-and-tags.md): In the beginning .. - [Compliance & Data Governance](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/glossaries-terms-and-tags/compliance-and-data-governance.md): Staying on the right side of regulatory compliance .. - [Sales Business](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/glossaries-terms-and-tags/sales-business.md) - [Data Identification](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-identification.md): Dictionaries & Data Patterns .. - [Personal Data Identifier](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-identification/personal-data-identifier.md): GDPR Compliance .. - [Data Processing](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-processing.md) - [Metadata Ingestion](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-processing/metadata-ingestion.md) - [Profiling](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-processing/profiling.md): Examining and analyzing data to ensure its quality, consistency, and integrity .. - [PII Detection](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-processing/pii-detection.md): PII for Korean & Japanese datasets .. - [Usage Statistics](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/data-processing/usage-statistics.md): Supports resource optimization, strengthens governance through usage audit trails, and enables impact analysis by showing which entities are affected by changes in data flow .. - [Canvas & Collections](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/canvas-and-collections.md) - [Business Rules](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules.md): Data Quality Rules .. - [Completeness Rule](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/completeness-rule.md) - [Accuracy Rules](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/accuracy-rules.md) - [Uniqueness Rules](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/uniqueness-rules.md) - [Consistency Rules](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/consistency-rules.md) - [Validity Rules](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/validity-rules.md) - [Timeliness and Conformity Rules](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/timeliness-and-conformity-rules.md) - [Rule Groups](https://academy.pentaho.com/pentaho-data-catalog-en/data-catalog/business-rules/rule-groups.md) - [Data Discovery](https://academy.pentaho.com/pentaho-data-catalog-en/projects/data-discovery.md): Adventure Works projects to help implement in PDC .. - [Dashboard](https://academy.pentaho.com/pentaho-data-catalog-en/projects/data-discovery/dashboard.md) - [Sensitivity Level & Trust Scores](https://academy.pentaho.com/pentaho-data-catalog-en/projects/data-discovery/sensitivity-level-and-trust-scores.md) - [Machine Learning](https://academy.pentaho.com/pentaho-data-catalog-en/projects/machine-learning.md) - [MLflow](https://academy.pentaho.com/pentaho-data-catalog-en/projects/machine-learning/mlflow.md): 30-minute quick start workshop .. - [Adventure Works](https://academy.pentaho.com/pentaho-data-catalog-en/setup/adventure-works.md): Data Catlog deployment configuration settings .. - [Data Discovery](https://academy.pentaho.com/pentaho-data-catalog-en/setup/data-discovery.md) - [AW Data Sources](https://academy.pentaho.com/pentaho-data-catalog-en/setup/aw-data-sources.md) - [MLflow](https://academy.pentaho.com/pentaho-data-catalog-en/setup/mlflow.md) - [APIs](https://academy.pentaho.com/pentaho-data-catalog-en/setup/apis.md) - [Components](https://academy.pentaho.com/pentaho-data-catalog-en/setup/components.md) - [Reverse Proxy Server](https://academy.pentaho.com/pentaho-data-catalog-en/setup/components/reverse-proxy-server.md): Traefik .. - [App Server](https://academy.pentaho.com/pentaho-data-catalog-en/setup/components/app-server.md): Front End React .. Back End JS .. - [Metadata Store](https://academy.pentaho.com/pentaho-data-catalog-en/setup/components/metadata-store.md): Exploring the Pentaho Data Catalog Metadata Store .. - [Worker Server](https://academy.pentaho.com/pentaho-data-catalog-en/setup/components/worker-server.md): What is a worker? - [Observability](https://academy.pentaho.com/pentaho-data-catalog-en/setup/components/observability.md) - [Common Questions](https://academy.pentaho.com/pentaho-data-catalog-en/faqs/common-questions.md) - [PDC Configuration Files](https://academy.pentaho.com/pentaho-data-catalog-en/reference/pdc-configuration-files.md): PDC Configuration reference .. - [Regulations & Compliance](https://academy.pentaho.com/pentaho-data-catalog-en/reference/regulations-and-compliance.md): Regulatory & Compliance ... - [Pentaho Support](https://academy.pentaho.com/pentaho-data-catalog-en/pentaho-support/pentaho-support.md): How to work with Pentaho Support and open effective tickets .. - [Pentaho Support Utility](https://academy.pentaho.com/pentaho-data-catalog-en/pentaho-support/pentaho-support/pentaho-support-utility.md) --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on a page URL with the `ask` query parameter: ``` GET https://academy.pentaho.com/pentaho-academy.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.