Oracle Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Oracle for replication.
Supported Platforms
- Oracle versions compatible with HVR can be found on our Platform Support Matrix page (6.1.0, 6.1.5).
Supported Capabilities
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
HVR log-based capture is not supported on Oracle 18c Express Edition because the supplemental logging settings cannot be modified in this edition.