Calling OIC Integrations from Fusion ESS Jobs

There has been numerous asks on different forums to see if OIC integration can be called from Fusion ESS Jobs. I had similar requirement and thought to check if its possible. Though there is nothing out of the box but still its possible to achieve this.

Let’s see how.

Step1: Create an OIC Integration.

We need to create simple integration which is exposed as REST GET API. Thus we need to create connection to the OIC Instance.

Connection needed for the integration can be created in 2 ways.

Method 1 — Create REST Connection of type Trigger and set Security policy to “Basic Authentication” and Access type as “Public Gateway”

Method 2 — Create REST connection of type Trigger and Invoke and Set Security Policy to “Basic Authentication” and Access type as “Public Gateway” and enter the URL and the username and password for OIC.

Create simple integration by following steps below

a. Drop connection created above as Trigger

b. Give Endpoint name,URI name and the verb as shown below

Note: This approach only worked for GET and not for POST.

c. Define parameters

d. As we chose to send response as part of this GET call, add the response structure as xml and upload the sample xml file as shown below

Note- This is just a sample XML. The fields that you want to send in response can vary based on your project needs.

Integration in canvas looks like this

Map response value to the response node in the mapper.

e. Activate your integration and get the URL. We will need URL for integration to configure in BIP datamodel in later step.

Step 2- Create BIP datamodel to trigger this integration.

a. Login to BIP Catalog from Fusion using Reports and Analytics and navigate to Administration

Administration -> Manage Publisher -> HTTP Connection in Data Sources

b. Add new data source as shown below

• Give any data source name
• Server Protocol = https
• Server = OIC Instance servername excluding https.
• OIC Username and password.

c. Once data source of type is created you can register the data model. Create new datamodel of type HTTP (XML Feed) as shown below

• Give any name to data source.
• Data source is populated from the drop down since we created the datasource.
• URL Suffix — This you can activated integration.

ic/api/integration/v1/flows/rest/<IntegrationIdentifier>/1.0/getERP

Note — In this URL before ic there is no “/” , similarly after getERP there is no “/”

Ensure this URL is accurate.

You can add parameters as per your defined parameters in OIC.

Note: Parameter name in OIC must match with parameter name in the datamodel.

d. Run the datamodel and you can see values returned in the XML format.

Step 3 — Creating ESS Job to run the report created in Step2.

Details about calling report from ESS job is not explained as part of this blog.

In this way we can use ESS jobs to trigger OIC integration with the help of BIP reports.