[OIC] Trigger OIC REST Integration from Oracle Fusion BIP Report

on

 

In this post we will see how to trigger the OIC REST Integration from Oracle Fusion BIP Report.

 

Prerequisites:

  • Access to OIC Console to create integration. Make sure you have ServiceDeveloper or ServiceAdministrator access.
  • OIC REST Integration which can be invoked by using Basic Authentication. Make sure you have one generic OIC user which can be used to setup OIC Connection in Oracle Fusion BIP. For this generic user we need to have username and password available and it should not be SSO user, i.e. it should be of type non-federated account.
  • Access to Oracle Fusion BIP with Admin access to add new data sources, i.e. user must have BI Administrator Role

 

Steps:

  • Create an OIC REST Based Integration with Parameters and which returns XML type response.
  • Create a Data Source for OIC Integration instance in which you need to put hostname of OIC Intance and generic user credentials
  • Create an Oracle Fusion BIP Report with XML Feed type data set to trigger the integration
  • Track and validate the integration run

 

 OIC REST Based Integration

  • Login to the OIC Instance and navigate to Design → Integration
 
  • Click on Create button and select Application driven style
  • Enter the details of integration here we have put short identifier and then click on Create button


  • For this integration we will be using the below REST connection with TRIGGER role which we have already configured

 

  • Add this connection as Trigger point of the integration

 

 

  • Enter the name of Endpoint and optionally you can add description, then click Continue

  • Enter the endpoint URI and select the method as GET and select to add Parameters and Response. Once done click Continue button
Note: This approach only worked for GET and not for POST

  •  For this demonstration we will be adding two parameters FirstName and LastName. After adding click Continue
 
  •  Create a sample file with any name like Response.xml with below content:
<Response>
    <Status>Success</Status>
    <Message>Integration Completed Successfully</Message>
</Response>
 
 
 
  • Select the response payload format as XML Sample and upload the Response.xml file and click continue

  •  Review the details and then click on Finish & then save the integration
 

  •  Edit the Mapper and map the response:


  • Validate and save the integration
  • Add the Business Identifiers and then activate the integration with Debug mode
 

  • From Run screen, open the Endpoint Metadata and copy the URI of the integration and make sure you test it from Postman
 
 
 
So, now integration is ready to be used in Oracle Fusion BIP Report, so next step is to create Data Source for Integration instance. This is one time step which we need to perform.

 
 
Data Source for OIC Integration instance
  •  Login to Oracle Fusion BIP Analytics by accessing the below URL:
https://<FusionHostName>.fa.us2.oraclecloud.com/analytics
  •  Click on your profile on top right and then click Administration
  • On Administration page click on Manage Publisher
  • Then click on HTTP Connection
  • Click on Add Data Source
  • Add the details for your instance. Use OIC Username & Password for generic user. Enter the server as OIC Instance Hostname till .com without any / at the end


 
 
Create BIP Report to call OIC Integration
 
  •  Create new Data Model and add Data Set of type HTTP (XML Feed)
 
  •  Enter the Name of Data Set, select the Data Source as what we have created and enter URL Suffix of the integration that we created without any / in the beginning as well as in the end
 ic/api/integration/v1/flows/rest/TEST_INT/1.0/start 
 
  • Add the Parameters. Names of the parameters should match to Integration Parameters. Click on OK button.
  • Add the Parameters to the Data Model with any name
  • Now, edit the Data Set and then Map the Data Model Parameters to OIC Integration Parameters
  •  Save the BIP Report and then go to Data Tab and enter the parameters and click on View Button. Integration will be triggered and you can see the response.
  •  You can also check the response by clicking on Export button:
  •  So, later you can create BIP Report using this data model
 
 So, this is how we can call OIC Integrations of REST type from Oracle Fusion BIP Reports.

 

Comments

Post a Comment