Learn Odara ETL by building pipelines.
A guided route from your first CSV to a scheduled, documented, production-shaped pipeline, with the files included and a certificate at the end. Short videos and walkthroughs for one feature at a time. Live cohorts for teams.
World 1
First Run
Install Odara and ship a pipeline in the first ten minutes.
- Install and first launch
- Tour the canvas
- Your first pipeline: CSV to console
- Filter rows and write a CSV
World 2
Files & Formats
Every shape data arrives in — and the one node that reads them all.
- Delimiters and encoding
- Excel: sheets, skipped rows and headers
- XML: row elements and attributes
- Magic File
- Write any format with Magic File
World 3
Transform Core
SQL and Python — where the work actually happens.
- Casting and types
- Two inputs: joins
- Three sources and an aggregate
- Window functions
- Python transform with pandas
- Variables in paths
World 4
Databases
A free managed Postgres, read and write, insert and upsert.
- A free Postgres and your first load
- Read with SQL: let the database do the work
- Insert, Truncate, Merge: writing twice
- Apply a delta with Merge
- What changes in the other databases
World 5
Control Flow
Order, loops and what happens when a node fails.
- Run After: wait for the other branches
- A whole folder: File List and Iterate
- Loop over data: one file per country
- When a round fails — and Sleep
- Mini-project: process and archive an inbox
World 6
AI Assistant
Describe the pipeline in a sentence — then read what it built.
- One sentence to a SQL pipeline
- One sentence to a pandas pipeline
- Refine it, then verify it
World 7
Monitor & Schedule
Pipelines that run without you watching.
- Monitor: every run, in one place
- Schedule: run it without you
- Email me when it breaks
- Diagnose a broken pipeline
World 8
Documentation & Sharing
Turn the project into docs other people can read.
- Generate the project docs
- Export a print-ready PDF
- Publish with access control
Optional branch
Cloud & APIs
Optional branch — data that lives behind an HTTP call.
- REST Source
- REST Target
- S3: list, download, upload
- Azure Blob and Google Drive
- FTP and SFTP
Optional branch
API & Maestro
Optional branch — everything the UI does, over REST.
- A pipeline as JSON
- Ask the AI over the API
- Headless run with streaming logs
- Schema inference endpoint
- Orchestrate with Maestro
Optional branch
Admin & Governance
Optional branch — running Odara for a team.
- Users and roles
- Connections and secrets hygiene
- Backup and restore
Final
The Odara Gauntlet
No step-by-step. A brief, a dataset, and an acceptance checklist.
- The capstone