> For the complete documentation index, see [llms.txt](https://academy.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://academy.pentaho.com/administrator-path-sandbox/administrator/level-3-certified.md).

# Level 3 — Certified

20 lessons across 4 modules, ending in a capstone and a proctored certification exam — SSO, transport/data security, big data security and awareness of enterprise security patterns.

{% hint style="warning" icon="eye" %}
**SANDBOX — draft page.** No hands-on lab content yet. Sourced from docs.pentaho.com's "Secure the Pentaho system" section, plus the existing SA\_1000 security course. Lesson times are estimates — REPLACE-ME throughout.

**Reconciliation note (remove before publishing):** SA\_1000 turned out to be Solution Architect-level material — hands-on labs writing custom Spring Security extensions (custom `AuthenticationProvider`, `UserDetailsService`, `DelegatingRole`, `SQLGenerator`, Access Voter classes) for multi-tenant architectures, not admin configuration. Rather than teach the coding here, Module 4 gives Administrators conceptual awareness of these patterns. The hands-on labs moved to the Solution Architect path, rebuilt for Pentaho 11.
{% endhint %}

Where Level 2 covers Pentaho's two out-of-the-box directory integrations, Level 3 is the rest of the security surface — single sign-on, transport security, encryption, securing Pentaho's own access into other systems, and recognising when a security requirement needs custom development rather than configuration.

{% columns %}
{% column %}

<p align="center"><i class="fa-file-lines" style="color:green;">:file-lines:</i><br><strong>20 lessons</strong><br><em>across 4 modules</em></p>
{% endcolumn %}

{% column %}

<p align="center"><i class="fa-flask" style="color:orange;">:flask:</i><br><strong>10 workshops</strong><br><em>hands-on labs</em></p>
{% endcolumn %}

{% column %}

<p align="center"><i class="fa-clock" style="color:cyan;">:clock:</i><br><strong>~4h 45m</strong><br><em>estimated</em></p>
{% endcolumn %}
{% endcolumns %}

{% hint style="success" icon="cloud-arrow-up" %}
Every workshop is hands-on and runs on Pentaho's hosting platform. The Lab Guide is embedded in each lab and loads automatically when you open it — nothing to install.
{% endhint %}

***

<h3 align="center">Before you start</h3>

{% columns %}
{% column %}
{% hint style="success" icon="circle-check" %}
**What you'll need**

Level 2 course accreditation, or equivalent experience with directory-based authentication. This level assumes you're comfortable editing Pentaho's Spring Security configuration files directly.
{% endhint %}
{% endcolumn %}

{% column %}
{% hint style="info" icon="tag" %}
**Built against**

Pentaho Enterprise Edition **11.0.0.0-237**, the build every course on the Academy runs. The hosted labs run this exact release, so every screen, menu and dialog matches the guide step for step.
{% endhint %}
{% endcolumn %}
{% endcolumns %}

***

{% hint style="info" icon="trophy" %}

#### What you'll build

The level ends in a capstone project: harden a Pentaho Server for enterprise deployment — SSO authentication, encrypted credentials and transport, and secure access to a Hadoop cluster — before you sit the proctored Level 3 certification exam.
{% endhint %}

```mermaid
%%{init: {"theme":"base","themeVariables":{"fontFamily":"Arial, Helvetica, sans-serif","fontSize":"13px","lineColor":"#64748b","clusterBkg":"#fafaf9","clusterBorder":"#d6d3d1","edgeLabelBackground":"#ffffff"},"flowchart":{"curve":"basis","nodeSpacing":28,"rankSpacing":44,"padding":22,"wrappingWidth":600,"htmlLabels":true}}}%%
flowchart TB
  classDef server fill:#ede9fe,stroke:#6d28d9,color:#3b0764,text-align:left,rx:6,ry:6
  classDef store fill:#dcfce7,stroke:#15803d,color:#14532d,text-align:left,rx:6,ry:6
  classDef browser fill:#fef3c7,stroke:#b45309,color:#78350f,text-align:left,rx:6,ry:6
  classDef support fill:#f1f5f9,stroke:#475569,color:#0f172a,text-align:left,rx:6,ry:6
  classDef off fill:#f5f5f4,stroke:#a8a29e,color:#78716c,text-align:left,rx:6,ry:6
  U["<b>A user in the browser</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>on a domain-joined machine, or not&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::browser
  OIDC["<b>OIDC / OAuth 2.0</b>&nbsp;&nbsp;&nbsp;&nbsp;<br/>Keycloak, Entra ID, Okta&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::support
  IWA["<b>IWA</b>&nbsp;&nbsp;&nbsp;<br/>Kerberos/SPNEGO silent login&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::support
  CAS["<b>CAS</b>&nbsp;&nbsp;&nbsp;<br/>Central Authentication Service, legacy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::off
  PS["<b>Pentaho Server</b>&nbsp;&nbsp;&nbsp;&nbsp;<br/>single sign-on: Spring Security&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>chains the providers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>SSL, AES-encrypted credentials,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>JDBC security, SSRF prevention&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::server
  HD[("<b>Hadoop cluster</b>&nbsp;&nbsp;&nbsp;&nbsp;<br/>accessed on the user's behalf:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Kerberos or secure impersonation,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Knox for CDP&nbsp;&nbsp;&nbsp;")]:::store
  PAT["<b>Patterns that need a developer</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>recognise them, then hand over:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>pre-authenticated gateways,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>custom providers, multi-tenant&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>isolation, access voters&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::off
  U --> OIDC
  U --> IWA
  U --> CAS
  OIDC --> PS
  IWA --> PS
  CAS --> PS
  PS --> HD
  PS -.-> PAT
```

<p align="center"><em>The Level 3 security surface: single sign-on in front of the server, the server's own security, and its access into Hadoop.</em></p>

***

<h3 align="center">Skills you'll gain</h3>

<table data-view="cards"><thead><tr><th></th><th></th></tr></thead><tbody><tr><td><i class="fa-right-to-bracket" style="color:blue;">:right-to-bracket:</i> <strong>Single sign-on</strong></td><td>OIDC/OAuth 2.0 with Keycloak, Entra ID or Okta · Kerberos-based IWA for silent domain login · CAS where it is still in place</td></tr><tr><td><i class="fa-lock" style="color:blue;">:lock:</i> <strong>Transport &#x26; data security</strong></td><td>SSL · AES-encrypted credentials · JDBC-backed security · SSRF prevention · how Spring Security chains providers</td></tr><tr><td><i class="fa-database" style="color:blue;">:database:</i> <strong>Big data security</strong></td><td>Kerberos vs. secure impersonation · Kerberos with MongoDB &#x26; Spark · Knox &#x26; CDP access</td></tr><tr><td><i class="fa-eye" style="color:blue;">:eye:</i> <strong>Enterprise security awareness</strong></td><td>Pre-authenticated gateways · custom auth providers · multi-tenant isolation · custom access voters — recognising when to bring in a developer</td></tr></tbody></table>

***

<h3 align="center">Course outline</h3>

<p align="center"><i class="fa-file-lines" style="color:green;">:file-lines:</i> reading · <i class="fa-flask" style="color:orange;">:flask:</i> hands-on workshop</p>

{% hint style="info" icon="circle-info" %}
Full lessons unlock once you're enrolled — this is the outline only. All times are estimates — REPLACE-ME.
{% endhint %}

<table data-search="false"><thead><tr><th width="306">Module</th><th width="114" align="center">Reading</th><th width="139" align="center">Workshops</th><th width="100" align="right">Time</th></tr></thead><tbody><tr><td>Single Sign-On</td><td align="center">1</td><td align="center">3</td><td align="right">~1h 10m</td></tr><tr><td>Transport &#x26; Data Security</td><td align="center">2</td><td align="center">4</td><td align="right">~1h 20m</td></tr><tr><td>Big Data Security</td><td align="center">2</td><td align="center">3</td><td align="right">~1h 25m</td></tr><tr><td>Enterprise Security Patterns (Awareness)</td><td align="center">5</td><td align="center">—</td><td align="right">~50m</td></tr><tr><td>Capstone Project</td><td align="center">—</td><td align="center">1 project</td><td align="right">—</td></tr><tr><td><strong>Total</strong></td><td align="center"><strong>10</strong></td><td align="center"><strong>10</strong></td><td align="right"><strong>~4h 45m</strong></td></tr></tbody></table>

{% stepper %}
{% step %}

### <i class="fa-right-to-bracket" style="color:blue;">:right-to-bracket:</i> Single Sign-On

`1 reading · 3 workshops · ~1h 10m`

Integrate Pentaho with the single sign-on your organisation already runs — OpenID Connect first, Kerberos-based silent login for domain-joined users, and CAS where it is still in place. The [Integrating Authentication Mechanisms](https://academy.pentaho.com/administrator-path-sandbox/speciality-courses/integrating-authentication-mechanisms.md) Speciality covers this ground in more depth.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="78"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Configure OIDC / OAuth 2.0 — Keycloak, Microsoft Entra ID, Okta and similar IdPs</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Configure IWA (Integrated Windows Authentication) — Kerberos/SPNEGO silent login</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Configure CAS (Central Authentication Service) — legacy</td><td>~20m</td></tr></tbody></table>

</details>

{% hint style="warning" icon="circle-question" %}
**REPLACE-ME** — CAS 7 is still certified in the Pentaho 11 components reference, but the documented CAS setup uses client libraries from 2010, and OIDC / OAuth 2.0 is the sign-on Pentaho 11 ships out of the box. Confirm with support whether CAS keeps a workshop here or moves to a legacy note.
{% endhint %}
{% endstep %}

{% step %}

### <i class="fa-lock" style="color:blue;">:lock:</i> Transport & Data Security

`2 readings · 4 workshops · ~1h 20m`

Certificates, encrypted credentials, database-backed security, and hardening against SSRF-class attacks.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="78"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Enable SSL Security</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>AES Security — Encrypting Stored Credentials</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>JDBC Security — Database-Backed Authentication</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Server-Side Request Forgery (SSRF) Prevention</td><td>~10m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>How Pentaho Chains Authentication Providers (Spring Security)</td><td>~10m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-database" style="color:blue;">:database:</i> Big Data Security

`2 readings · 3 workshops · ~1h 25m`

Secure Pentaho's own access into a Hadoop cluster on a user's behalf.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="78"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview</td><td>~10m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Kerberos Authentication vs. Secure Impersonation — two models compared</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Set Up Kerberos for Pentaho — prerequisites and supported components</td><td>~25m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Kerberos with MongoDB &#x26; Spark Submit</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Knox &#x26; CDP Security — accessing Cloudera Data Platform clusters</td><td>~20m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-eye" style="color:blue;">:eye:</i> Enterprise Security Patterns (Awareness)

`5 readings · ~50m`

Conceptual only — no hands-on labs. Implementing any of these requires custom development, typically Solution Architect-level work. As an Administrator, the goal is to recognise the pattern and know when to bring in that expertise.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="78"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview</td><td>~10m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Pre-Authenticated SSO Gateways — SiteMinder, WebGate, WebSeal-style header trust</td><td>~10m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Custom Authentication &#x26; Role Providers</td><td>~10m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Multi-Tenant Data Isolation Patterns — sharded sources, DSP, metadata security, SQL generators</td><td>~10m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Custom Role Delegation &#x26; Access Voters</td><td>~10m</td></tr></tbody></table>

</details>

{% hint style="warning" icon="circle-question" %}
**REPLACE-ME** — confirm this module's framing (awareness-only, no code) is right for Level 3 — Certified.
{% endhint %}
{% endstep %}

{% step %}

### <i class="fa-trophy" style="color:red;">:trophy:</i> Capstone Project

`1 project`

Bring it all together: harden a Pentaho Server to enterprise standard — SSO, encrypted credentials and transport, and secure big data access — before you sit the proctored Level 3 certification exam.

<details>

<summary>See the project brief</summary>

Your client is preparing for a security audit ahead of a major compliance certification. Configure enterprise SSO for platform login, encrypt stored credentials and enforce SSL across the server, and secure the platform's access into their Hadoop cluster with Kerberos or secure impersonation. Document which of the awareness-level patterns from Module 4 apply to their environment and would need custom development to implement.

</details>
{% endstep %}
{% endstepper %}

***

{% hint style="warning" icon="award" %}
**Certification**

Unlike Levels 1 and 2, Level 3 doesn't offer a self-paced course exam — it leads directly to **Certification**, a separate credential that organisations look for when engaging Pentaho consultants: all the mandatory courses plus a proctored exam.
{% endhint %}

{% hint style="info" icon="user-shield" %}
**What a proctored exam involves**

The certification exam is delivered through Kryterion's Webassessor platform, the same service used for many vendor certifications. You book a slot in advance and sit the exam either online from your own computer or at a Kryterion-authorised test centre. Online, you install Kryterion's secure browser beforehand, which locks the screen to the exam and blocks copying, other windows and virtual machines; you show government photo ID that matches the name on your Webassessor account; you pan your webcam around the room; and a proctor, backed by AI monitoring, watches the whole session. No notes, second screens or help from anyone else. The open-book course exams inside the Lab Guide are not proctored. REPLACE-ME — confirm exam length, pass mark, fee and the retake policy with the certification team.
{% endhint %}

***

<p align="center"><a href="https://academy.pentaho.com/administrator-path-sandbox/administrator.md" class="button secondary" data-icon="arrow-left">Back to the Administrator path</a></p>


---

# 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 that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://academy.pentaho.com/administrator-path-sandbox/administrator/level-3-certified.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
