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 Oracle Database Client must be installed on the machine from which HVR connects to Oracle. If HVR connects to Oracle through an HVR Agent (agent) installed on the Oracle server, the client is pre-installed. However, if HVR connects to Oracle directly from the hub or through the agent installed on a separate server, the client must be installed on that machine.
When connecting HVR to Oracle directly from the hub (without the HVR agent), we strongly recommend installing the Full Oracle Client rather than the Instant Client. The detailed instructions for downloading and installing the Oracle Database Client for your specific operating system can be found in 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.