In this Blog , I will Outline the Steps to Create Short BIP Reports which are created to fetch lesser volumes of data.
Use Case : Create a OIC Integration to Accept the Parameters and Invoke the BIP Report and Read the response and send it back as a REST Response.
Connections Required :
1) REST Trigger Connection
2)SaaS BIP Connection
High Level Steps :
1) Rest Trigger
2) Invoke BI
3) Write the Response to Stage
4) Read the Response from Stage
5) Map Read Stage Response to rest Response.
6) Activate & Run
Configure rest Trigger End Point.
Define The Parameters
Configure response Message
Configure RunReport Service
Select Operation As RunReport
Map the Rest request to BIP Invoke
Now Configure the Stage File Operation to write the BIP Response to OIC Stage Area
Add the below Opaque Element As file
<?xml version = '1.0' encoding = 'UTF-8'?>
<schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/"
xmlns="http://www.w3.org/2001/XMLSchema" >
<element name="opaqueElement" type="base64Binary" />
</schema>
Now Configure read File Operation to read the File Written to the OIC Stage.
Create a Csv Schema File with the respective Structure and configure as below.
Now Map the read File Stage Response to the Rest Trigger Response .
your integration will look like below.
Configure the Business Identifiers and and Activite the integration.
Integration Activated
Now you can Invoke this from tools like Postman , Additionally from OIC we can test this as shown below.
Pass the Defined Parameters And Hit test.
Hope This Helps !
Happy learning.
Comments