Bruin Academy
Guide
Oracle to DuckDB
Move data from Oracle XE into DuckDB using Bruin's oracle-duckdb template - includes Docker setup, data seeding, and a downstream SQL transformation.
What
Move data from Oracle XE into DuckDB using the oracle-duckdb template. You will run Oracle locally with Docker, seed sample e-commerce data, transfer it into DuckDB, and verify an aggregated customer report.
How
Set up and seed Oracle XE first, then initialize the Bruin template and configure Oracle and DuckDB connections. After that, bruin run . --config-file ./.bruin.yml transfers the three source tables and runs the downstream SQL transformation that creates sales_per_customer.
Before you start
- Bruin CLI installed
- Docker Desktop installed and running
- DuckDB CLI (optional, for querying results)
Guide overview
- 1Set Up Oracle with DockerLaunch Oracle XE in a Docker container, create a database user, and seed sample data.
- 2Initialize & ConfigureScaffold the oracle-duckdb template project and configure Oracle and DuckDB connections.
- 3Run Pipeline & VerifyExecute the pipeline to transfer Oracle data to DuckDB and verify the aggregated results.
Get help & contribute