Skip to main content

​
Overview

Oracle Database is an enterprise-class database management system that provides comprehensive and advanced data management features. Datazone provides native integration with Oracle to read data directly from your databases.

​
Connection Parameters

Set on the source when you create it. Names match the API and CLI payload.
​
string
required
Name — a unique identifier for your Oracle source.
​
string
required
Host — hostname or IP address of your Oracle database server.
​
string
required
Port — port the listener runs on. Defaults to 1521 when omitted.
​
string
required
Service Name — the Oracle service name for your database.
​
string
required
Schema Name — schema that extracts resolve table names within.
​
string
required
User — username with read permission on the tables you intend to extract.
​
string
required
Password — password for the specified user. Stored encrypted.

​
Extract Parameters

Set per extract, in source_parameters. See Shared Extract Parameters for mode, replication_key, and schema_mapping.
​
string
required
Table Name — the table or view to extract, resolved within the source’s schema_name.
​
integer
default:"1000000"
Rows fetched and written per batch.
​
string
default:"*"
Columns to read, as a comma-separated list.
​
string
Row filter pushed down to Oracle, written without the WHERE keyword — for example status = 'ACTIVE'.

​
Required Permissions

The Oracle user account needs the following permissions:
  • SELECT - For reading data from tables and views
  • SELECT ANY TABLE - For reading from tables in other schemas
  • SELECT_CATALOG_ROLE - For accessing data dictionary views
  • CREATE SESSION - For connecting to the database

​
Limitations

Be aware of the following limitations when working with Oracle sources:
  • Some Oracle-specific data types may be converted to standard formats
  • LONG and LONG RAW data types have size limitations
  • Individual query size and timeout limits apply
  • The Oracle instance and Datazone should ideally be in the same network for optimal performance
  • Binary data types require special handling

​
Next Steps

After configuring your Oracle source:
  1. Create extracts to specify which tables to ingest
  2. Configure scheduling for recurring extracts
  3. Integrate the source into your data pipelines
For more information about working with extracts and pipelines, refer to their respective documentation sections.