X

Shay Shmeltzer's Oracle Development Tools Tips

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

Shay Shmeltzer
Director of Product Management - Oracle

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 ( 4 )
  • Subramanian Sunday, August 16, 2020
    Hi Shay,

    I'm facing a self-signed certificate issue while connecting ORDS only through Visual Builder Studio. Can you mention where to upload the certificate in the VBS tool?

    FYI, If I use Visual Builder instance then there is no issue with API due to the certificate has uploaded on the VB instance side.

    "detail": "{"type":"abcs://proxy_auth_problem/ssl/cert/path_builder/self","title":"SSL Certificate Path Building Error","detail":"The remote server used a self signed certificate so was rejected as untrusted:\n\n[\n[\n Version: V3\n Subject: CN=xxx-xxx.xxx.com, OU=Domain Control Validated\n Signature Algorithm: SHA256withRSA, OID = 1.2.840.113549.1.1.11\n\n Key: Sun RSA public key, 2048 bits\n modulus:
  • Shay Shmeltzer Sunday, August 16, 2020
    Subramanian, This type of questions are better answered on our forum: https://cloudcustomerconnect.oracle.com/pages/9c5db79a45
    In general you need to import the SSL to the VB instance you use to run your VB app:
    https://docs.oracle.com/en/cloud/paas/app-builder-cloud/abcag/administrative-tasks1.html#GUID-6E910F06-A5AA-4464-8605-A716211528F5
    If this doesn't work then post more info in a thread on our forum and we'll try and help.
  • Suvendu Das Wednesday, September 2, 2020
    Hi,
    This blog is really helpful to start with the development of UI using VBCS by consuming ORDS services. Still there are some doubts, while we are building bolt-ons using VBCS for UI. Ultimately the transactions will hit Oracle Cloud ERP using OICS. Requesting you to let us know your email address so that we can specifically dicsuss our problems.
    Thanks,
    Suvendu
  • Shay Shmeltzer Sunday, September 20, 2020
    Suvendu,
    For further questions use our community forum:
    https://cloudcustomerconnect.oracle.com/resources/e610f4723c/summary
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.