Configuring OIC Notifications by Niall Commiskey

image

Simple scenario here – customer wants OIC to send context sensitive emails in case of error. So what do I actually mean by this? I have ERP and HCM related errors, each of these will result in the sending of a notification. However, the ERP related email should have its own sender email address, email formatting etc. The same applies to HCM – Here is a simple example of such emails  – Note the 2 email addresses niallC@hcm.com and niallC@erp.com. These have been specified as valid email addresses in OIC – Settings – Integrations – Notifications – Now to the integration that will send the email. This will be part of your error handling framework. For this simple example I use the following request payload – Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Surfacing OIC Design Time audit logs in OCI Logging Analytics by by Niall Commiskey

imageThe use case here is customer needs to see what is happening in respect of integration activation and deactivation.

The basis is the OIC Design Time Audit Log – visible in OIC Monitoring –

Note the action column values, activate, deactivate etc. Currently OIC does not push this log to OCI Logging, so the quick workaround here is to leverage the OIC REST api to retrieve the design time audit data –

OIC REST API docs available here

I try this out in Postman, to get the response payload –

Next step is to create a REST connection in OIC to OIC itself.

This I then invoke from a Scheduled Orchestration -  Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Merry Christmas!

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Advance your Career! How to become a certified Oracle Cloud Platform expert? Free training and certification! Watch the on-demand Webcast

Free training & certification until end of February 2022

Want to make more money doing the job you already have? Before you ask for a salary raise, you might want to become a cloud expert first. Getting certified in your field can often mean the difference between continuing your job or get a promotion including a pay raise. Boost your career and become a certified Oracle Integration or Conversational AI expert!
Attendees will be updated on the available Oracle Cloud Platform trainings, certifications and the free promotion until December 31st 2021. Including the resources and support the PaaS and Developer partner communities provide you. Can’t access the free training & certification? Oracle OPN team will provide instant support check and fix your account during the webcast! Boost your career with an Oracle Cloud Platform certification!

Free training and certification until December 31st 2021
Gain knowledge. Grow opportunity. Distinguish yourself

Watch the on-demand Webcast here

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Integrate SaaS hands-on Bootcamp Asia January 4th, 6th, 11th 2022

image

Oracle Product Management is pleased to invite Oracle Partners to attend a 3-days hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud. This Invite-Only hands-on workshop will be delivered at No-Fee to Partners. It will consist of presentations, demos, and hands-on labs.

Oracle Integration Cloud (OIC) offers Integration, Process Automation and Visual design capabilities that help business analysts and IT specialists to automate end to end business processes across departments. Oracle Integration Cloud offers a simple recipe to be successful in this application integration and process automation journey: Build, Integrate and Engage.

Schedule:

· Integrate SaaS Bootcamp Asia January 4th, 6th, 11th 2022

· Integrate SaaS Bootcamp US & Canada January 18th, 20th 25th 2022

· On-demand training

· For additional location please visit our website here (community membership required).

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Oracle Integration Update December 2021 Watch the on-demand Webcast.

cover12Product Management Webinar: Attend to get the latest updates and innovations on Oracle Integration November 2021 release. Our Oracle Integration Product Manager Team will present new features, product roadmaps, discuss upcoming innovations and provide guidelines to help you adopt these quickly within your organization. Topics include:

    • Welcome & announcements

    • November release update Oracle Integration

    • HCM Integration Best Practices from the A-Team

    • Questions & Answers

      Speakers:

      Mani Krishnan, Consulting Solution Architect, Oracle HQ

      Niall Commiskey, Senior Director Product Management, Oracle HQ

      Jürgen Kress,  Director Product Management, Oracle HQ

      Watch the on-demand webcast here.

      For regular updates please subscribe to the newsletter here.

      PaaS Partner Community

      For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

      clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

      Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

      Process Excel files with OIC + Oracle Functions by Stan Tanev

      imageIn this blog post I will explore how we can extend the native capabilities of Oracle Integration (OIC) with Oracle Functions to process Excel files.

      Although OIC can handle a number of file formats natively, .xlsx or .xls files need a bit of extra love.

      The inspiration for this blog comes of the back of several customer enquiries into this subject.

      The simple solution for most customers is to convert the Excel file formats to CSV and subsequently process them with OIC. I will use this approach here too but with a little bit of help from other OCI services such as Oracle Functions, an API Gateway and Object Storage.

      A video of this demo is available here.

      The Solution

      As OIC does not natively support Excel files you need to write a bit of extra code to handle them. You can either store this code within OIC as a JavaScript library or use something like Oracle Functions as a container for you code. I have chosen to use this approach here and will rely on Oracle Functions to do the file conversion for me.

      With this approach in mind, i can think of two ways to implement this pattern:

      The All in one Approach:

      Above: a high-level design that captures a single integration flow that will convert and process excel files

      1. The flow begins with an Excel file that resides on an FTP server (this can be any FTP/SFTP server but for this demo I will use the file server embedded within OIC). I have chosen to use an FTP server as my starting point for this flow as i still see the predominant use of file servers over cloud storage alternatives in most integration flows. In this step, OIC will use the FTP adaptor and its native abilities to list and download my Excel file(s).
      2. The Excel file(s) will then be pushed to OCI Object Storage by OIC. Refer to my previous blog if you need a refresher on how to write files to Object Storage with Oracle Integration. I am using Object Storage here as a transient point for these files because I want to provide an easy and secure way for my file conversion function (which is hosted in OCI) to access these Excel files. It is also possible to achieve this without Object Storage … as the function code can be altered to simply get the file directly from OIC’s file server via FTP rather then retrieve it from Object Storage. Read the complete article here.

      PaaS Partner Community

      For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

      clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

      Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

        Using OCI Logging for searching OIC Activity Stream Log by Niall Commiskey

        image

        Scenario is as follows – I have an order processing integration used by many of my trading customers. Often they contact me to query what was actually ordered. I can use OIC Monitoring-> Tracking to fid the order, but what happens if the customer contacts me 3 weeks later? Maybe the data is no longer in the Activity Stream log. Here’s where OCI Logging comes into play – Enabling OIC to send its activity stream log to OCI Logging is easy –

        Now to this simple demo order processing integrationThe Hare of the Dog pub has ordered a keg of Guinness – whatever that is. But as we say at Commiskey Beer Wholesalers – the customer is always right. The JSON payload is transformed into XML for processing –

        I check out what the order looks like in the Activity Stream – Read the complete article here.

        PaaS Partner Community

        For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

        clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

        Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

        Create a fixed-length file in Oracle Integration by Ankur Jain

        image

        Are you struggling to create a fixed-length file in Oracle Integration and not able to find the step-by-step process on this, so this is the article that helps you to achieve your requirement.

        Let’s first understand what is fixed-length file.

        What is a fixed-length file?

        Fixed length files have a constant length for each field and record.

        For example, if you have data in a text file where the first column always has exactly 8 characters, and the second column has exactly 5, the third has exactly 12 (and so on), this would be categorized as a fixed-width text file.

        To create a fixed file, you must create the XML Schema Definition (XSD) file that allows creating a fixed-length file. In this example, I’m using the below XSD schema to create the fixed-length file: Read the complete article here.

        PaaS Partner Community

        For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

        clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

        Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

        Leveraging Grafana for OIC Metrics by Niall Commiskey

        image

        OCI Logging and OCI Logging Analytics are compelling offerings, but some folks may have standardised on other monitoring tools, such as Grafana.

        So no time like the present to look at how one can leverage Grafana to monitor OIC Service Metrics. My colleague Valeria C. has already done great work in this area and has provided me with the impetus to get started. But first, I need Grafana! 

        Step1 install Grafana on an OCI Compute instance.

        Step 2 install the Grafana OCI Metrics plugin.

        Step 3 monitor!

        Install Grafana on OCI Compute instance

        1. Spin up a compute instance

        2. ssh into the instance

        3. install Grafana – currently we need a version under v8. Read the complete article here.

        PaaS Partner Community

        For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

        clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

        Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress