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
The requirement to install the Oracle Database Client depends on how the HVR Hub connects to the Oracle database. The connection can be either direct or through an HVR Agent.
Connecting directly: The HVR Hub connects directly to the Oracle database without using an HVR Agent. You must install the full Oracle Database Client on the HVR Hub machine.
Connecting via HVR Agent on the Oracle Database server: 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, as it is included with the database installation package. This allows the HVR Agent installed on the same machine to connect to the Oracle Database without a separate client installation.
Connecting via HVR Agent on a separate machine: The HVR Hub connects to the Oracle database through an HVR Agent installed on a separate machine (not on the database server). You must install the full Oracle Database Client on the machine hosting the HVR Agent.
In the above cases where the Oracle Database Client installation is required, you must install the full Oracle Database Client instead of the Oracle Instant Client. 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, which are crucial for HVR operations.
For detailed instructions on downloading and installing the Oracle Database Client, refer to the Oracle documentation.
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.