This is the second part of DB CRUD operation in Oracle Integration Cloud (OIC).

Use Case: Create a REST service which will select all the record from a table

Follow the article for the pre-requisite.

Let’s get started and implement the use case

  • Login in the Oracle Integration Cloud and navigate to the Integration tab
  • Click on Create button and select App Driven Orchestration template
  • Enter the Integration Name as DB_GetAll and click on Create button
  • Select Rest_Trigger_conn
  • Enter below information and click Next button
    • What do you want to call your endpoint: GetUsers
    • What is the endpoint’s relative resource URI?: /users
    • What action do you want to perform on the endpoint: GET
    • Configure this endpoint to receive the response: Select this checkbox
  • Select JSON Sample from the drop down and then click on <<<inline>>> link
  • Enter below json sample and click OK button
  • Just complete the wizard
  • Select Test_DB_Connection
  • Enter below details and click Next button
    • What do you want to call your endpoint: GetUserData
    • What operation do you want to perform?: Perform an Operation On a Table
    • Select the Select radio button
  • Select below information and click Import Tables button
    • Schema: HR
    • Table Type: TABLE
    • Table Name: Enter %USER% and click the Search button
    • Select USER_MASTER table from Available pane and move to the Selected pane
  • Click Next button
  • Click Done button
  • Drop a mapper just below the DB adapter
  • Map all the parameter from left to right
  • Configuration is completed. Just save the integration and Activate
This is the time to test the REST service. POSTMAN client will be used the test the service. Enter the REST service endpoint in the POSTMAN and add BASIC authentication.