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.
The whole project is one command. Run it, point your coding agent at the Bruin MCP, and it can configure and run everything itself.
$ bruin init oracle-duckdbThree ways to go from here:
- Self-service it. Let the agent configure and run the whole thing, and ask it questions as you go.
- Follow this tutorial. Slower, and it explains why each setting matters - the part an agent will not guess for you.
- Hand the tutorial to the agent. Point it at this page and have it work through the steps with you.
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