UltiDataLake

Create Pipeline

Oracle → BigQuery data lake

Configuration

Pipeline Name

Source Database Type

Source (Oracle)

Destination (BigQuery)

Data Handling Strategy (for multiple schemas)

Override (Default)

Replace all data for the tenant/unit when running any schema

Merge

Keep data from other schemas, only replace data from the same schema

Multi-Tenant Pipeline

This pipeline is tenant-agnostic. When you run it, you'll select which tenant to run it for. The tenant_id will be automatically injected into all data.

Bronze (Raw)

Silver (Cleaned)

Gold (Business)

Stages

Start with Bronze

Add Bronze stages to extract tables from your source database