What you should know: I am currently working for Nordcloud as Cloud Advisor, but any posts on this blog reflect my own views and opinions only.

When investigating more Azure-OCI topics, i came across the case of using Oracle APEX applications running on an Autonomous Database. Wouldn’t it be nice to have some low-code app built with APEX that integrates nicely with your Azure AD for authentication? Actually it is pretty easy to do so, i will show you the simple steps in a short video.

The only drawback i see here is that the setup includes mostly manual tasks. I’d really love to see a smart way to automate and parametrize the deployment of APEX apps… Well, the steps i show you will work, that is the most important point for now.

Create new APEX application
APEX application overview
Open demo app in new Browser
Done. On to the next step.
previous arrow
next arrow
 
Open Azure Portal
Go to App registration in Azure AD
Cope APEX base URL
Enter Redirect URL
Add Application ID URI
Set Application ID URI
Generate URI
Done. On to the next step.
previous arrow
next arrow
 
Go to Enterprise Applications
Go to Users and Groups
Select Add User
Pick Users to add
Done. On to the next step.
previous arrow
next arrow
 
Go to Shared Components
Go to Web Credentials
Create New
Get Client ID from Azure AD
Create Client Secret in Azure AD
Get Client Secret
Enter Client ID and Client Secret
Done. On to the next step.
previous arrow
next arrow
 
Go to Shared Components
Select Authentication Schemes
Create new Authentication Scheme
Just go next.
Select Social Sign-In
Open Endpoints from App registration
Copy OpenID Metadata document URL to clipboard
Enter URL and attributes
Authentication scheme created
Open application URL in new browser
Enter username
Enter password
Application
Done.
previous arrow
next arrow
 

OK, that should be it. Now you got you integration running.


4 Comments

Albert · Januar 8, 2021 at 21:45

I found this blog as I’ve seen that this is more simpler than the other I’ve seen. I’m trying to make the first webservices call on our workspace but I’m getting an error : ORA-29273: HTTP request failed. I made sure that rest and token URL is correct as I tested it out using the postman. Is there any configuration that I have to do prior to your this? Thank you!

    Max Jahn · Januar 11, 2021 at 13:02

    Hi,

    the post is a few months old, so some things might have changed. I’ll take a look at this and see if I can replicate this. One important thing to keep in mind is that my demo was using an Autonomous Database on OCI, not on-prem.

Mark · März 4, 2021 at 21:03

Hallo Max, vielen Dank für Dein Video. Du hast wirklich sehr gut erklärt, wie man Apex mit Azure verbindet. Ich habe Deine Vorgehensweise ausprobiert und es funktioniert wirklich sehr gut in der Cloud. Allerdings funktioniert es nicht auf der Oracle Datenbank, die ich als Testversion installiert habe (-> /ords). Ich habe dafür die App, die bereits in der Cloud funktionierte, aus Apex identisch kopiert (inkl. deren ursprüngliche ID und die korrespondierenden Azure Verknüpfungen). Leider funktioniert es nicht mehr ausserhalb der Cloud. Weisst Du vielleicht woran es liegen kann? Muss ich irgendwelche Einstellungen ändern? Vielen herzlichen Dank für Deine Rückantwort.

Hello Max, thank you very much for your video. You did a really good job explaining how to connect Apex to Azure. I’ve tried your approach and it works really well in the cloud. However, it does not work on the Oracle database that I installed as a test version (-> /ords). For this I copied the app, which already worked in the cloud, identically from Apex (including its original ID and the corresponding Azure links). Unfortunately, it no longer works outside of the cloud. Do you know what it could be? Do I have to change any settings? Thank you very much for your reply.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.

Diese Website verwendet Akismet, um Spam zu reduzieren. Erfahre mehr darüber, wie deine Kommentardaten verarbeitet werden.