Data Ingestion
Oracle
Oracle is a powerful enterprise-grade relational database management system.
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
| Parameter | Required | Description |
|---|---|---|
| Name | Yes | A unique identifier for your Oracle source |
| Host | Yes | The hostname or IP address of your Oracle database server |
| Port | Yes | The port number on which Oracle is running (default: 1521) |
| Service Name | Yes | The Oracle service name for your database |
| Schema Name | No | Optional schema name to restrict access to specific schema |
| User | Yes | Username with appropriate permissions to access the database |
| Password | Yes | Password for the specified user |
Required Permissions
The Oracle user account needs the following permissions:
SELECT- For reading data from tables and viewsSELECT ANY TABLE- For reading from tables in other schemasSELECT_CATALOG_ROLE- For accessing data dictionary viewsCREATE 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:
- Create extracts to specify which tables to ingest
- Configure scheduling for recurring extracts
- Integrate the source into your data pipelines
For more information about working with extracts and pipelines, refer to their respective documentation sections.