Skip to Main Content

APEX

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!

Oracle APEX 21.2 - REST Data Source Synchronization Disabled on Import

McRiversNov 6 2023

I created a REST Data Source in an application that consumes data from an external API source. I have set up a Syncronization to check for changes to the data and pull them into a local table in the Oracle database.

When I deployed this application from DEV to UAT, the synchronization was disabled in UAT, and it would not run the scheduled job until the DBA did a manual synchronization. I am assuming this enabled it. I have read that Automations are disabled on import by design, but have not been able to determine if RDS synchronizations are automations or something else.

  1. Are REST Data Source synchronizations scheduled jobs or automations?
  2. Where are these synchronization objects stored in the database?
  3. Is there an API to enable them, so I can include it in my deployment scripts to the DBA?

I am trying to get a better understanding of how to deploy REST Data Sources and there syncronization logic between environments being new to them.

This post has been answered by McRivers on Nov 6 2023
Jump to Answer
Comments
Post Details
Added on Nov 6 2023
1 comment
776 views