Integrate SaaS hands-on Bootcamps Webtraining Asia, September 21st, 23rd & 28th 2021

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:

· On-demand training

· EMEA October 19th , 21st & 26th 2021

· US & Canada October 5th, 7th & 12th 2021

· Asia, September 21st, 23rd & 28th 2021

· South America, September 8th, 9th & 10th 2021

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.

Blog Twitter LinkedIn Facebook Wiki

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

Using REST APIs to manage Connections in OIC by Pranav Davar

In cases, when we have many connections created on the OIC instance, it becomes hard to manage connections using the OIC console. Also, to achieve automation, manually going and updating each and every connection is never a feasible task. OIC provides various REST APIs to fetch connection details, update connection properties and delete connections. With the help of these APIs, we can overcome such scenarios.

In this blog, we will be discussing how to use various OIC connections REST APIs. A postman collection in the public workspace, which contains some of the use cases for this and can be forked, updated, and used accordingly.

Below are various REST APIs, that are covered in this blog.

1. Retrieve Connections
2. Retrieve a Connection
3. Update a Connection
4. Test a Connection
5. Refresh Metadata for a Connection
6. Delete a Connection

In this blog, we will be using Postman to test and run various APIs. Below is the link to the Postman collection, which will be helpful to try and test different REST APIs.

Authentication for REST APIs

To invoke OIC connections REST APIs, BASIC AUTH can be used to authenticate and authorize calls. The user whose credentials are used to call these APIs must have access to edit the connection.

OAuth can also be used to authenticate to REST APIs. In this blog, we will be using Basic Auth to authenticate/authorize API calls. 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.

Blog Twitter LinkedIn Facebook Wiki

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

Improving the performance of Oracle Integration flows that use REST calls by Nick Montoya

Oracle Integration connects disparate SaaS and on-premises applications to help businesses move faster. This interaction between Oracle Integration Cloud (OIC) and Oracle SaaS (or on-premise) applications needs to be carefully designed and planned for performance and scalability. Overloaded integration flows may run within acceptable timeframes during design phase. They may even pass User Acceptance Testing especially if testers are just going through functional testing. However, when testing for performance and scalability, problems may arise. It is imperative to design solutions that would meet expected peak volumes at runtime. This blog will provide some helpful pointers that you could use to make your solutions achieve better performance and scalability.

Identify Peak Volume Profile and test downstream systems

When designing an Oracle Integration solution for Performance and Scalability, it is very important to identify the peak-hour and peak-day volume. Knowing how many integrations will be running at peak hour will not only help you size your Production OIC environment accordingly, but also, it will help in the testing of your downstream (from OIC point of view) systems.

Testing of downstream systems with expected volumes early in the implementation cycle will help you validate a scalable implementation and/or identify performance bottlenecks in your design.

If these outbound calls take longer than a few seconds, then there is plenty of design work to do. Longer synchronous calls to outbound systems may cause OIC to wait for these calls to finish and it may block other processes from running in OIC. Therefore, end users may experience longer response times. 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.

Blog Twitter LinkedIn Facebook Wiki

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

Connecting securely from Oracle Integration to Autonomous database using network access list by Shreenidhi Raghuram

Introduction

Many integration use cases require the use of Autonomous database (ADB) as the parking lot datastore with Oracle Integration.

Oracle Integration provides various options to connect to ADB. The Oracle integration documentation table below summarizes these options.
* Cloud Database Connectivity Support

Options

In summary, 

• Connecting to ADB dedicated instances (ADB-D) and ADB shared private endpoint DB requires an OIC connectivity agent.

• Connecting to ADB Shared infrastructure (ADB-S) database uses JDBC over SSL and provides direct connectivity using wallet.

Note that this mode does not require connectivity agent to be deployed. Oracle integration connects using JDBC over SSL directly to the ADB-S public endpoint in this case.

Use case

Certain organizations’ security requirements or use cases may mandate that the database network traffic should only traverse through a private endpoint within a VCN. These use cases undoubtedly will need to use the ADB dedicated or ADB shared private endpoint databases. Oracle integration requires the connectivity agent to be deployed in the ADB VCN for these modes. 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.

Blog Twitter LinkedIn Facebook Wiki

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

Oracle Integration Message Packs and Pricing by Ankur Jain

Oracle Integration billing depends on the Message Pack you provide while provisioning the Oracle Integration instance. The minimum Message Pack for Oracle Integration is one. The maximum number of Message Pack depends on the License Type you choose while creating the Oracle Integration instance.

Oracle Integration offers two types of licenses you need to choose from and accordingly set the maximum number of message packs. The following figure shows the type of license and max threshold.

Oracle Integration license and max threshold

Pricing is based on the number of Message Pack/hour as shown in the following figure:

Oracle Integration pricing

Refer to the document for the latest pricing. Few pricing examples are given as per the following tables: 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.

Blog Twitter LinkedIn Facebook Wiki

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

Oracle HCM Cloud – Payroll Sync with the Oracle Integration Cloud by Daniel Teixeira

The most common use case I come across with Oracle HCM Cloud is Payroll Integration. Most organizations use 3rd party Payroll providers. Many of those have multiple payroll providers if they operate in multiple countries. This means that there are several different requirements for each of those providers.

With the Oracle Integration Cloud, we can provide and automated framework to manage the Integration with all Payroll providers and with ERP also (the bigger end to end process also touches ERP)

This post will show a sample implementation of this.

Create HCM Extract

First things first – We need to define an HCM Extract. This is the extract that contains all the required data to be sent to the Payroll providers. This is definitely not the job of the integration developer/architect, but we need to have this in place.

There are some options on how to do this:

1: One extract for all payrolls – OIC will do the proper mapping for each payroll.

2: Multiple extracts, one for each payroll – OIC will do minimum mapping. 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.

Blog Twitter LinkedIn Facebook Wiki

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

Authenticating Oracle Integration flows using OAuth token from 3rd party provider by Prakash Masand

As Oracle Integration customers look to embrace the multi-cloud strategy, they will have cross-cloud business applications & processes. In the context of a realistic business solution, customers will end up having a business requirement to integrate the business applications and services across multiple cloud providers. As an example, let’s say the customer has a business application running on a non-Oracle Cloud provider like Microsoft Azure. This business application now has a requirement to fetch the information from the Oracle Cloud applications. In normal circumstances, one would acquire the token from the Oracle Identity Cloud Service, to fetch the information from Oracle Cloud applications. However, in a multi-cloud vendor solution, this will cause additional complexity of handling multiple tokens lifetime, additional security risk, etc. In such a scenario how good it would be if one can fetch information or I may say integrate with cross-cloud vendor applications using OAuth token in hand. This is exactly the topic of my blog i.e. how one can invoke the Oracle Integration flow using the 3rd party OAuth providers.

I will expound on the same example I portrayed earlier as a sample use case for the blog, we will see how one can use the OAuth token obtained from Microsoft Azure AD to invoke the Oracle Integration flow.

Let’s now talk about the highlevel solution, we will be leveraging a couple of Oracle Cloud Infrastructure services viz. Oracle API Gateway and Oracle Functions. At an outset, we will use the OCI API gateway to be the front end of our Oracle Integration flow. Oracle API Gateway supports using the authorizer function as an extra logic layer for authenticating the APIs. This is exactly what we want i.e. we would like to build logic to validate the OAuth token received from callee and exchange it with the required token from the Oracle Identity Cloud Service for invoking the OIC flow. Let us now visualize the solution flow graphically:

As you can see from above, here the process starts with the user/business application acquiring the OAuth token from Microsoft Azure AD, once acquired it invokes the endpoint exposed through Oracle API Gateway. Oracle API Gateway will be invoking the custom authorizer Oracle Function (based on configuration) and then invokes the real backend endpoint i.e. Oracle Integration flow.

Let us now dive into the details of implementing the above process/flow, for the sake of simplicity I am going to divide the above process into three steps viz. 1)  Oracle Integration/IDCS configuration 2) Oracle Function custom authorizer implementation 3) Oracle API Gateway configuration. 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.

Blog Twitter LinkedIn Facebook Wiki

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

August 2021 Oracle Integration Update by Antony Reynolds

It is time for the August quarterly update to Oracle Integration. With Summer in full swing, Lilly, the Oracle integration mascot, is pleased to share all our new features and improvements. Note that testing is still underway for these features and, although unlikely, it is possible that some will not meet our quality standard and be deferred to a later release.

Announcements & Update Windows

Currently tenant administrators get notified of OIC Gen 2 updates via notifications in the OCI console. OIC Gen 2 administrators can also see the same update notice in the OIC console, so watch out for the date of your update.

Remember, you can also mark your Gen 2 instance for update in either the first or second update window, as explained in Choose Your Update Window. If you previously tagged your instance, then there is no need to tag it again. If it is not yet tagged for window 1, then the deadline for tagging for August was 14 July but you can still add it for the November release. Tags added after July 14 will take effect for the November release.

An Artificially Intelligent Assistant

This release continues to expand the artificial intelligence capabilities within Oracle Integration by debuting a new digital assistant named Oracle Assistant. Use Oracle Assistant to learn how to get started with Oracle Integration, find answers to your questions, and more. Give it a try, and let us know what you think!

To learn more about how Oracle Assistant was developed see this great video.

Prebuilt Connectivity Enhancements

As usual there are enhancements to existing adapters as well as important new adapters.

New Third Party Adapters

Two new adapters for popular applications are released this quarter:

• SAP S/4 Hana Adapter
• Zendesk Adapter

Enhanced Adapters

Exciting updates to a number of third party adapters:

• OData support in SuccessFactors Adapter
• Platform Event support in Salesforce Adapter
• JQL support in Jira Adapter
• Custom Objects are now supported in Bulk Export in Marketo Adapter

Recipes Update

Lots of new recipes,many of them dealing with customer experience (CX) applications. Note that these recipes may not ship at exactly the same time as the August update. check the OIC home page for these recipes.

Note each recipe is only listed once in the table, for example the sync new/updated issue from Jira to Salesforce is listed under Jira recipes not Salesforce. So make sure to check both endpoints for a recipe that may interest you. 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.

Blog Twitter LinkedIn Facebook Wiki

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