Access Data in an Existing Oracle Database Using ORDS

You can use Oracle REST Data Services (ORDS) to expose database objects through REST APIs, and then map the ORDS endpoints as REST services in your Visual Builder application.

To accelerate and simplify the process of adding ORDS endpoints, leverage the OpenAPI specification provided by ORDS as described in this blog. You can also use fixed credentials to connect to ORDS.

Note:

If your database is in a private subnet or behind a firewall, your ORDS endpoint must have a public IP address to be accessible by Visual Builder.

If you want to filter, sort, and paginate the data returned by the ORDS backend, you'll need to provide a transform function as part of your service connection definition in Visual Builder. Find sample code for the transform function in the Visual Builder cookbook's ORDS integration recipe.