[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:
This step creates REST endpoints for database actionsIn order for Integration Cloud to fulfill its role, a few actions are required:
<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>
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.