Build Your First Integration from Scratch | TEMPERATURE CONVERTER APPLICATION | ORACLE INTEGRATION GENERATION 3

In this article I have mentioned the steps to create, design, activate, run an integration completely from scratch in Oracle Integration Gen 3. This article helps you to understand the new Gen 3 UI (user interface) and some of its new features.

Create SOAP Connection in OIC Integration 3 | Calculator Service SOAP Connection | Oracle Integration Generation 3

 

In this Article we will see the steps to create a SOAP connection in OIC Generation 3:

 

Use Case - Lets create a SOAP connection using Calculator Service WSDL URL. This connection can be use in any integration to perform basic calculator operations (i.e. Addition ➕, Subtraction ➖, Multiplication ✖, Division ➗)

Calculator Service WSDL URL:  http://www.dneonline.com/calculator.asmx?WSDL

Create REST Trigger Connection in OIC Integration 3 | Oracle Integration Generation 3

 

STEP1: Login to OIC Generation 3 Instance. On the Home page click Design 🖉 (left hand top side) and then click Connections.

CLICK ON IMAGE FOR BETTER VIEW

Reposition activity in OIC Generation 3 | Cut Paste OIC Activity | Oracle Integration Generation 3

 

In this article we will see the steps to move the activity from one place to another in the integration generation 3 flow:

STEP 1: Select the activity which you want to reposition in the integration flow. Then Click the cut icon ✀ (at left hand top)

CLICK ON IMAGE FOR BETTER VIEW

Oracle Integration (OIC) to import data into HCM cloud using HDL Import Job | Oracle Integration Cloud

Oracle HCM Data Loader (HDL) Process ❓ 🤔

• Oracle HCM Data Loader (HDL) jobs, a powerful tool for bulk loading data through integrations. 
• Using Oracle HDL, you can load business objects for most Oracle HCM Cloud products into Oracle Integration. For example, you can load new hires from Oracle Talent Acquisition Cloud (Taleo EE) as workers into Oracle HCM Cloud using an Oracle HDL job. 
• Integration architect can generate the delimited data files in Oracle Integration using business object template files provided by Oracle HCM Cloud. The business object template file must be associated with a stage file action in Oracle Integration to generate the delimited data file .



- Advertisement -

• To learn more about how to obtain the business-object template file from Oracle HCM Cloud and use the same for delimited data file generation, refer to this post on the Oracle Cloud Customer Connect portal.

Develop an integration to get dynamic email notification | Oracle Integration Cloud

Knowledge :  👀 

Notification? : Enables you to send notification email to relevant users at specific points in the execution of an integration.

When we can use dynamic email notification ❓🤔

suppose you want to send email notification that contain DATA in TABEL FORMAT which ROWS is not FIXED i.e. body of email notification is not fixed. Sometime it contain 2 rows , in next run it may need 50 rows etc. so table structure needs to be dynamic ---> to handle such use case we need code OF DYNAMIC EMAIL NOTIFICATION.

- Advertisement -

Configure REST Trigger Endpoint to Get CSV Data | Integration

In this blog we will see the steps to configure REST Trigger (Source) Endpoint which can receive CSV data as Input from any source system (ex : from WMS System) and do the data processing as require further.

Click to Zoom Out

- Advertisement -

Opaque Schema in OIC

 

Schema ❓ In OIC Schema File (i.e. XML Schema) is used to define the structure of the file which is being used to store data.

Below is an example of an XML schema, or XML schema definition (XSD).

- Advertisement -

Schedule Parameters in OIC | Oracle Integration Cloud

Schedule parameters : ❓ 

are available across all scheduled runs of an integration and can be used to facilitate processing of data from one run to the next.

For example, when performing batch processing a schedule parameter can be used to track the current position of batched data between runs.

Schedule Parameters : 🌟Maximum 5 variables can be added.

- Advertisement -

Schedule BI Publisher Report through OIC | Oracle Integration Cloud

In this article I have mentioned the steps to develop an Integration that can invoke "Schedule Report" operation and can check the status of submitted schedule report operation i.e. Job Status.

When to use Schedule Report & when to use run report operation ❓🤔   

• In laymen term , use 'Run Report' operation if report output size  is <10 MB and use 'Schedule Report' if report content size is >10 MB. Run Report operation can provide the report output in the webservice response but Schedule Report will generate the report output in FTP , UCM etc. ( know as report bursting )

Lets develop the  integration in two parts :

In Part 1 : we will see the development steps to invoke 'Schedule Report' operation and in Part 2 : we will see the development steps to check the Status of 'Schedule Report' operation.

Subscribe to HCM Updates ( via ATOM Feed ) | Oracle Integration Cloud

In this Article I have tried to explain HCM Atom Feeds and also have develop one end to end Integration to let you know how you can subscribe to changes made to feed-enabled resources in Oracle HCM Cloud through OIC Integration.

What are Atom Feeds ?

• HCM Atom Feeds offer a real time mechanism to subscribe to changes in the application
• Atom feeds enable you to track changes made to feed-enabled resources in Oracle Global Human Resources Cloud
• For any updates of interest to downstream applications such as new hires, terminations, employee transfers, and promotions, Oracle Global Human Resources Cloud publishes Atom feeds.
• Oracle Global Human Resources Cloud currently supports creation of Atom feeds for the employees and work structures resources in the following scenarios:

Configure Oracle HCM Cloud Adapter Connection | Oracle Integration Cloud

In this article I have wrote down the steps to create Oracle HCM Cloud Adapter connection in Oracle Integration Cloud.

- Advertisement -

• Login to OIC Instance, Click on top left hamburger sign and then click Integrations, Click Connections
• Click Create (Top Left ), Search for HCM Adapter. Select it and then click Create. Enter any meaningful name for the connection, leave the other fields as it is  and click Create.

• Enter the below details, click Save and then click Test

• *HCM Cloud Host : Enter your HCM Cloud Host URL
•   Security : Enter yours HCM cloud user credentials 

Package Migration or Multiple Integration Migration | OIC Integration Migration

Please access the previous blog to check first part i.e Single Integration Migration steps.

In this article we will see the steps of Multiple Integration Migration or Package Migration : If your requirement is to migration multiple integration in one go then you have to put all the required migration in one package. You can put the package name while creating the Integration (as shown in below image)

Note: Suppose you forget to put the package name while creating the integration then you can give the package name after integration development also. To check that please check this blog.

Lets see the steps in detail for package migration with one simple example :

• Create two simple scheduled integration and put similar Package Name (for example - INT_PACKAGE) in both so that when we migrate this package to new environment both of them got migrated automatically.

• Now lets Export the Package 

• In the left navigation menu , click Packages and then go to the row of the Package which you want to export. In our case we are exporting package INT_PACKAGE
• Click on  menu & then click Export. Save the Exported file (.par file)

• Now login to another OIC Instance where you want to import these integrations.

• In the left navigation menu click Packages and then click Import

• Choose the .par file (example INT_PACKAGE.par) which got exported in above steps and then click Import and Configure

NOTE : Integrations in an exported package do not contain connection credentials. You may provide this data before activating the integrations.

• Once the package got imported successfully, you can see the Configuration Editor window. Here you have to configure the connections, lookups etc details. In this Hands-on example - Integration-1 & Integration-2 don't have any such connections or lookups, so just click the back arrow sign  <  to exit this window.

• Migration of multiple integrations completed, now you can Activate the Integrations and can test them.

                  Thank you !

Migration of Integration from one environment to another | Single Integration Migration | OIC Integration Migration

  

You can do migration of Integrations from one OIC Instance to another in two different ways :

1. Single Integration Migration : You just have to Export the Integration from current Instance and Import it to new OIC Instance.

2. Multiple Integration Migration : Now suppose you want to migrate multiple integration in single go then you can achieve it by Package Migration. You can group integrations into a package. When you import or export the package to or from Oracle Integration Instance, all integrations in that package are imported or exported.

Knowledge :  👀 

Packages ? : You can group one or more integrations into a single structure called a package to easily import and export them to and from OIC service. Packages being optional, integration do not be a part of them. At least one integration is needed for a package to exist.

Lets see the steps in detail :

1 . Single Integration Migration ~

• Login OIC instance.In the left navigation pane, click  Home >Integrations.
• Go to the row of the Integration which you want to migrate. Click on  menu.

• Select Export.

•  .iar file of the integration automatically get downloaded

• Now login to another OIC Instance and then migrate to Integrations page. Select Import

• select the .iar file which we have exported above

• After choosing the .iar file, click Import and Configure

• Now once integration got imported you have to configure the Integration Connection, Lookups etc if any present in the imported integration. For the integration which i have taken as example don't have any Connection, Lookups etc. so just click back arrow "<" and come out of this window.

• Activate the Integration.

• Your integration is ready to use in New OIC Instance. Migration of Integration completed.

2. Multiple Integration Migration :   click to access the post

Throw New Fault Action in OIC

Throw New Fault : 👉 You can create and throw your own faults in an integration with a Throw New Fault action.You can use this inside for-each action, switch action etc. Using this action item you can Validate the input data also (check below hands-on practice).

While configuring this action in an integration, you have to enter below details :

*Code - enter error code (ex-"error_001")

Reason - enter error reason  (ex-"Invalid Input")

Details -  enter error detail (ex-"missing name")

Skip Condition - Define a condition to prevent the fault from being throw in the skip condition version of the expression builder (ex-"Number-1>Number-2)

Knowledge :  👀 

Deleting the Throw New Fault action has no impact on downstream activities because this error does not have any output.

#Hands-on Practice :

Use Case : We will see the steps to develop an APP Driven Orchestration Integration which can do Subtract Operation by invoking Calculator SOAP service. This Integration will have two inputs (Number-1 & Number-2) which we will pass as inputs while testing this Integration.

Then we will add Through New Fault activity before invoking Calculator Service and Validate whether Number-1 > Number-2. If Number-1 is not grater then Number-2 ,Through New Fault action will get execute and send custom declare error message, also stop the execution of flow right there, subtract operation will not happen.(i.e. Calculator Service Invocation will not occur).

You can see below image to understand what exactly we are going to develop :

When Number-1 > Number-2 

👇

When Number-1 not greater then Number-2 

👇

Sample of Self declare custom Error Message 

👇

I hope now the flow is clear for you, now we can develop the Integration 

Lets Develop the Integration : ☺

Prerequisite : 

💢 A REST Trigger connection. If you don't have, you can access this blog post and can create it. 

💢 A Calculator connection. Please click here to access the article to configure the connection to access Calculator Service.

Step 1 : Create  APP Driven Orchestration Integration. 

Step 2 : Configure REST Trigger connection

• Add the REST Trigger connection which we have created in above prerequisite section. 

(if you don't have created yet ,you can access this blog and create it )

• Enter any meaningful endpoint name & then click Next

• Now use below data inside Resource Configuration Wizard and then click Next

• *What is the endpoint's relative Resource URI ? : /subtract/{Number-1}/{Number-2}
• Action : POST
• Select ✅ Configure this endpoint to receive the response

• Request Query Parameter automatically get populated. Just select the datatype as Integer and then click Next

• Configure the Response Payload by selecting response payload format as JSON Sample and then click <<<inline>>> , enter below JSON. Click Ok

{

  "Response Message" : {

    "Subtraction Output" : "",

    "Error Code" : "",

    "Error Reason " : "",

    "Error Description" : ""

  }

}

• Click Next

• Click Done. REST Trigger endpoint configuration completed.

Step 3 : Add one Scope action

• Enter any meaningful name and then click Create

Step 4 : In this step we will invoke Calculator Service using the SOAP connection which we have already configured in above prerequisite section. If you don't have configured yet , requesting you access this blog and create the connection

• Search for Created Calculator Connection and click on it 

• SOAP adapter endpoint configuration will get opened. Enter any meaningful name for the endpoint and the click Next

• Configure the operation by selecting below options 
• Select the Port: Select CalculatorSOAP
• Select the Operation : Select Subtract  and then click Next  

• Skip the window, click Next

• SOAP Endpoint configuration completed. Click Done

• Now open the mapper and map the elements as given in below image.After mapping click validate and close the mapping.

click on image to zoom out

Step 5 : Now in this step we will add Throw New Fault Activity and configure it to Validate the Input Data and if Validation Fail, it will through Error and stop the execution of the flow right there.

• Search for Through New Fault activity and add it between Mapper and Invoke Connection (as shown in below image)

• Enter any meaningful name and then click Create 

• Configure the Throw New Fault action as given below. Inside this window actually we have to provide our custom error detail. Click on edit icon ✎ and enter the below sample detail :

• *Code : enter "400" 
• Reason :enter "Invalid Input Data"
• Details : enter error details message : Input Number-1 is not greater then Input Number-2. Hence Subtraction operation is not possible"

• Now lets configure the Skip Condition which will stop Throw New Fault action to being execute. If this Skip condition check fail then Through New Fault Action will get execute and throw Error error message.

Configure below mathematical operation by dragging and dropping the Input variable from left hand side of expression window.Make sure to put the number under Integer Function.Please take reference from below image.

Integer (Number-1)>Integer(Number-2)

Click on Image to Zoom Out

• Click Validate and Close

Step 6 : Lets map the response of the Calculator Service Output with the Integration Output. 

• Drag and Drop the "getInputs" Mapper inside the Scope by clicking at Reposition tab

 

• Open the Mapper by click Edit icon and map the Subtract Response with the Integration Output Element. (take reference from below image)

       SubtractResult* ----- > Map With ----> Subtraction Output*

Step 6 : In this step we will declare default handler of Scope and map the Through New Fault Object details. If above configured Through New Fault execute it will send error detail to scope fault handler

• Click Fault Handler (present above right hand side in SCOPE) and then select Default Handler

• Add Return activity and then open its mapper

• Map the Throw New Fault Object elements with the Target element (Integration Output).This will help us to get error message as integration output if fault happen

     

Click on image to zoom out

Step 7 : Finally enable the Tracking variable for the integration.

• Click on hamburger sign and then click Tracking 

• Drag and drop the Template Parameter (Number-1,Number-2) inside Tracking Field. Click Save 

Step 8 : Integration development completed. Click  Save and Close the development Window. 

PART 2 : Testing 👉 Click to Access testing steps