Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connecting Oracle Golden Gate Cloud Instance to Oracle Fusion Cloud(ERP/HCM) DATABASE

AnkitR GuptaDec 28 2021 — edited Dec 30 2021

Summary: Data Replication from Oracle Fusion Cloud(ERP/HCM) DATABASE to Oracle Autonomous Data Warehouse
Content (required):
How can we leverage Oracle Cloud Golden Gate to replicate data from Oracle Fusion Cloud(ERP/HCM) DATABASE to Oracle Autonomous Data Warehouse.
Is there a possibility to connect Oracle Cloud Golden Gate instance to Oracle Fusion Cloud(ERP/HCM) DATABASE.? If Yes, need to understand the process/steps to connect to it.
Also, is there a possibility to connect SQL DEVELOPER to Oracle Fusion Cloud(ERP/HCM) DATABASE. If Yes, need to know the steps to connect to it.
Version (include the version you are using, if applicable):
Oracle Cloud Golden Gate
Oracle Fusion Cloud (ERP/HCM)
Oracle Autonomous Data Warehouse
Code Snippet (add any code snippets that support your topic, if applicable):

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Dec 28 2021
5 comments
813 views