OIC DB Adapter for Oracle Database 18c by Niall Commiskey

I just installed the 18c DB on my laptop, now to leverage it from OIC – Create DB Connection Here is the DB connection configuration. Leverage the DB Connection in an Integration

I created an integration with a REST Trigger – Payload is custId and customerName. Then invoke the DB connection. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

Découvrons Oracle Cloud Platform for Integration (Part 1) French article series by Sanae BEKKAR

Découvrons Oracle Cloud Platform for Integration (Part 1)

Implémentation de ‘TweetFlightsScheduleChanges’ via OIC (Part 2)

Implémentation de ‘TweetFlightsScheduleChanges’ via OIC (Part 3)

Implémentation de ‘TweetFlightsScheduleChanges’ via OIC (Part 4)

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

Oracle Integration Bootcamp – September 23-25, 2019 Bengaluru India

Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform? Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners!

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.

Workshop format:

• In-person workshop with presentations, demos, and hands-on labs
• Attendees will receive training environment login during the workshop

Audience:

• Oracle SaaS partners who implement ERP, HCM and CX solutions
• Oracle Tech Partners who are Specialized in SOA Suite
• Consultants and Architects with technical background

Schedule: September 23-25, 2019

Location : Oracle Tech Hub
Marathahalli – Sarjapur Outer Ring Rd, Kadubeesanahalli
Bengaluru 560103
India

For details please visit the registration page here.

For additional local training’s please visit the website here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

Change connection in the Integrations: Oracle Integration Cloud by Ankur Jain

There is the situation where we are required to replace the connection in the integrations. Integration cloud doesn’t allow to change the connection from the integration canvas directly. So in this blog, we’ll demonstrate two ways to solve this problem which will help us to easily switch the connection in the integrations.
Before we proceed further, let me explain the use case where we may require to change the connection in the integrations:

• Let’s suppose we have 10 integrations which are using the single DB connection and the name of the connection is DB_Conn. Considering, in the DB_Conn, we had configured the standard DB schema called apps. Later we realize the 5 integrations should not use standard schema to compile the package or procedures and should use some custom schema (custom_user). Then, in that case, we will have to create one more DB connection with the different name and configure custom_user and then use the DB connection in these 5 integrations.
• We want to clone the integration and in the cloned integration wanted to use different connection
• We are migrating the integration which uses one REST connection with name REST_Sample but we have REST connection on the different instance with a different name called REST_Conn

Below limitation need to keep in mind before we replace the connection

• The integration should not be in locked or activate state
• Only the connection of the same adapter type can be replaced. For example, if we have an integration using the REST adapter then we can’t replace the connection of the SOAP adapter type. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

OIC Integrations – re-submittable errors by Niall Commiskey

This is an area customers often ask me about. Firstly, when is an error re-submittable? According to the docs –
You can manually resubmit failed messages. Resubmitting a failed message starts the integration from the beginning. All faulted instances in asynchronous flows in Oracle Autonomous Integration Cloud are recoverable and can be resubmitted. Synchronous flows cannot be resubmitted.
Next question is – who do I know if my flow is asynchronous?
Again back to the docs –
Oracle Autonomous Integration Cloud does not currently allow modeling an asynchronous request response service. However, all scheduled orchestration patterns internally use an asynchronous request response.
However, OIC does support Fire and Forget (one-way requests). Now you ask – how can I create a Fire and Forget interface for my OIC Integration flow? This is relatively simple – I use a SOAP trigger, based on a one-way wsdl. The one way wsdl, as the name strongly suggests, does not include a response. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

Implement Pagination in REST Service: Integration Cloud by Ankur Jain

There are situations in which we need to fetch a large number of records from the on-premise application in the Integration Cloud. For example, there are 100k+ records resides in the on-premise database table which we need to fetch and expose them into the REST service response. In this particular scenario, we are considering the database is installed behind the firewall. So to communicate with the on-premise application, connectivity agent is required. Connectivity agent has some limitation in which agent can parse payload of 10MB only for a single request. Exceeding the limit may cause stack overflow error in the agent which may bring the agent down.

So to handle a large volume of data from the on-premise application, we have to keep this limitation in mind and implement the solution accordingly. There might be multiple ways to handle such a situation. Here I’m gonna to handle this situation by implementing the pagination into the REST service which will fetch the data into the chunk.

To complete this article we should have below

• Oracle Database 12c
• Oracle Integration Cloud instance
• Connectivity agent installed

Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

Turn BYOL metering on or off in Oracle Integration Cloud by Scott Haaland

Toggle the BYOL (Bring your own license) setting for Oracle Integration Cloud

Oracle has a great licensing option for our existing customers called Bring Your Own License, which allows customers to get greatly reduced billing rates for some of our most popular cloud services.  In PaaS, many of the Fusion Middleware Licenses can be moved from on-premises use to cloud usage, which allows the customer to continue to glean extreme value from their licensing investments of the past.  There is another blog post here that has an FAQ for more details on BYOL:

https://www.oracle.com/cloud/bring-your-own-license/faq/

For Oracle Integration Cloud, this is a great option for our existing SOA Suite and BPM Suite customers.  If they have licenses that are either not being used (shelved) or have a ULA or other license type that allows additional usage on demand, these Weblogic Suite, SOA Suite and BPM Suite licenses can be applied to an Oracle Integration Cloud (or SOA Cloud) instance in the Oracle Cloud, and the hourly metering rate is dramatically reduced.  Details for which licenses are required can be found in the PaaS and IaaS Universal Credits Service Description document here. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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

APIs and Microservices at Work in the Real World by Bob Rhubart

Luis Weir (Capgemini) and Wes Davies (Co-op Group) discuss microservices, API management, and the technical aspects of their work on the project that won one of this year’s Oracle Cloud Platform Innovation awards. As mentioned in the interview, Luis is a panelist in the latest Oracle Developer Podcast, "On Microservices Design and Implementation," available at: Watch the video here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki

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