Oracle Database Cloud Service provides two offerings, Database as a Service and Database Schema Service. In this example, I will be creating sample business process using Oracle Process Cloud Service (PCS) and expose RESTful webservices on the Oracle Database Cloud Service (Oracle Database Cloud - Database Schema Service). PCS will invoke DBaaS over REST API exposed at DBaaS and provides response to the PCS.
In the following step I have quickly created RESTful service in the DBaaS. In the step 2 I will create PCS application which calls DBaaS REST API to retrieve the results from the database.
Step 1 - Creating RESTful service using DBaaS.
Create INTG_TTK table with following details in the Oracle Database Cloud - Database Schema Service.
For the created table, RESTful web service can be created using DBaaS and exposed as REST service.
In the DBaaS , navigate to SQL Workshop RESTful services and provide following inputs to expose as service.
Once the RESTful services are created, it's ready to consume and appear as follows in the DBaaS RESTful services.
Step 2 - Creating PCS Application and Invoke DBaaS REST service.
Create PCS application with message type as start and it can be synchronous service. Configure the service task in the application with the above create RESTful service. Here's how it look alike:
The service task will be configured with REST service and it has to be configured in the PCS connectors.configuration of REST connector in the PCS look alike below.
Here, In the service task i have configured the REST connector. REST connector can be configured as: Read the complete article here.
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.