OIC - Export an Integration Using REST API | Rest API for Oracle Integration

Use Case: Here, we will see how to export an integration using Oracle provided REST APIs. We will export the integration and write to a FTP location.

Export Rest API:

Verb: GET

URI: /ic/api/integration/v1/integrations/{id}/archive

We can get all the Rest APIs in docs.oracle.com site under integrations section.

https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/index.html

Steps(High Level):

• Create 3 connections - Rest trigger , Rest OIC self connection and FTP connection.
• Create an App driven orchestration and configure Rest trigger
• Take REST OIC connection and configure Rest api call for Export. Choose response as binary and type as application/octet-stream.
• Call FTP adapter , configure and map the export stream response to FTP location.

Steps with screenshots:

Create Rest OIC connection to call Export.

Create FTP connection 

Create Rest Trigger connection.

Create an app driven orchestration integration.

Configure  Rest Trigger

Request: Identifier and Version

Response: Status

Drag and drop Rest OIC connection and configure Export.

Map the Identifier and Version to Id

Id = Identifier%7CVersion

Call FTP connection and configure write operation with no Schema.

Map the Export Stream response to FTP write file reference.

Added the activities in a scope.

Save and add the tracking and activate

Test

We can see .iar file exported successfully.

To import an OIC integration , follow my blog:

https://soalicious.blogspot.com/2022/06/oic-import-oic-integration-using-rest.html

OIC - limitation of using Staging area

Staging area:

Staging area is a temporary storage which is used to store file while integration is in execution. All the files being created during the integration run are flushed when the OIC integration completes(Success/Error) it's execution. Stage activity is used to access the staging area.

Limitation:

There is no limit while writing to Staging area but while reading only 10 MB size of messages can be read. 

Solution to limitation:

To read file which has size more than 10 MB, we need to use Read File in Segments. The way around is - use this Read file in Segments action to read file serially, it reads in chunks of 200 and by-passes the 10MB limit.

OIC - Schedule BI Publisher Report through OIC | Oracle Integration Cloud | Schdule report Service

Here, we will see how to call a schedule BI publisher report service( with BI bursring to FTP).

When to use Run Report operation:

• In Laymen term, use Run report operation if report output size is less than 10MB. 
• Run report operation will provide the report output in the webservice response.

When to use Schedule Report operation:

• Use "Schedule Report" operation when report output is > 10MB. 
• Schedule report will generate the report output in FTP, UCM, Email etc. Which is known as BI report bursting.

High level steps:

1. Create a Schedule service Soap connection
2. Take a Schedule orchestration integration and call Schedulw service operation and map all the required patameters 
3. Take a while loop and call getScheduledReportStatus operation to get the BI run status
4. You should have a BI report with Bursting data model option, here we are bursting the report to FTP delivery.

Implementation steps:

Create Schedule service SOAP connection

https://soalicious.blogspot.com/2022/05/oic-create-schedule-service-soap.html 

Integration flow:

Create a Scheduled Orchestration Integration

Provide a name and package

Select the created Soap connection for schedule report service.

Configure the Schedule service operation.

Now open the mapper and the map the required parameters name and its values.

Below Columns mappings are required to invoke Schedule BI report operation.

I have provided the following details:

attributeTemplate : "pdf"

parameterNameValues

name: "p_destination"

Values item: " FTP full path"

reportAbsolutePath: "/Custom/Integrations/Poc/XXSupplierREP1.xdo"

sizeOfDataChunkDownload: "-1"

scheduleBurstingOption: "true"

userJobDesc: ns2:getFlowId()

userJobName: ns2:getFlowId()

userId: ERP Service account user

password: ERP Service account pwd

Mappings:

Next, we will assign counter and loop till we get the GetScheduledReportstatus and then update the counter.

Add tracking

Activate

Test and see the outcome.

File generated in the ftp directory

To create a BI Bursting report and data model, follow my blog:

https://soalicious.blogspot.com/2022/03/oic-erp-bi-bursting-steps.html

Note:

You can also use below ScheduleReport service but you can only call the schedule service, there is not "getScheduledReportStatus" operation available.

https://<ERP domain name>/xmlpserver/services/ScheduleReportWSSService?WSDL