The Visual Builder Cloud Service Blog

Accessing DB objects through Oracle Integration Cloud for a Visual Builder App

Shay Shmeltzer
Director of Product Management - Oracle

[This is a guest post by Cosmin Manole from the Oracle Solution Hub Team]

Visual Builder can quickly access data originating from Business Objects and external data sources that can be consumed through REST service endpoints. But what if a simple database connection is available with no REST endpoints exposed? In past blog entries we covered accessing the database with Java code (using ADF BC), and using PL/SQL based ORDS is another option, one additional possible solution is to leverage Oracle Integration Cloud, which allows CRUD operations to be implemented through Basic Routing integrations leveraging built-in database connections and queries.

For this example we assume a connection to database is available and can be tested from OIC’s Integration service.

The two main parts for this solution are:

Exposing Data Through Integrations:

This step creates REST endpoints for database actions

In order for Integration Cloud to fulfill its role, a few actions are required:
  1. Create a database connection. This action is available from the Basic Routing configuration view, as well as from the Connections entry. In this example the connection is setup starting from the Integration configuration view. (part of the first video below)
  2. Create and configure the Basic Routing integrations required for each of the desired service actions (GET and PUT are showcased in the videos below (video 1 & 3) )
  3. The available REST services will be consumed by VBCS (depicted in video 2 & video 3 for GET and PUT respectively)

<video 1: create GET REST endpoint & required DBCS connection>

The REST endpoint can now be used by VBCS. First, a Service Connection is created:

<video 2: VBCS service connection – GET>

The following video shows the creation of a new REST endpoint for updating a list item on the database. The action is registered with VBCS as a new service connection

<video 3: create Integration update REST service & VBCS service connection PUT>

Similarly, a POST action is added to the VBCS service connections. *Integration setup not part of the video for this scenario.

<video 4: vbcs service connection POST>

Consuming the REST services with Visual Builder

Once the REST endpoints are available and tested they can be consumed by VBCS:

Creating lists and managing information is easy through service connections and the underlying implementation is transparent to the UI developer. Developers can quickly display data and associate update, insert, or delete actions to buttons found in list items.


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.