Oracle Requirementslink
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Oracle for replication.
For information about compatibility and supported versions of Oracle with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Oracle, see Capabilities for Oracle.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by HVR on Oracle, see the 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 Clientlink
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. Detailed instructions for installing the Oracle Database Client based on your operating system can be found in the Oracle documentation.
Supported Editionslink
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.