Amazon RDS Oracle

Last updated on Sep 03, 2024

Amazon RDS for Oracle is a fully managed commercial database that makes it easy to set up, operate, and scale Oracle deployments in the cloud. Amazon RDS frees you up to focus on innovation and application development by managing time-consuming database administration tasks including provisioning, backups, software patching, monitoring, and hardware scaling.

Refer to Oracle on Amazon RDS for the supported Oracle database versions.

Limitations

  • Hevo does not support the flashback method to track incremental updates.

  • Redo Log does not support user-defined data types. Therefore, fields with such data types are not captured in the log and are lost.


See Also


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Apr-29-2024 NA Updated section, Specify Amazon RDS Oracle Connection Settings to include more detailed steps.
Mar-05-2024 2.21 Added the Data Replication section.
Jan-22-2024 2.19.2 Updated section, Object and Query Mode Settings to add a note about the enhanced object selection flow available for log-based Pipelines.
Jan-10-2024 2.19 Updated section, Specify Amazon RDS Oracle Connection Settings as per latest Hevo functionality.
Nov-03-2023 NA Added section, Object and Query Mode Settings.
Apr-21-2023 NA Updated section, Specify Amazon RDS Oracle Connection Settings to add a note to inform users that all loaded Events are billable for Custom SQL mode-based Pipelines.
Mar-09-2023 2.09 Updated section, Specify Amazon RDS Oracle Connection Settings to mention about SEE MORE in the Select an Ingestion Mode section.
Dec-19-2022 2.04 Updated section, Specify Amazon RDS Oracle Connection Settings to add information that you must specify all fields to create a Pipeline.
Dec-07-2022 2.03 Updated section, Specify Oracle Connection Settings to mention about including skipped objects post-Pipeline creation.
Dec-07-2022 2.03 Updated section, Specify Oracle Connection Settings to mention about the connectivity checker.
Feb-07-2022 1.81 Updated section, Whitelist Hevo’s IP Address to remove details about Outbound rules as they are not required.
Dec-06-2021 1.77 Added a See Also link to the Pipeline failure due to Redo Log expiry page.
Nov-22-2021 NA Updated the Limitations section.
Mar-09-2021 1.58 Added section Retrieve the Hostname, Service ID, and Port Number.

Tell us what went wrong