X

The Visual Builder Cloud Service Blog

Leverage ORDS with Visual Builder to Access Oracle DB - an OpenAPI Update

Shay Shmeltzer
Director of Product Management - Oracle
This is a syndicated post, view the original post here

A while back I posted a blog/video showing how to access Oracle ATP DB through ORDS from Visual Builder. One update that happened since then on both the ORDS side and the Visual Builder part is support of OpenAPI/Swagger standard. This accelerates and simplifies adding ORDS based REST services to a VB app and creating apps leveraging them. 

ORDS is a simple solution for anyone looking to build Visual Builder based apps on top of existing tables in an Oracle DB. ORDS provides a very simple way to expose a set of REST services on top of tables (and other DB objects). Once the services are created you can add them to Visual Builder and consume the data they expose.

While in the previous blog I showed how to add specific endpoints, with the support for OpenAPI on both sides, you can use the "Define by Specification" approach to create many endpoints in one simple action in VB (and have the correct mappings to the specific actions and data types). 

To get to the ORDS OpenAPI meta-data, add open-api-catalog to the URL for your object so the URL will be something like:

https://servername/ords/schema/open-api-catalog/tablename/

Check out the demo below to see the end to end flow:

One more thing to remember, ORDS uses a specific format of REST requests to provides capabilities such as filtering, sorting, and paginating through data. If you want Visual Builder to leverage these features, you'll need to add a transform option that specify how to do this. You can find an example of such code for ORDS in the previous blog.

Join the discussion

Comments ( 2 )
  • Matteo Thursday, April 1, 2021
    Hi! Thanks for your article, I have a question. Is it possible to have a single service have all the DB tables? Because in the example i need one service for each table, which can become hard to manage when having many tables

    Thanks!
  • Shay Shmeltzer Tuesday, April 6, 2021
    Matteo,
    That's probably a question to the ORDS team to see if they do provide an open-api that lists all the endpoints exposed from a specific DB rather than a table specific one.
    Their forum is here: https://community.oracle.com/tech/developers/categories/oracle_rest_data_services
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.