You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Integration scenario - OIC3

edited 9:24AM in Integration 3 comments

Hi Team,

We need your assistance in below scenario.

High-Level Process Flow

Extract data from external systems (PostgreSQL, SQL Server, etc.).
Load the extracted data into a DBCS staging table.
Perform validations within DBCS or via OIC.
Call Oracle Fusion Cloud APIs from OIC to perform the required actions in Fusion.
Update the DBCS tables with the results/status returned from Fusion.
Finally, update the status back in the external systems.

As this pattern will be frequently used in multiple scenarios, we want to avoid any performance bottlenecks. From your experience, you might have seen these kind of scenarios. Can you please kindly take some time and give us some idea.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!