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.

previous arrow
next arrow
Slider
previous arrow
next arrow
Slider
previous arrow
next arrow
Slider
previous arrow
next arrow
Slider
previous arrow
next arrow
Slider

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.