Triggering OIC Integration/Webservices from BI Publisher Reports
Introduction
This document outlines the steps to configure and invoke an Oracle Integration Cloud (OIC) integration from Oracle BI Publisher (BIP) using an HTTP connection. This enables seamless data exchange and automation between BIP reports and OIC workflows.
Step 1: Creating Data Sources in BIP
HTTP Data Source:
Navigate to Administration >Manage Publisher> Data Sources > HTTP Connection.
Enter:
Enter the following details:
Name OIC_Integration_Conn
Server <Your_OIC_Server_Domain>
Port 443 (default for HTTP)
Username <Your_OIC_Username>
Password <Your_OIC_Password>
Specify the applicable roles and apply them accordingly
Step 2: Create Data Model with HTTP Data Set
Navigation: Go to Catalog > New > Data Model
Steps:
- Click New Data Set > Select HTTP.
Fill in the following:
Name Call_OIC_Integration
Data Source OIC_Connection
URL Suffix c/api/integration/v1/flows/rest/<IntegrationName>/<Version>/startintegration
Method GET
Request Format XML
Name Call_OIC_Integration
Data Source OIC_Connection
URL Suffix c/api/integration/v1/flows/rest/<IntegrationName>/<Version>/startintegration
Method GET
Request Format XML
Click View Data to test the integration call.
Save the Data Model.
Step 3: Click “Create Report”
- In the Data Model editor, click the Create Report button at the top.
- This opens the Report Creation Wizard.
- Select data model
- Choose Layout
- Drag and Drop data
- View and Save Report
