Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

ORACLE

Enterprise-grade relational database. Industry standard for mission-critical financial, ERP, and healthcare systems.

PREREQUISITES

Driver: oracledb — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `oracle`
host	string	yes	—	Oracle server hostname
port	integer	no	1521	Listener port
user	string	yes	—	Oracle username
password	string	yes	—	Oracle password
service	string	yes	—	Oracle service name
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: oracle_dev
  outputs:
    oracle_dev:
      type: oracle
      host: oracle.internal.com
      port: 1521
      user: ANALYTICS
      password: "{{ env_var('ORA_PASSWORD') }}"
      service: ORCL

SOURCES.YML EXAMPLE

sources:
  - name: erp_system
    connection: oracle_dev
    schema: FINANCE
    tables:
      - name: GL_JOURNAL
      - name: AP_PAYMENTS

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

⚠DROP uses PL/SQL blocks with CASCADE CONSTRAINTS PURGE