Oracle Database integration

Oracle Database data, in your warehouse.

A built-in ingestr connector: add credentials, pick tables, schedule it.

name: raw.hr_employees
type: ingestr
parameters:
  source_connection: oracle_database
  source_table: 'HR.EMPLOYEES'
  destination: snowflake
  incremental_strategy: merge

$ bruin run assets/raw/oracle_database.asset.yml

extract · Oracle Database HR.EMPLOYEESincremental
load · snowflake raw.HR_EMPLOYEESmerged
checks · not_null, unique

Loaded and checked. Downstream models can run.

How it connects

Connected in three steps.

Oracle Database is a multi-model database management system known for enterprise features.

01
Add a Oracle Database connection with its credentials.
02
Pick the tables to load and how: replace, append or merge.
03
Bruin runs it on your schedule and checks every load.

Connection parameters

username: Oracle user
password: User password
host: Database server
port: Listener port (default 1521)
service_name: Service name or SID

Every way Oracle Database works with Bruin

SourceBuilt-in ingestr sourceDocs →
DestinationBuilt-in ingestr destinationDocs →
Query engineRuns SQL and Python assetsDocs →

Tables

3 tables, ready to load.

HR.EMPLOYEES
SALES.ORDERS
INVENTORY.PRODUCTS

Step-by-step

Pick a destination.

Oracle Database → Snowflake

Read the guide

Oracle Database → Google BigQuery

Read the guide

Oracle Database → Databricks

Read the guide

Oracle Database → Amazon Redshift

Read the guide

Oracle Database → PostgreSQL

Read the guide

Oracle Database → ClickHouse

Read the guide

Oracle Database → DuckDB

Read the guide

Oracle Database → MotherDuck

Read the guide

The platform

Part of the Bruin platform.

Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.

See the full platform

Sources

DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scraping

Move

Data Ingestion

Model & govern

SQL & Python Data Quality Data Governance

Self-Healing Pipelines

Use

AI Data Analyst AI Dashboards Data Apps Scheduled Agents Reverse ETL

Bruin Cloud runs every step

Databases

More tools, same category.

All 71 Databases tools

PostgreSQL Built in MySQL Built in Microsoft SQL Server Built in MongoDB Built in Amazon DynamoDB Built in Elasticsearch Built in SQLite Built in Azure SQL Database Built in

Frequently asked

Questions about Oracle Database.

Does Bruin have a built-in Oracle Database integration?

Yes. Built-in ingestr source. Built-in ingestr destination. Runs SQL and Python assets.

Which Oracle Database tables can Bruin load?

HR.EMPLOYEES, SALES.ORDERS, INVENTORY.PRODUCTS.

Where can Oracle Database data go?

Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.

How fresh is the data?

As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.

Do we need Bruin Cloud?

No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.