PaaS Partner Community

  • May 14, 2017

Process Cloud Service Communicating to Database as a Service (DbaaS) by Santosh Shetgar

Juergen Kress
PaaS Partner Adoption



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.

SOA & BPM Partner Community

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.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

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.