Oracle Requirements

This section describes the requirements, access privileges, and other features of Fivetran HVR when using Oracle for replication.

Supported Platforms

Learn about the Oracle versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

Discover what HVR offers for Oracle on our Capabilities for Oracle page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Data Management

Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of supported Oracle data types and their mapping, see Data Type Mapping for Oracle.
Understand the character encodings HVR supports for Oracle on the Supported Character Encodings page.

Fivetran provides additional solutions for replicating data from Oracle. For more information, see section Oracle in Databases.

Oracle client library version 21 is supported since version 6.1.0/19.

Oracle Database Client

HVR requires the full Oracle Database Client to be installed on the machine from which it connects to the Oracle database, except when HVR is installed on the Oracle database server machine. For detailed instructions on downloading and installing the Oracle Database Client, refer to Oracle’s documentation for Linux (also see OS Requirements) and Windows.

The requirement to install the Oracle Database Client depends on how the HVR Hub connects to the Oracle database.

Connects directly without HVR Agent:
- When the HVR Hub installed on the Oracle database server connects directly to the Oracle database, you don’t need to install the Oracle Database Client, assuming the full Oracle Database Client was pre-installed with Oracle.
- When the HVR Hub installed on a separate machine (not the Oracle database server) connects directly to the Oracle database, you must install the full Oracle Database Client on the machine hosting the HVR Hub.
Connects via HVR Agent:
- When the HVR Hub connects to the Oracle database through an HVR Agent installed on the Oracle database server, you don’t need to install the Oracle Database Client, assuming the full Oracle Database Client was pre-installed with Oracle.
- When the HVR Hub connects to the Oracle database through an HVR Agent installed on a separate machine (not the Oracle database server), you must install the full Oracle Database Client on the machine hosting the HVR Agent.

When installing the client, ensure that you install only the full Oracle Database Client, as the Instant Client is insufficient for HVR operations. The full Oracle Database Client includes all necessary libraries and tools for advanced features such as replication and monitoring, whereas the Oracle Instant Client is lightweight and may lack the critical libraries required for these features.

Supported Editions

HVR supports the following Oracle editions:

Enterprise edition
Standard edition