Skip to Main Content

ORDS, SODA & JSON in the Database

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!

APEX, ORDS and non-Oracle database

User_3LDBZMar 20 2022 — edited Mar 20 2022

Hi,
In Oracle APEX there are features to create REST data sources.
If the database is non-Oracle (JDBC connection), the straight forward solution expose the database over a REST API and the use the "Simple HTTP" rest data source type.
But when you create a report over a "Simple HTTP" data source APEX only executes GET-requests and enables list functionality in APEX. APEX does not generate create/update/delete forms.
A much stronger alternative would be to use the "ORDS" data source type. But this is not possible as ORDS requires a Oracle database.
But what if I could implement and API with the sub-set of REST methods which would enable me to use the ORDS data source type in APEX over a non-Oracle database ?
Do you know any implementation ? Or is there a specification of the ORDS REST API which would enable me to build this API ?

Comments
Post Details
Added on Mar 20 2022
2 comments
716 views