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

​
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.