Home
Feed

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

Discussion on "Access ATP APEX using a Reverse Proxy" | Hashnode

Feed/

Discussion

Matt Paine

Having fun developing solutions with APEX and ERP Cloud

Sep 27, 2022

Access ATP APEX using a Reverse Proxy

Introduction In a previous blog post, we restricted access to your Always Free Oracle ATP database to trusted IP addresses. That’s good to start with, but to make your APEX apps available to the public internet or allow access from a different set o...

jmjcloudblog.hashnode.dev5 min read

#orclapex #oracle-cloud #oracle

Responses2

Markdown supported · ⌘↵ to post

Vaughan Brown

Oracle APEX Developer.

Oct 20, 2022

Hi Matt, thanks for the cool article - I'll be trying it out within the next few days.

I can see you mentioned that SSO wouldn't work with this. Can you confirm if other API calls would work - such as an API request to PayPal?

Hi - other outbound calls should have no issues; the problem for Social Sign On and SSO is that ORDS passes a callback URL to SSO which doesn't match the reverse proxy - bit of a specialized exception. There's no mechanism to change this that I'm aware of. Otherwise, all should be well.

Matt Paine

Having fun developing solutions with APEX and ERP Cloud

Nov 1, 2022

Jon Dixon

APEX, ORDS & the Oracle Database

Sep 29, 2022

Excellent. Just confirming that you don’t need to install customer managed ORDS, just point to the ATP URL?

Matt Paine

Having fun developing solutions with APEX and ERP Cloud

Oct 10, 2022

Hey Jon - you don't have to use customer-managed ORDS in this use-case, however, one of the things I'm finding is that the approach above breaks Social Sign-on. So if that's a requirement, you're into customer-managed ORDS territory. See the "Epilogue" above.

Jon Dixon

APEX, ORDS & the Oracle Database

Oct 10, 2022

Thanks for clarifying.