​
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

ParameterRequiredDescription
NameYesA unique identifier for your Oracle source
HostYesThe hostname or IP address of your Oracle database server
PortYesThe port number on which Oracle is running (default: 1521)
Service NameYesThe Oracle service name for your database
Schema NameNoOptional schema name to restrict access to specific schema
UserYesUsername with appropriate permissions to access the database
PasswordYesPassword for the specified user

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