Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Using ODI with REST API and OAUTH 2.0

Hrvoje BilićFeb 26 2024 — edited Feb 27 2024

Hi to all,

Help needed. We want to integrate ODI with some REST API services, with the services using OAUTH 2.0 authorization. By my understanding of the security mechanism, ODI should initially (in first command) send all the required parameters for authorization (client ID, client secret, Auth URL and Access Token URL), after which (once received) the token should be used in the second command in the request itself, by specifying the exact request.

This all sounds pretty understandable when talking about it, but in implementation I need some advice.

I've found the following documentation from Oracle, but I don't really entirely understand if this specified below really encompasses the OAUTH flow:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=142088200255782&id=2472878.1&_afrWindowMode=0&_adf.ctrl-state=135p9txrbk_4

Also, I did browse the forum a bit and ran into this topic:
https://forums.oracle.com/ords/apexds/post/passing-token-for-rest-api-call-from-odi-4177 which has some pretty valuable information from @christyxo and @dung-dinh-oracle .

What I still don't fully understand is how to specify the initial call towards the authorization server. Should this be done within ODI UI as suggested above by christyxo or somehoy else?

Thanks for your help!

Comments
Post Details
Added on Feb 26 2024
0 comments
102 views