X

PaaS Partner Community

Recent Posts

Business Process Management

Integration & Process Partner Community Newsletter April 2021

Dear Partner Community Oracle SaaS like HCM, ERP and SX solutions require to be connected. Pre-build adapters, part of Oracle Integration, accelerate these implementations. Standard SaaS solutions can be extended with custom processes. Often these processes reflect the core business value and are the competitive differentiator. Oracle Integration offers both capabilities to integrate and extend processes, for partners a great consulting and service revenue opportunity. Thanks to Daniel Teixeira who published a great process automation introduction series: Part 1 & Part 2 (Forms) & Part 3 (Workflow). With Opera Oracle is the leader in the hospitality industry. Opera cloud facilitates hotels to mange room bookings. These systems need to be integrated with custom applications and standard software. Oracle Hospitality Integration Platform (OHIP) in combination with Oracle Integration (OIC) accelerate the digital transformation of the hospitality industry. Niall describes a typical hospitality integration between the reservation system into a CRM for sales and marketing purpose. For an overview including a demo please watch the on-demand webcast. Thanks to the community for sharing all the integration articles: How to define a Repeating Global Variable & Using Aggregate Functions Sum(), Count() while Processing Larger Files & Beating OIC’s FTP File Limits & Subscribing to Fusion Custom Business Events in OIC &Guidelines when moving Integration Workloads from SOA to Oracle Integration & Accessing Object Storage from Oracle Integration & Connecting Hubspot and Netsuite using Oracle Integration (OIC) & Oracle Integration - Connecting to NetSuite using Token Based Authentication & FlexDeploy for Oracle Integration Cloud & Piloting Your Digital Transformation Journey through Modernization & SOA Suite Docker Image Release - 21.1.2 & Helpful Suggestions in setting up SOA suite on Containers. In the process & innovation section Jan published a process correlation article and how to reuse subprocesses. Mani describes how to extend Oracle application cloud approvals. For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The April edition highlights the hands-on Chatbot training and a brand new Integration newsletter for customers. In this month’s community webcast Greg Mally & Deepak Arora will present Identity Propagation call from Integration Cloud to Oracle SaaS Applications. Please join the Partner Community Webcast April 27th 2021. On-demand webcast recordings are available at the Oracle Video Hub. Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity. To read the newsletter please visit www.bit.ly/PaaSNewsApril2021 Please like and share the newsletter at Twitter and LinkedIn. 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: newsletter,SOA Community newsletter,SOA Community,Oracle,OPN,Jürgen Kress

Dear Partner Community Oracle SaaS like HCM, ERP and SX solutions require to be connected. Pre-build adapters, part of Oracle Integration, accelerate these implementations. Standard SaaS solutions can...

Business Process Management

Consolidate tasks from Oracle applications cloud and other applications into a single list of tasks by Mani Krishnan

In today’s enterprise, users must expect to multitask in order to achieve higher productivity. Thus, tasks and lists of tasks become necessary features of most enterprise applications-such as ERP, HCM or CRM--for improving user productivity. Tasks can range from simple to-dos that remind the assignee about activities outside the application to approvals for HR, finance or sales transactions.                          Enterprise users commonly must deal with multiple task lists from applications from various vendors and from homegrown applications.  For a single user to access multiple web sites to look up tasks on a daily basis defeats the purpose that tasks lists are meant to serve. For example, Oracle provides a common list of tasks for integrated cloud applications, such as HCM, ERP, Supply chain and Sales.  Additionally, customers might want to extend the approval capabilities with PaaS, by using business process management (BPM) products such as Oracle Integration Cloud (OIC)-process.  In such scenarios, the users would be required to check two lists of tasks. A list of tasks that consolidates tasks from multiple applications can significantly improve productivity of enterprise users by eliminating the need to check multiple lists for any pending activity and take action. 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

In today’s enterprise, users must expect to multitask in order to achieve higher productivity. Thus, tasks and lists of tasks become necessary features of most enterprise applications-such as ERP, HCM...

Cloud

Get away with that paper using SOA Suite and E-Post/Docuguide by Johannes Michler

A customer recently told me they would like to get away from having to print, envelope and post mark thousands of invoices manually every month. Even though we have changed their invoicing process to an electronic one for most of their customers years ago by sending out emails through Oracle SOA Suite, they still had a considerable amount of customers insisting on printed invoices delivered by post. Let’s have a look at how we managed to get away with that paper. Starting Point The customer was producing his invoices using the Oracle ERP System Oracle E-Business Suite (EBS) running on OCI. For electronic invoices, EBS has for a long time passed on the invoice and eventually some more additional attachments further detailing the invoices to Oracle SOA Suite 12.2.1.4. Then an integration layer running on SOA Suite delivered the invoices to the customer by sending (in most cases) an email with one or multiple (PDF) attachments. Customers not opting in for this electronic process got their invoice printed through a traditional E-business Suite concurrent program on a printer at the customer premises. From there, the invoice was eventually enriched with the necessary attachments, then put in an envelope and sent to the customer by post. 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

A customer recently told me they would like to get away from having to print, envelope and post mark thousands of invoices manually every month. Even though we have changed their invoicing process to...

Cloud

Identity Propagation call from Integration Cloud to Oracle SaaS Applications – Partner Community Webcast April 27th 2021

One of the big challenges that Oracle Integration Cloud developers face is any outbound REST call from Integration Cloud (IC) to Fusion Applications (FA) APIs require a user’s identity. Although this may seem trivial on the surface, the mechanism to have the identity of a user flow from a client application to IC to FA in a secure fashion is not trivial. However, there is a proven pattern that can be leveraged with Oracle Cloud technologies to solve this problem and the following presentation will illustrate this pattern. Speaker: Greg Mally & Deepak Arora Schedule: Tuesday April 27th 16:30 – 17:30 CET (Berlin time) For details please visit the registration page here. Take the opportunity to watch our community webcasts on-demand: · Connect Opera with Oracle SaaS · Extreme Scalability and Enhanced Resilience for OIC · SOA Modernization · Cloud Native and Serverless SaaS Extensions · How Process Workflow can extend the role of Integration · Innovate Service Cloud with Chatbots · Integration Update & New Features · Chatbot Design best practices for Conversational UX · Connect, Innovate, Extend SaaS KickOff Webcast 2020 · Cloud Platform KickOff Webcast 2020 · Netsuite Integration · Integration Insight · Innovate HCM with Chatbots · ERP Integration with Application Adapters · HCM Integration with Application Adapters · Extend SaaS with Visual Builder Cloud Service · Integration Adapters · Integrate SaaS · Digital Assistant Update · SOA Cloud Service · PaaS Overview Webcast · Process Cloud Service Update · Integrate ERP Cloud · Integrate HCM Cloud · Functions and Cloud Native · Blockchain · API Platform Cloud Service part 2 · 3rd Generation API Gateways part1 · Oracle JET · Oracle Visual Builder Cloud Service · Container Native Application Development Platform For the latest information please visit Community Updates Wiki page (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

One of the big challenges that Oracle Integration Cloud developers face is any outbound REST call from Integration Cloud (IC) to Fusion Applications (FA) APIs require a user’s identity. Although this...

Cloud

JSON Obfuscation by Niall Commiskey

This is my first guest post and it couldn't come from a more competent source - so take it away Chris Peytier - With Oracle Integration Cloud, the need to handle incoming JSON requests is rather common, However, OIC will attempt to process these request, and will hence not maintain the original JSON format. What if we want to handle the request "as is", preserving its original structure? For example if we want to pass it down to, say, an ADW database instance, so that it can be processed there as JSON document? How can we avoid OIC to interpret and "de-structure" the JSON formatting? We can do this by using an "obfuscated" mode, In order to preserve the JSON structure of an incoming request. For this, we will write & read the file with 2 stage file actions in sequence. Here are the steps that need to be performed: a)     Write your incoming JSON request into a file, via a Stage File action: You can choose the name of the directory, etc. as you wish. b) Create a file on your laptop , of type .xsd, for example opaqueSchema.xsd, and enter the following lines in that 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. Blog Twitter LinkedIn Facebook Wiki Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

This is my first guest post and it couldn't come from a more competent source - so take it away Chris Peytier - With Oracle Integration Cloud, the need to handle incoming JSON requests is rather...

Cloud

Identity Propagation – VBCS > IC > Fusion Apps by Greg Mally

This blog was a collaborative effort between Greg Mally and Mike Muller of the A-Team.  There is an effort under way to provide example assets for this blog and when those assets are available, this blog will be updated with details on how to get to them. One of the big challenges that Oracle Integration Cloud developers face is any outbound REST calls from Integration Cloud (IC) to Fusion Applications (FA) APIs require a user’s identity.  On the surface this seems pretty trivial because the IC REST connections allow for configuring the connection with basic authentication or OAuth 2 JSON Web Token (JWT). However, this configuration is tied to a single user and many use cases/flows require the identity of the person making the FA REST call due to access restrictions, security, auditing, etc. This blog will present a pattern that has been implemented to accomplish identity propagation from a client application, through IC, and to FA. Problem Statement How can an Oracle Integration Cloud developer ensure that the invoking user’s identity gets passed along to a Fusion Application call? Read the complete article here. For more information attend the Identity Propagation call from Integration Cloud to Oracle SaaS Applications – Partner Community Webcast April 27th 2021 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

This blog was a collaborative effort between Greg Mally and Mike Mullerof the A-Team.  There is an effort under way to provide example assets for this blog and when those assets are available, this...

Cloud

Replace Trigger in Orchestration by Vijay Kendai

  This blog is for a new feature coming out in Oracle Integration Cloud (OIC) February 2021 release. Currently in Orchestration, after a trigger has been added, the user does not have the ability to replace it with another trigger. The user essentially has to re-create the integration to achieve this. With this feature, users will be provided with the ability to replace a trigger with minimal impact and without having the need to re-construct various actions in the canvas. After conversion, users will be provided with appropriate warnings and errors to take any corrective action needed, to bring the integration to a configured state. What is covered ? In the first phase, only scheduled orchestrations will be addressed. Schedule trigger will be allowed for replacement only with a REST trigger. What is not covered ? Replacing schedule in Scheduled orchestrations with REST trigger having multiple verbs Replacing trigger in App driven orchestrations Details The following section describes in detail how a schedule can be converted to a REST trigger. On clicking the schedule node, user will be provided with a menu option under more actions to convert to a REST based trigger as shown below. 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

  This blog is for a new feature coming out in Oracle Integration Cloud (OIC) February 2021 release. Currently in Orchestration, after a trigger has been added, the user does not have the ability to...

Cloud

Embedding Oracle Integration Insight dashboards : Quickly and Easily by Sandhya Lakshmi Gopalan

Integration Insight in Oracle Integration empowers business users by providing a real-time view into their business processes. In addition to viewing Insight dashboards within the Oracle Integration console, Insight offers the capability to embed business dashboards in other applications. For example: If your business involves order management and you already have your business users using Oracle Cloud ERP to manage your orders, you can embed Insight dashboards for the order process in Cloud ERP. This provides business users with a single consolidated view within Cloud ERP, without needing to sign into Oracle Integration to view the Insight dashboards. If you have a financial business process, with a front-end application that is used by business users, Insight dashboards can be embedded in the front-end application to show real-time business process metrics that can assist in making business decisions. Integration Insight provides two ways to embed dashboards in other applications: A URL builder for embedding dashboards in an iFrame. Oracle JET Composite Component Architecture (CCA) components for embedding dashboards as HTML elements. 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

Integration Insight in Oracle Integration empowers business users by providing a real-time view into their business processes. In addition to viewing Insight dashboards within the Oracle Integration...

Cloud

API Gateway Integration: Quick and Easy by Varinder Kaur

This blog is for a new feature coming out in Oracle Integration Cloud (OIC) February 2021 release. If you struggle with API Gateway Integration, then read this blog as it covers the steps needed to seamlessly integrate with API Gateway. The API Gateway service enables you to publish APIs with private endpoints that are accessible from within your network, and which you can expose with public IP addresses if you want them to accept internet traffic. Now you can create an Oracle OCI API Gateway Deployment from a OIC Rest based Integration. The API deployment will be created with routing rules pointing to the activated integration. Assumption:  OIC user has already created API Gateway or access to API Gateway. Creating a Deployment from OIC : · Configure in API Management settings with OCI Signature V1 Policy : Configure the properties - tenancy OCID, user OCID, fingerprint, private key and passphrase(if present). These properties can be found under your profile menu, tenancy and user settings. Click on Save button after configuring the values, it will validate the credentials and save API gateway settings. · Activate an Integration: Taking the example of a sample integration here- "Echo" integration ( You can build your own integration). Activate the integration by clicking on Activate icon. The below activate dialog will appear.In the activate dialog, there is an additional action of "Activate and Deploy" which will perform two actions- first activate the integration and then deploy it. 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

This blog is for a new feature coming out in Oracle Integration Cloud (OIC) February 2021 release. If you struggle with API Gateway Integration, then read this blog as it covers the steps needed to...

Cloud

Automatic reactivation of Integration after a connection update by Shubham Agrawal

This blog is for a new feature coming out in Oracle Integration Cloud (OIC) February 2021 release. This blog covers the issue of applying the changed connection properties to the active integrations. A connection can be used by multiple integration. If connection is updated then Active integrations don't reflect until they are re-activated. After updating the connection, user currently has to manually go to each integration and re-activate to reflect the updated connection. As an Oracle Integration Cloud user after connection update, user should be able to reactivate all the active integration which are using the same connection. What does it cover Users can reactivate the associated integrations for the connection they are trying to update. User only need to reactivate the integrations if they change connection properties, it does not apply if only primary info is changed, as that would not impact the running integrations. Now, we can simply reactivate all the associated integrations with a single click, and it will restore the active integrations to its original state (like retain if tracing need to be enabled). Key Features Users have option to immediately reactivate the integrations after save or update all the associated resources required to be updated before updating the associated active integrations. User can reactivate integrations along with save with a single button click. To make sure that reactivate works, user should test connection after changing the metadata or credentials of connection. 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

This blog is for a new feature coming out in Oracle Integration Cloud (OIC) February 2021 release. This blog covers the issue of applying the changed connection properties to the active integrations. A...

Cloud

February 2021 Oracle Integration Update by Antony Reynolds

It is time for the February quarterly update to Oracle Integration. Lilly, the Oracle integration mascot, has lots of exciting new features and improvements to share with you. 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 upgrade notice in the OIC console, so watch out for the date of your upgrade. Remember, you can also mark your Gen 2 instance for update in either the first or second upgrade 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 February is 14 January. Tags added after this date will take effect for the May release. API Led Integration We are making it easier to work with Oracle API products. Previously we supported only Oracle API Platform. We are now building out support for Oracle API Gateway. Auto-generation of API gateway deployment from OIC You can now create an Oracle OCI API Gateway Deployment from a REST based Integration at the click of a button. The API deployment will be created with routing rules pointing to the activated integration. Integrations with multiple verbs/paths will have a rule created for each verb/path. Developer Productivity Enhancements We are making the following improvements for developers: Support for attachments in Integration Test UI The testing tool built within Oracle Integration now offers the support for attachments. This will help developers test Integrations with attachment support without having to leave Oracle Integration UI. Ability to edit XLST code in Oracle Integration Mapper Developers can now edit XLST code within the Mapper while building their Integration flows. This will tremendously help them with complex XLST transformations. Avoiding the need to copy the XSLT and then import it back into the mapper. 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

It is time for the February quarterly update to Oracle Integration. Lilly, the Oracle integration mascot, has lots of exciting new features and improvements to share with you. Note that testing is...

Cloud

On-demand Integration Platform Partner Advisory Council 2020

You missed the 12th edition of the annual global Partner Advisory Council by the Oracle Integration Product Management team? On-demand recordings are available.   Why should watch it? Get the latest product updates and roadmap details from the Oracle Integration Product Management team. Provide feedback based on your customer project experience and discuss with the Oracle team product improvements & future directions. Who should attend? Senior consultants architects, technical leaders & CTOs, who implemented successful Oracle Integration. Keynotes watch here: Andrew Mendelsohn, Executive Vice President, Oracle Data Management Strategy Bryan Thompson, VP of Product Management, Oracle Cloud Infrastructure Day 1 watch here: OIC- Vision and Roadmap and Release Management - Amit Saxena & Team Extreme Scalability and Enhanced Resilience - Antony Reynolds Day 2 watch here: SOA Modernization - Sandhya Lakshmi Gopalan & Ravi Pinto Adapters & Accelerators & Recipes - Michael Meiner API Management – Robert Wunderlich Extend SaaS with Visual Builder Shay Shmeltzer 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

You missed the 12th edition of the annual global Partner Advisory Council by the Oracle Integration Product Management team? On-demand recordings are available.   Why should watch it? Get the latest...

Cloud

Integrate SaaS hands-on Bootcamps Webtraining -South America (Spanish) March 30th – April 1st 2021

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. Schedule: • South America (Spanish) March 30th - April 1st 2021 • Europe Middle East & Africa (English) April 6th - 8th 2021 Get the latest OIC training material here (community membership required). For additional location please visit our website 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

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...

Cloud

Integrate SaaS hands-on Bootcamps Webtraining for Oracle Partners Europe Middle East & Africa (English) April 6th – 8th 2021

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. Schedule: Europe Middle East & Africa (English) April 6th - 8th 2021 For details please visit the registration page 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

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...

Business Process Management

Integration & Process Partner Community Newsletter March 2021

Dear Partner Community In the last 6 month we offered thirteen Oracle Integration Bootcamps for Partners. More than 900 persons attended these 3 days hands-on trainings. More than 2100 persons are on the waiting list, therefor we offer three additional workshops, please see below registration details, in the next months. Thanks for spending your valuable time to become trained and certified. Oracle Integration connects SaaS service like HC, CX and ERP. Pre-build integration adapters accelerate your SaaS implementation and reduce project risk. What is the impact of this huge investment by our partners? 8 of the top 10 Oracle Integration customers are implemented by partners! Congratulations and thanks for your success. Trained and certified consultants implement successful customer projects. Thanks to the community for sharing all the integration articles: Oracle Integration Playground permanent service for Partners free of charge! & Oracle Hospitality Innovation Week March 2021 & APAC Oracle Integration Update Webcast Series & Using FlexDeploy with Oracle Integration Cloud A Customer Success Story & Webinar: The API’s the limit: Why automated integration will see you succeed in the cloud & OIC February 21 Release - New Features & Edit XSLT Source Code in OIC Mapper UI & February 2021 Oracle Integration Fusion Application Adapters Enhancements & An easy way to handle the Oracle ERP Callback when importing data & Linking OCI to ServiceNow via Oracle Integration & Embedding Oracle Integration Insight dashboards : Quickly and Easily & OIC & OCI API Gateway Integration: Quick and Easy & API Gateway Deployment & Reactivate All Integrations Together that Use the Same Connection & Convert from Schedule to REST based integration. In the process & innovation section Daniel Teixeira stared a process automation series. In part one he highlights the Process Cloud Service concepts and how to get started. For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The March edition highlights the hands-on Integration Bootcamp and the Oracle Hospitality Innovation Week. In this month’s community webcast Luis Weir and Niall Commiskey will present how to combine OHIP and Oracle Integration to connect Opera with Oracle SaaS. Please join the Partner Community Webcast March 30th 2021. On-demand webcast recordings are available at the Oracle Video Hub. Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity. To read the newsletter please visit www.bit.ly/PaaSNewsMarch2021 Please like and share the newsletter at Twitter and LinkedIn. 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: newsletter,SOA Community newsletter,SOA Community,Oracle,OPN,Jürgen Kress

Dear Partner Community In the last 6 month we offered thirteen Oracle Integration Bootcamps for Partners. More than 900 persons attended these 3 days hands-on trainings. More than 2100 persons are on...

Business Process Management

Microprocess Consequences by Jan Kettenis

In a previous blog article I introduced the Microprocess Architecture. The article below discusses the consequences of maintaining, managing and running applications that are build according to this architecture. We are applying the Microprocess Architecture to some 4 Dynamic Process applications that are being built with the Oracle Integration Cloud (OIC) for some one and a half year already, but none of them went production so far. We can clearly see the benefits of applying the Microprocess Architecture, but also realize the consequences. I have addressed most of these with some pointers for dealing with them in a follow-up article on the subject. As the go-live date slowly but inevitably is nearing, people obviously start wondering what the consequences regarding maintaining, managing and running such applications mean in the context of OIC. The below discusses this, referring to a “business process” as the main application that is made up by a collection of microprocesses. The following picture shows the core concepts of the Microprocess Architecture in the context of a case application: The case application with its activities is separated from the components that do the "actual work": the microprocesses. The case application does only the choreography and therefore is restricted to rule logic. The microprocesses are relatively small and simple stand-alone process application doing service calls and handling human tasks. 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

In a previous blog article I introduced the Microprocess Architecture. The article below discusses the consequences of maintaining, managing and running applications that are build according to this...

Business Process Management

Archiving and Purging Process Automation Data in Oracle Integration by Arvind Venugopal and Nilakshi Soni

What data is generated by Process in Oracle Integration Large volumes of data are generated during the life of each process instance. This data collected can be broadly divided into two. Instance data and Analytics data. Instance Data:    This is instance specific data generated at each step during execution. It includes the payload, comments, execution and audit information.  Analytics Data:   Additional system metrics and user defined business metrics are also collated and stored at predefined events during the lifecycle of an instance. This data exists independently of the instance data Archive Process data in Oracle Integration Archiving is taking data which is no longer actively used and storing it in an external secondary storage where it can be retained for extended time. This archived data can be accessed, if needed, for compliance, audit, and analytics. Archiving the right data can not only save businesses money, but also intelligence derived using this will add value to the business. The following questions are often asked when users are setting up archive: what all data should be archived, how to setup archiving and finally how to retrieve data from the archived file. The purpose of these blogs is to discuss couple of options which will answer these very questions. When planning an archiving strategy best suited for your needs one must give thought to some basic questions like how often you would need to retrieve data from the archive what data needs to be available for legal and regulatory compliance what data set could be analyzed to add value to the business over time etc. what insights are relevant for your business. 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

What data is generated by Process in Oracle Integration Large volumes of data are generated during the life of each process instance. This data collected can be broadly divided into two. Instance data...

Business Process Management

The Micro Process Feature Making Life Easier by Jan Kettenis

In this article I discuss the Micro Process feature in the Oracle Integration Cloud (OIC). With some price I can take credit for being the name giver of this feature, which makes applying the Microprocess Architecture in OIC a bit simpler. But even when you are not applying that architecture, it still is a feature worth being aware of. A few releases ago the Micro Process feature has been introduced in the Oracle Integration Cloud (OIC). Simply put, it provides a convenience for calling a Structured Process from a different process application. "What a great feature that sounds, why did you not write about it before?", I can hear you thinking. Well, there were a few issues with it which mostly have been fixed since OIC release (20.2.3.0.0 (200705.0200.36413)). That's why. "What is this "Microprocess Architecture?", I hear some others thinking. In short, the Microprocess Architecture is about constructing a process application by having (typically but not necessarily) 1 main process that orchestrates / choreographs activities of which each of them is implemented as separate, decoupled process applications. It is not the same but inspired by many of the solid principles behind the Microservices Architecture, hence the name. When applied to the Oracle Integration Cloud, every activity in the main process is implemented by an (asynchronous) Structured Process called a "Delegator" that does nothing but start some other Structured Process using a Send activity and then wait for the outcome in a Receive activity. There are a few deviations, but basically that's it and what the "Use Micro Process" feature supports. Before this, you as a developer first had to configure the external process as External SOAP Integration and provide the URL to the WSDL (or upload it), and secondly you had to create the Delegator yourself. Now you just point and click and off you go. When using it in a Dynamic Process, a Delegator is automatically created and hidden in the background. Microprocesses are configured from the Processes tab. You select the Structured Process to use from a picklist. Be aware that only Structured Processes are shown from activated Process Applications. For bigger Microprocess applications there can be many of them, so it is good that you can filter them with a Search box. Also mind that it shows Structured Processes from all the default revisions of the Process Applications containing them. 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

In this article I discuss the Micro Process feature in the Oracle Integration Cloud (OIC). With some price I can take credit for being the name giver of this feature, which makes applying the Microproc...

Cloud

Import and Export MDS artifacts in SOA 12c by Pranav Davar

Oracle SOA-MDS (Metadata Store) repository can be used to access artifacts that can be shared among various SOA composites. For example, we have one common schema for a business fault that is consumed by various applications. Instead of having a localized copy of that schema file in each SOA composite, we can have it in a centralized repository (SOA-MDS). Another benefit of using SOA-MDS is that we can change the file at runtime and need not redeploy the complete code. While developing SOA composites, we use SOA design-time repository, later these changes can be synced to the SOA servers. In this article, we will discuss 2 ways to sync the artifacts available in the SOA design-time repository and the SOA servers. Establishing the connection to SOA-MDS in Jdeveloper. Using SOA em console or Fusion Middleware control console. Moving a file between SOA composite to SOA design-time MDS repository Let's assume, we created a businessFault.xsd which will be used by various SOA composites or projects. Before moving this file to the SOA server MDS location, we need to first push it to the SOA design-time repository. 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 SOA-MDS (Metadata Store) repository can be used to access artifacts that can be shared among various SOA composites. For example, we have one common schema for a business fault that is consumed...

Cloud

Create Delimited String from XML Nodes and Vice Versa in SOA 12c by Pranav Davar

A delimited string is a string representation of data separated by a delimiter(e.g. ","). A simple representation of the delimited string will look like. Delimited String Examples Sample-1-- Delimiter as ","     Value1,Value2,Value3  Sample-2-- Delimiter as "|"     Value1|Value2|Value3 If we want to represent the above set of delimited values in the form of an XML document under some root and parent tag. The representation will look like this. XML Example <root xmlns="http://test.com/sample/xml">   <Values>     <value>Value1</value>     <value>Value2</value>     <value>Value3</value>   </Values> </root> Sometimes we may need to convert values coming in delimited string to an xml document or vice versa. Since delimited string is similar to csv format. We can create a nxsd schema and then perform translate i.e. native to xml or xml to native within our SOA application. But in the scenarios wherein we just want to convert one delimited string to xml or recurring xml nodes to one delimited string, there we can make use of oracle xpath extension functions: 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

A delimited string is a string representation of data separated by a delimiter(e.g. ","). A simple representation of the delimited string will look like. Delimited String Examples Sample-1-- Delimiter...

Cloud

Identity Propagation – VBCS > IC > Fusion Apps by Greg Mally

This blog was a collaborative effort between Greg Mally and Mike Muller of the A-Team.  There is an effort under way to provide example assets for this blog and when those assets are available, this blog will be updated with details on how to get to them. One of the big challenges that Oracle Integration Cloud developers face is any outbound REST calls from Integration Cloud (IC) to Fusion Applications (FA) APIs require a user’s identity.  On the surface this seems pretty trivial because the IC REST connections allow for configuring the connection with basic authentication or OAuth 2 JSON Web Token (JWT). However, this configuration is tied to a single user and many use cases/flows require the identity of the person making the FA REST call due to access restrictions, security, auditing, etc. This blog will present a pattern that has been implemented to accomplish identity propagation from a client application, through IC, and to FA. 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

This blog was a collaborative effort between Greg Mally and Mike Muller of the A-Team.  There is an effort under way to provide example assets for this blog and when those assets are available, this...

Cloud

Oracle SOA Modernization – Move and Improve Oracle SOA Suite – Webcast #1 Recap by Pat Shepherd

  We held the first of 2 SOA Modernization webcasts and had a great turnout. I think this slide sums up the key points fairly well: Oracle is still supporting SOA Suite (including a new major release coming up) so your investment is protected You can use BYOL to leverage the license investment you already have in SOA Suite Moving to the Oracle Cloud (OIC) is relatively easy - we have OCS and Partners that can help you with the move We have bi-directional capabilities for OIC to discover and call SOA Suite integrations and Jdeveloper can do the same with OIC Once moved to the Cloud, you benefit from the advantages of OCI as well as the ability to start building new processes and innovating much faster You have the ability to start using new and unmatched services such as Autonomous Database, Blockchain, Digital Assistant, etc... driving even more innovation and creativity. 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

  We held the first of 2 SOA Modernization webcasts and had a great turnout. I think this slide sums up the key points fairly well: Oracle is still supporting SOA Suite (including a new major release...

Invoking Oracle Functions from OIC by Niall Commiskey

Introduction From the Oracle website - Oracle Cloud Functions is a serverless platform that lets developers create, run, and scale applications without managing any infrastructure. Functions integrate with Oracle Cloud Infrastructure, platform services and SaaS applications. Because Functions is based on the open source Fn Project, developers can create applications that can be easily ported to other cloud and on-premises environments. Code based on Functions typically runs for short durations, and customers pay only for the resources they use. These Functions can be written in a variety of languages - Java, Python, Node etc. You write and deploy the code, Oracle takes care of provisioning, scaling etc. Think of blocks of code that generally do one thing, e.g. applying a discount to an order. These are stored as Docker images in a docker registry. They can be executed via CLI or HTTP request. We will be using the latter in our example. So how do Functions enhance the OIC experience?  Here's one use case - Say you are porting SOA Composites to OIC and you make use of Java Embedding in your BPEL process. Where shall I put that code in OIC? 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

Introduction From the Oracle website - Oracle Cloud Functions is a serverless platform that lets developers create, run, and scale applications without managing any infrastructure. Functions integrate...

Cloud

Using Oracle Integration Cloud to integrate SAP & Oracle SaaS by Martijn de Grunt

Oracle Integration Cloud is your one stop shop for application integration and extensibility. It offers a combination of prebuilt connectors to Cloud and on-premises applications for faster  deployment, ready-to-use process automation templates, and an intuitive visual application builder for web and mobile application development. Oracle Integration also includes integration insight dashboards, that give your business users the ability to track business processes as they traverse different applications . This blog post focuses solely on how to integrate SAP legacy apps with Oracle Cloud applications, using Oracle Integration Cloud (OIC). Oracle SaaS and SAP legacy apps, some integration use cases Most organizations have applications from different vendors, so we often see many Oracle Cloud Application customers needing to integrate with an SAP legacy application/module. Here are a few examples - - Connecting Oracle ERP with SAP ECC In cases where organizations are moving from SAP ECC to Oracle ERP, there will probably be a period of co-existence where integrations between Oracle ERP and SAP will be required for jobs such as keeping product lists synchronized between the two applications, etc. - Connecting Oracle HCM Talent Management with SAP Core HR; Customers who are innovating the HCM landscape for specific domains may have Oracle HCM for talent management or recruitment but the single source of truth from an employee directory perspective may exist in SAP. - Connecting Oracle Transportation Management with SAP ECC; There may be companies who are in the process of modernizing their Transportation solution with Oracle Transportation Management, but may still have their main ERP in SAP ECC. 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 Cloud is your one stop shop for application integration and extensibility. It offers a combination of prebuilt connectors to Cloud and on-premises applications for faster ...

Cloud

February 2021 Oracle Integration Update by Antony Reynolds

It is time for the February quarterly update to Oracle Integration. Lilly, the Oracle integration mascot, has lots of exciting new features and improvements to share with you. 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 upgrade notice in the OIC console, so watch out for the date of your upgrade. Remember, you can also mark your Gen 2 instance for update in either the first or second upgrade 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 February is 14 January. Tags added after this date will take effect for the May release. API Led Integration We are making it easier to work with Oracle API products. Previously we supported only Oracle API Platform. We are now building out support for Oracle API Gateway. 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

It is time for the February quarterly update to Oracle Integration. Lilly, the Oracle integration mascot, has lots of exciting new features and improvements to share with you. Note that testing is...

Cloud

Oracle Integration Cloud and Oracle Hospitality Integration Platform: A Match Made in Heaven - Partner Community Webcast March 30th 2021

The Hospitality IT landscape is complex and fragmented. View this session to accelerate your digital transformation with pre-integrated connectivity to Oracle as well as third-party SaaS and on-premises apps, run-ready process automation templates, and an intuitive visual app builder. Topics include: Oracle Integration for Hospitality Oracle Integration demo Learn how to get started Speakers: Luis Weir and Niall Commiskey Schedule: Tuesday March 30th 16:30 – 17:30 CET (Berlin time) For details please visit the registration page here. Take the opportunity to watch our community webcasts on-demand: · Extreme Scalability and Enhanced Resilience for OIC · SOA Modernization · Cloud Native and Serverless SaaS Extensions · How Process Workflow can extend the role of Integration · Innovate Service Cloud with Chatbots · Integration Update & New Features · Chatbot Design best practices for Conversational UX · Connect, Innovate, Extend SaaS KickOff Webcast 2020 · Cloud Platform KickOff Webcast 2020 · Netsuite Integration · Integration Insight · Innovate HCM with Chatbots · ERP Integration with Application Adapters · HCM Integration with Application Adapters · Extend SaaS with Visual Builder Cloud Service · Integration Adapters · Integrate SaaS · Digital Assistant Update · SOA Cloud Service · PaaS Overview Webcast · Process Cloud Service Update · Integrate ERP Cloud · Integrate HCM Cloud · Functions and Cloud Native · Blockchain · API Platform Cloud Service part 2 · 3rd Generation API Gateways part1 · Oracle JET · Oracle Visual Builder Cloud Service · Container Native Application Development Platform For the latest information please visit Community Updates Wiki page (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

The Hospitality IT landscape is complex and fragmented. View this session to accelerate your digital transformation with pre-integrated connectivity to Oracle as well as third-party SaaS and...

Cloud

Integrate SaaS hands-on Bootcamp Webtraining – South America (Portuguese) March 16th 19th 2021

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. Schedule: • South America (Portuguese) March 16th 19th 2021 • South America (Spanish) March 30th - April 1st 2021 • Europe Middle East & Africa (English) April 6th - 8th 2021 Get the latest OIC training material here (community membership required). For additional location please visit our website 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

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...

Business Process Management

Process Cloud Service (PCS) Overview by Surbhi Sharma

This blog is aimed at the beginner who has started to learn Oracle Integration Cloud (OIC) and want to get familiar with Process Cloud Service (PCS). To learn more about Oracle Integration and its sub-parts then check our blog posts, containing all the key points a beginner should know about Oracle Integration Cloud (OIC). What Is Process Cloud Service? Oracle Process Cloud Service is used for process automation, its a subscription-based cloud service for process automation. Allowing you to easily extend your existing SaaS and On-Premise. PCS offers insights and management of business processes, and a full lifecycle process management environment including development, test, and production. Process Cloud Service Overview PCS offers rapid design, automate, and manage business processes in the cloud. It utilizes two work environments the design-time environment used for developing and testing applications, and the runtime environment used for monitoring process applications. Design-Time Environment: User-friendly UI for designing process, rules, forms, data, and metrics Includes QuickStart Apps to quickly create custom business applications Provides test environments for refining and testing processes Allows process applications (metadata and data) from cloud to on-premises The Runtime Environment: Makes it easy for you to view, complete, reassign, and delegate tasks Lets you stay organized with filters Lets you share documents and collaborate with others on your team Provides tools to track process flows, view detailed audit trails, troubleshoot, and fix processes The design-time environment is also called Composer, and the runtime environment is also called the Workspace. The terms design time and Composer, and runtime and Workspace are used interchangeably throughout this guide. PCS Composer Page When you click Develop Processes on the Home page, the Composer page opens. The Composer page is a core component of the design-time environment. It provides access to common application-related features. When you sign in for the first time, the system automatically creates a default space called My Space which will be used for creating the process. 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

This blog is aimed at the beginner who has started to learn Oracle Integration Cloud (OIC) and want to get familiar with Process Cloud Service (PCS). To learn more about Oracle Integration and its...

Cloud

OIC - Oracle Field Service via REST by Niall Commiskey

Yes, there is an Oracle Field Service Adapter in OIC and yes, it provides compelling functionality in respect of common use cases, such as the one described in the OFS adapter documentation - This scenario describes the interaction between the Oracle Field Service and an application that receives and processes alerts for municipal services. • A municipal employee receives an alert on the municipal services monitoring application indicating that there is a natural gas leak near a busy downtown intersection. • The municipal employee creates a work order to dispatch a service team to the site. All details necessary to locate the natural gas leak are included in the work order. • The municipal employee saves and submits the work order on the municipal services monitoring application. • The work order is sent to the Oracle Field Service Adapter. • The Oracle Field Service Adapter creates a matching activity in Oracle Field Service and returns the activity identifier to the municipal services monitoring application to allow the progress of the work order to be monitored. 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

Yes, there is an Oracle Field Service Adapter in OIC and yes, it provides compelling functionality in respect of common use cases, such as the one described in the OFS adapter documentation -...

NetSuite Integration Series: Part 2: Keep data in Sync between Oracle CX Sales (Engagement Cloud) and NetSuite by Naveen Nahata

Introduction: The purpose of this post is to introduce readers to the realtime integration between Oracle CX Sales (formerly Engagement Cloud or Sales Cloud) and NetSuite. We explore how to keep customers in sync between Oracle CX Sales and NetSuite when CX Sales is the source of truth. We will build this integration using Oracle Integration Cloud (OIC), which is an offering that helps customers build and orchestrate complex integrations between various systems. The same principal can be applied to objects other than the Customer and to certain objects in Oracle ERP Cloud which support Business Events - triggers which notify OIC whenever an object is changed (Created, Updated, Deleted) One of the challenge in syncing data between the two systems is that each system has it's own primary identifier and mapping the two requires some way to store cross-reference - which ID in System 1 maps to which ID in System 2 We will explore how this problem can be solved easily in NetSuite using a concept called External ID. Main Article: We will build 2 integrations: 1. When a customer is created in Oracle CX Sales, it will be created in NetSuite 2. When a customer is updated in Oracle CX Sales, it will be UPSERTed in NetSuite. An UPSERT operation is an attempt to make an update to a record. If the record does not exist, then it will be created. This scenario can happen if a record gets created in Oracle CX Sales and is not sync'ed to NetSuite. We use the UPSERT operation to ensure subsequent updates to that record propagate to NetSuite. 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

Introduction: The purpose of this post is to introduce readers to the realtime integration between Oracle CX Sales (formerly Engagement Cloud or Sales Cloud) and NetSuite. We explore how to keep...

Cloud

Diagnostic logging ‘events’ and benefits of decoupled log-processors by Jang-Vijay Singh

The implementation of  good logging frameworks is typically asynchronous for good reason: background processing involved in logging activities must not cause an overhead in the main flow. Even the simplest action like writing the output to a log file is implemented behind the scenes in separate threads.    From a log analysis and diagnostics point of view, this is not a problem as each log entry includes a timestamp that shows the instant when the log entry was requested (rather than the time it was actually written to a log file) The same principle applies when we use more complex technologies like the Oracle Service Bus and Oracle Integration Cloud (OIC). Each offers dedicated log activities that write to *-diagnostic.log files or the OIC activity stream. Customer Requests More than once, I came across some customer requests where they proposed writing dedicated services to perform something more complex than just writing to log files or activity streams. Customer would perhaps expect structured log entries in a specific format to be published to some queue or persisted to some big-data store. It is proposed that such a dedicated services/API's that would then be called by each integration flow or process at different points like entry, exit, and error catch blocks. However this has two clear drawbacks: 1) It involves a design-time and development time overhead where this new custom 'logging API' would be called by each integration flow (we then need to worry about its availability and error handling in addition to the actual real services we need to worry about). 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

The implementation of  good logging frameworks is typically asynchronousfor good reason: background processing involved in logging activities must not cause an overhead in the main flow. Even...

Cloud

Oracle Hospitality Innovation Week March 22nd - 25th 2021

Accelerating Innovation for the New Next with Innovation Week 2021. Register today for our live and on-demand digital events and attend a series of virtual events and webinars. The online offering invites partners to join Oracle integration experts for an unprecedented dialogue: to explore the best ideas for hospitality solutions and find pathways to make them a reality. Oracle Integration Cloud and OHIP: A Match Made in Heaven The Hospitality IT landscape is complex and fragmented. View this session to accelerate your digital transformation with pre-integrated connectivity to Oracle as well as third-party SaaS and on-premises apps, run-ready process automation templates, and an intuitive visual app builder. Topics include: Oracle Integration for Hospitality Oracle Integration demo Learn how to get started Speakers: Niall Commiskey, Luis Weir & Jürgen Kress Schedule: March 23rd 2021 For details please visit the registration page 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

Accelerating Innovation for the New Next with Innovation Week 2021. Register today for our live and on-demand digital events and attend a series of virtual events and webinars. The online offering...

Cloud

How to Invoke an OCI Function from the Oracle Integration Cloud by Daniel Martins Teixeira

The Oracle Cloud Infrastructure (OCI) offers a great set of services that can be very useful in combination with Oracle Integration Cloud (OIC) for a wide variety of use cases. Things like the Object Storage, Oracle Streaming Service, Functions etc, can easily be accessed from OIC. The OCI ecosystem has a rich set of API’s that can be used for that purpose - https://docs.cloud.oracle.com/en-us/iaas/api/#/ In this post I am going to show how to deploy a Function, and how to Invoke it from OIC. What are Functions “Oracle Functions is based on Fn Project. Fn Project is an open source, container native, serverless platform that can be run anywhere, It’s easy to use, supports every programming language, and is extensible and performant.” How to Start There is extended documentation and plenty of blogs & tutorials that provide a comprehensive deep dive into OCI , Docker Images and Functions etc. Being this an Integration Blog, we will focus on the OIC side of things, while providing some tutorials on how to setup an OCI Function. If you already have a deployed Function, you can skip the next section. 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

The Oracle Cloud Infrastructure (OCI) offers a great set of services that can be very useful in combination with Oracle Integration Cloud (OIC) for a wide variety of use cases. Things like the Object...

Business Process Management

Integration & Process Partner Community Newsletter February 2021

Dear Partner Community The quarterly Oracle Integration upgrade is released in February. New functionality include API lead integration. SaaS consultants use pre-build adapters to connect while Developers integrate custom build applications via APIs. Now it’s easier to combine OIC with API gateway. The OIC release also includes productivity enhancements and connectivity enhancements. Antony published the release details here, and join the webcast with him on February 23rd 2021. Thanks to the community for sharing all the integration articles: Oracle Integration Playground permanent service for Partners free of charge! & & Explore and Design Patterns and Best Practices & Integrate and Modernize Applications to Rapidly Advance your Business on-demand webinar & OIC and Oracle Hospitality (OHIP) & API Gateway Integration: Quick and Easy & Protecting your OIC apis with OCI API Gateway & B2B Trading Partner Management & Automatic reactivation of Integration after a connection update & Invoke BI Report in OIC &Read BI Report base64 encoded response & Embedding Oracle Integration Insight dashboards : Quickly and Easily & Replace Trigger in Orchestration & Unlock new patterns of integration by controlling the HTTP Response status in OIC REST based integrations & Simple Fusion ERP - OIC Demo & Identity Propagation - VBCS > IC > Fusion Apps JSON Obfuscation & FTP Polling using FTP JCA adapter in OSB 12c & Get away with that paper using SOA Suite and E-Post/Docuguide & Cut the Clutter: SOA Upgrade from 12.2.1.x to 12.2.1.4. In the process & innovation section Mani published an article about unified task lists for Oracle applications and Niall about process archiving. Want to know what’s coming for Enterprise Blockchain? Read the 2021 vision from Mark. For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The February edition highlights the OIC February Update and the Oracle Video Hub. In this month’s community webcast Antony Reynolds will present an update on Oracle Integration Scalability and Resilience. Please join the Partner Community Webcast on February 23rd 2021. On-demand webcast recordings are available at the Oracle Video Hub. Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity. To read the newsletter please visit www.bit.ly/PaaSNewsFebruary2021 Please like and share the newsletter at Twitter and LinkedIn. 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: newsletter,SOA Community newsletter,SOA Community,Oracle,OPN,Jürgen Kress

Dear Partner Community The quarterly Oracle Integration upgrade is released in February. New functionality include API lead integration. SaaS consultants use pre-build adapters to connect while...

Cloud

Recover unsaved changes for an Integration edit session by Vijay Kendai

This blog is for a new feature coming out in Oracle Integration Cloud (OIC) November release. Due to many unforeseen circumstances, integration developers can lose their work while editing integrations. Lost work may be as a result of browser crashing, losing network connectivity, server going down etc.  Depending on the state of the edited integration, the loss of the work can range from minimal changes to complicated mappings and transformations between applications.  This blog describes how the integration developer can recover the lost changes. What is recovered? · Changes made by the integration developer after fully completing an action. For Example, o If the developer is adding an Invoke action, it is considered complete only after the developer completes the configuration and clicks the Done button on the Summary page and returns to the canvas. o If the developer is adding a Logger action, it is considered complete only after the developer clicks the Close button on the Configure Logger page and returns to the canvas. 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

This blog is for a new feature coming out in Oracle Integration Cloud (OIC) November release. Due to many unforeseen circumstances, integration developers can lose their work while editing...

Cloud

Oracle Integration: ICS to OIC Migration with transition to ATP by Michael Meiner

Overview Oracle Integration (OIC)  has a rich set of capabilities to enable our customers to connect to Oracle databases including on-premise databases and Cloud (DbaaS, ATP). We continue to enhance Oracle Integration to provide additional database connectivity functionality. In the November 2020 release, Oracle Integration offers new functionality for transitioning to an ATP database. This can be especially important when migrating from Integration Cloud Service (ICS) to Oracle Integration (OIC). As OIC runs on Oracle Cloud Infrastructure (OCI), you might want to also take advantage of ATP which is available in OCI. ICS integration flows which integrate with Oracle Database as a Service (DBaaS) typically use the Database adapter. When migrating such integrations to OIC, the Database adapter will appear in the migrated integrations. This makes uptake of ATP cumbersome, as each integration flow would need to be hand-modified to replace the Database adapter with the ATP adapter. Integration of ATP using the Database Adapter In the Oracle Integration November release, it is now possible to integrate such existing integrations with ATP. In prior releases, the only connection option available with the Database adapter was username password token. This security option is not supported by ATP-Serverless. In the November release, there is an additional connectivity option for Oracle Wallet. You can use this option to connect with ATP-Serverless. This allows you to seamlessly replace the DBaaS connections from ICS with ATP-Serverless connections for use with OIC. There is no need to modify the integrations, just update the connection information including the connectivity agent and you're ready to use ATP! This is all made possible by the Oracle Wallet option in the Database adapter. See below for this new security option  in the Oracle Database connection. 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

Overview Oracle Integration (OIC)  has a rich set of capabilities to enable our customers to connect to Oracle databases including on-premise databases and Cloud (DbaaS, ATP). We continue to...

Cloud

A Simple Guide to ERP Cloud Customer Creation through integration by Bala Mahalingam

Introduction Customer information is the foundational data for any enterprise. Definition of a Customer object is a crucial one in the Oracle ERP Cloud implementation.  Typical use cases for customer creation in Oracle ERP Cloud are: Users creating customer information through application user interface Users creating / updating customer information through spreadsheets Integration with another cloud / on-premise application Initial data load of customer records from legacy applications This blog is focused on integration use case (3) and provide you an overview of creating customer record in ERP Cloud leveraging new REST API’s available in release 20D and SOAP services. If you are implementing ERP Cloud and Sales Cloud you need to plan your customer on-boarding process based on your business requirements. One of my blogs on customer data definition guidelines can help you to model your customer in Oracle Fusion Applications cloud. For example, you could start with Prospect in Sales Cloud, and promote it to customer in your sales process, and that customer record will be automatically available in ERP Cloud. ERP Cloud requirement will be just to create Customer Account. 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

Introduction Customer information is the foundational data for any enterprise. Definition of a Customer object is a crucial one in the Oracle ERP Cloud implementation.  Typical use cases for customer...

Cloud

Extreme Scalability and Enhanced Resilience for Oracle Integration - Partner Community Webcast February 23rd 2021

Learn how Oracle Integration can scale to support the most demanding applications and discover what the future holds for performance and scalability in OIC. We will discuss a customer who reached 1m messages an hour and talk about how future enhancements will allow even higher throughput. We will also discuss how to meet business continuance requirements by using a customer managed DR solution and talk about existing high availability in OIC.   Speaker: Antony Reynolds Schedule: Tuesday February 23rd 16:30 – 17:30 CET (Berlin time) For details please visit the registration page here. Take the opportunity to watch our community webcasts on-demand: · SOA Modernization · Cloud Native and Serverless SaaS Extensions · How Process Workflow can extend the role of Integration · Innovate Service Cloud with Chatbots · Integration Update & New Features · Chatbot Design best practices for Conversational UX · Connect, Innovate, Extend SaaS KickOff Webcast 2020 · Cloud Platform KickOff Webcast 2020 · Netsuite Integration · Integration Insight · Innovate HCM with Chatbots · ERP Integration with Application Adapters · HCM Integration with Application Adapters · Extend SaaS with Visual Builder Cloud Service · Integration Adapters · Integrate SaaS · Digital Assistant Update · SOA Cloud Service · PaaS Overview Webcast · Process Cloud Service Update · Integrate ERP Cloud · Integrate HCM Cloud · Functions and Cloud Native · Blockchain · API Platform Cloud Service part 2 · 3rd Generation API Gateways part1 · Oracle JET · Oracle Visual Builder Cloud Service · Container Native Application Development Platform For the latest information please visit Community Updates Wiki page (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

Learn how Oracle Integration can scale to support the most demanding applications and discover what the future holds for performance and scalability in OIC. We will discuss a customer who reached 1m...

Cloud

Oracle Integration (OIC) – a holistic view by Niall Commiskey

  The focus of my posts is usually on the Integration component of OIC. But sometimes it's better to emerge from the details and take a more holistic view of what is on offer. I may be preaching to the converted, but just in case... OIC is THE toolkit for connecting your apps, extending your apps, creating net new apps/mashups on top of your app apis and, finally, providing insight into your business processes Let's start from the bottom up - OIC runs natively on Oracle Cloud Infrastructure (OCI). It's one of many services that does so. Others, such as the one's I have listed above may be very useful from an OIC perspective, e.g. processing streaming data from the OCI Streaming Service. OIC already has an OCI Streaming Adapter. What about event driven scenarios? The OCI Events Service can respond to resource changes in your tenancy. Orchestration business logic can be implemented in Oracle's Functions as a Service platform. This is a big value add in respect to our competitors. Please note the OCI Services list in my slide is not exhaustive, other services such as OCI Logging are not listed, purely for space reasons. Next level - a couple of months ago we released the File Server component. Now you have your own sftp conform server within your OIC environment. Currently you have an allocation of 500GB of space for processing / storing your files. Leveraging File Server is a no-brainer, considering how many ERP and HCM integrations are still file based. 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

  The focus of my posts is usually on the Integration component of OIC. But sometimes it's better to emerge from the details and take a more holistic view of what is on offer. I may be preaching to the...

Cloud

Oracle Integration Update for Technical Adapters by Prakash Masand

Overview Oracle Integration has rich capabilities for connecting with diverse technical end points may it be service / API based like SOAP and REST or messaging based like Kafka and JMS or database management system like ADW, ATP etc. OIC supports wide array of technical adapters enabling customers to connect, integrate and reap advantages of core digital technologies in their business processes. Oracle Integration continues to improve the technical adapters capabilities further empowering customers in their digital transformation journey. In November 2020 update we are pleased to announce following updates to the technology adapters: REST Adapter Improvements Oracle Integration REST adapter is a versatile adapter helping customers to communicate with wide array of products & services like Oracle Functions, OCI Object storage, AWS S3 etc, proving to be a one of the cornerstone adapters for customers modern integration solutions. In the conquest of further empowering the customers, Oracle Integration has been further enhanced the REST adapter with following capabilities. 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

Overview Oracle Integration has rich capabilities for connecting with diverse technical end points may it be service / API based like SOAP and REST or messaging based like Kafka and JMS or...

Cloud

SOA Suite Modernization Partner Community Webcast on-demand

SOA Suite Modernization Come to this session to learn about how you can modernize your SOA Suite estate while maintaining the value of your investment. You will learn about: Oracle’s commitment and roadmap for SOA Options you have for moving your SOA to the cloud Modernize your integration ecosystem with services like Oracle Integration, Digital Assistant and Autonomous DB We will have Oracle Integration PMs on the call to provide you the strategic direction Oracle’s integration platform and recommendations for how to approach modernizing your SOA. You will learn why Oracle is best positioned to help you lower costs, increase your agility, and help you build out your Digital Platform for Digital Resilience which is more important now than ever. Watch the webinar on-demand here   Resources: On-Demand Webcast YouTube Presentation in pdf format Presentation in ppt format (membership required) Integration Partner Community Join the Slack channel Integration Playground Oracle Integration Website You can also watch the recorded webinar by clicking on the link below: • ERP Integration with Application Adapters • HCM Integration with Application Adapters • Netsuite Integration with Application Adapters • Integration Update & New Features • How Process Workflow can extend the role of Integration • Connect, Innovate, Extend SaaS Kickoff Webcast • Cloud Platform Kickoff Webcast 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

SOA Suite Modernization Come to this session to learn about how you can modernize your SOA Suite estate while maintaining the value of your investment. You will learn about: Oracle’s commitment and roadm...

Business Process Management

Business Process Automation using Oracle Process Cloud Service by Lalitha Selvaraj

Why do we need Process Cloud Service? Oracle Process Cloud Service lets you automate business processes in the cloud. A business flow can be created through PCS which goes through multiple/single approval process and can also send email notifications for single/multiple users through mail to approve or reject the process flows through online. Turn your company’s specific processes into process applications by creating process models that includes requests, approvals, decision paths and roles for each task. Process cloud mainly used for Healthcare to improve patient care. Endless forms with personal details, medical history, medical tests, diagnoses and treatments. Not only it is difficult to collect patient form data, save and manage these databases, but it’s also difficult to quickly access them. PCS enables you to configure and customize emails sent as notifications to human workflow task assignee's (the default email notification is too basic, containing only a link to the Workspace app). You can create your own email templates that can include payload information, task information, links and comments. Integrating Oracle Process Cloud service with Oracle Integration Cloud Service: Integrating Oracle Process Cloud Service with Oracle Integration Cloud Service which uses REST service to fetch the data from on-premise applications or cloud applications. Process applications can communicate and exchange data with local and remote applications that are exposed as either SOAP or REST. The ICS Integration is available for use from any service task. Using the known Data Association feature, you can map a data object to either hold the information that you want to send to the ICS or hold the information sent back by the ICS. 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

Why do we need Process Cloud Service? Oracle Process Cloud Service lets you automate business processes in the cloud. A business flow can be created through PCS which goes through multiple/single...

Cloud

Try Our Advanced Filtering in Process Forms by Kalyn Chang

We have recently added more powerful filtering functionalities in Forms. Previously, you were limited to combining filter conditions with Or logic only, and you couldn't filter existing filters further. Additionally, we have expanded our logging capabilities so users can see the return values of filters. Now you can: · Combine filter conditions with and logic · Filter other filters · Debug Filters with Logs Combine Filter Conditions with And Logic When defining a filter, you can define any number of filter conditions. For example, if you have a connector call for employees at a company, you can filter the employees based on their zip code, level, or any other property in the employee json object. Previously, you could only combine filter conditions with or logic. For example, you can filter the employees with direct reports or who work at the company's California office. Now, you can combine filters with and logic. For example, you can filter the employees with direct reports and who work at the company's California office. Adding the and logic opens up many more combinations of filter conditions. 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

We have recently added more powerful filtering functionalities in Forms. Previously, you were limited to combining filter conditions with Or logic only, and you couldn't filter existing filters...

Cloud

Announcing Oracle SOA Suite on Containers & Kubernetes for Production Workloads by Ravi Pinto

The Oracle SOA Suite Team is thrilled to announce the general availability of Oracle SOA Suite on Containers and Kubernetes for Production environments. This is a culmination of a tremendous effort backed by customer feedback in the early access phase. Scope As part of the first release version 20.3.3, we are making available the following: Container images for Oracle SOA Suite 12.2.1.4 including Oracle Service Bus on MOS patch 31966923 (Production) and container-registry.oracle.com (Dev & Test) Sample scripts on Github Documentation related to the following Installation and configuration of a new SOA Instance. Monitoring and management of the instance, configuration of Load Balancers, SSL Certificates etc. Patching and upgrading the instance. Steps on configuring a development environment to work with the instance. Initial release certifies the domain types of following components Oracle SOA Oracle Service Bus Oracle Enterprise Scheduler 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

The Oracle SOA Suite Team is thrilled to announce the general availability of Oracle SOA Suite on Containers and Kubernetes for Production environments. This is a culmination of a tremendous effort...

Cloud

Integration & Process Partner Community Newsletter January 2021

Dear Partner Community Every day we publish a blog post with the latest integration and process automation news. Subscribe to our blog to receive the updates. You want to share your best practices and success stories? Please send them via twitter #PaaSCommunity. We will like and retweet and promote them here in our monthly newsletter. Thanks for all your excellent contributions in 2021! In total we had 161.096 views in 2020. Congratulations to the top blog post in 2020: 1. Change date time format in Oracle Integration Cloud by Ankur Jain 2. Oracle Fusion Middleware 12c (12.2.1.4.0) Released 3. Oracle SOA Suite on Kubernetes by Michel Schildmeijer The quarterly release Oracle Integration Update February 2021 features API led integration, connectivity and developer productivity enhancements. OIC accelerates SaaS connectivity with pre-build adapters for Oracle SaaS like HCM, ERP and CX. Additional OIC offers pre-build third party adapters e.g. for SAP integration. Thanks to the community for sharing all the integration articles: Oracle Integration Playground permanent service for Partners free of charge! & Insight --> embeddable Dashboards & Protecting your OIC apis with OCI API Gateway & OIC Backups & Invoking Oracle Functions from OIC & Data Stitch Append for Complex Content Elements & Twilio Adapter - send SMS / WhatsApp from Oracle Integration & Oracle SOA Modernization - Move and Improve Oracle SOA Suite - Webcast #1 Recap & New Release of Oracle SOA Suite Docker Image & On-demand Webinar: Maximize the Potential of Oracle Integration Cloud with FlexDeploy & Identity Propagation - VBCS > IC > Fusion Apps by Greg Mally & Create Delimited String from XML Nodes and Vice Versa in SOA 12c & Import and Export MDS artifacts in SOA 12c. In the process & innovation section Jan published a micro process article and the consequences of this new architecture. Large volumes of data are generated during the life of each process instance. This data needs to be archived and purged. For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The January edition highlights the top 2020 blog posts and our social media channels. In this month’s community webcast Sandhya Lakshmi Gopalan and Ravi Pinto Angelo Santagata will present and update on Oracle SOA Suite. Please join the SOA Suite Modernization Partner Community Webcast January 27th 2021. Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity. To read the newsletter please visit www.tinyurl.com/PaaSNewsJanuary2021 Please like and share the newsletter at Twitter and LinkedIn. 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: newsletter,SOA Community newsletter,SOA Community,Oracle,OPN,Jürgen Kress

Dear Partner Community Every day we publish a blog post with the latest integration and process automation news. Subscribe to our blog to receive the updates. You want to share your best practices and...

Cloud

Integration, Process & Insight – Netsuite Data Sync Use Case by Niall Commiskey

OIC is a toolkit - 4 main tools: · Integration - connect your apps · Process - intelligent human workflows - can be used to extend apps or for your own custom processes. · Insight - analyze what's going on in Integration and Process, but this from a business user perspective. More details below. · Visual Builder - create net new apps on top of your apis. For those who haven't seen Insight before - the OraDocs provide the following succinct description of what it offers - Integration Insight in Oracle Integration provides a business-friendly experience, allowing users to model, collect, and monitor business-level metrics using web-based dashboards. Integration Insight works with business processes that are implemented using the Integrations or Processes features in Oracle Integration. At a high level, Integration Insight provides:• A web-based interface to: – Model business processes, including milestones – Map models to a business processes implementation – Monitor business progress through dashboards • Efficient workflow requiring no development effort and minimal impact to runtime. • Advanced analytics presented in both preconfigured and custom dashboards. The following example leverages 3 of the OIC tools - Integration, Process and Insight in the context of a Netsuite data synchronisation use case. Please see my previous post here, for details of leveraging Visual Builder on top of Netsuite. 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

OIC is a toolkit - 4 main tools: · Integration - connect your apps · Process - intelligent human workflows - can be used to extend apps or for your own custom processes. · Insight - analyze what's going...

Cloud

SOA Suite Modernization Partner Community Webcast January 27th 2021

Oracle SOA Suite Modernization Come to this session to learn about how you can modernize your SOA Suite estate while maintaining the value of your investment. You will learn about: Oracle’s commitment and roadmap for SOA Options you have for moving your SOA to the cloud Modernize your integration ecosystem with services like Oracle Integration, Digital Assistant and Autonomous DB We will have Oracle Integration PMs on the call to provide you the strategic direction Oracle’s integration platform and recommendations for how to approach modernizing your SOA. You will learn why Oracle is best positioned to help you lower costs, increase your agility, and help you build out your Digital Platform for Digital Resilience which is more important now than ever. Schedule:  January 27, 2021 16:30 - 17:30 CET (Berlin Time) Featured speakers: Sandhya Lakshmi Gopalan Senior Product Manager Oracle HQ LinkedIn Ravi Pinto Director Product Management Oracle HQ LinkedIn   For details please visit the registration page here. For more information watch our free on-demand webcasts: • Integration Update & New Features • ERP Integration with Application Adapters • HCM Integration with Application Adapters • Connect, Innovate, Extend SaaS Kickoff Webcast • Cloud Platform Kickoff Webcast 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 SOA Suite Modernization Come to this session to learn about how you can modernize your SOA Suite estate while maintaining the value of your investment. You will learn about: Oracle’s commitment...

Cloud

Automating, Migrating and Upgrading Oracle eBusiness Suite R12 into the Cloud–Webcast February 11th 2021

Discover how to transform your Finance Team by migrating, upgrading, and enhancing Oracle eBusiness Suite with automation and utilising the cloud to realise the full potential and power of your application. Join the experts from Arcivate and Data Intensity for a webinar on upgrading and migrating Oracle E-Business Suite to the cloud. You'll also discover how to realise further efficiencies by automating your supplier invoice processes which will truly empower you to transform the way your Finance team operates. Join us on the 11th February at 11:00am GMT  In this webinar, we will explain how upgrading and migrating eBusiness Suite to the Cloud and enhancing with automation can optimise your end-to-end processes to deliver on key business objectives. Data Intensity will cover the challenges you face in moving to the cloud by identifying the right cloud technologies to deliver faster time-to-value, reduced costs, and a predictable path to achieve your business outcomes. Arcivate will demonstrate automation of the Accounts Payable data entry process with its Mi Invoices SaaS solution and the business benefits of automated invoice processing, including lowering costs and minimising manual inputs. For details please visit the registration page here.  Additional webinars are available here and on-demand webinars 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

Discover how to transform your Finance Team by migrating, upgrading, and enhancing Oracle eBusiness Suite with automation and utilising the cloud to realise the full potential and power of...

Cloud

A Simple Guide to Oracle HCM Data Loader (HDL) Job Support in Oracle HCM Cloud Adapter by Prakash Masand, and Asawari Pawar

Oracle Integration continues to simplify integrations with Oracle HCM Cloud by adding native support to more and more Oracle HCM integration touch points. Oracle Integration now supports 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. To learn more about Oracle HDL jobs, refer to this blog. The Oracle HCM Cloud Adapter in Oracle Integration simplifies the way an integration specialist invokes an Oracle HDL job process and monitors the status of the job. The Oracle HDL job can load data into business object from delimited data (.dat) files. Integration architect can generate the delimited data files in Oracle Integration using business object template files provided by Oracle HCM Cloud. 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 continues to simplify integrations with Oracle HCM Cloud by adding native support to more and more Oracle HCM integration touch points. Oracle Integration now supports Oracle HCM...

Cloud

Security Improvements for Database & FTP Adapters by Michael Meiner

Overview Oracle Integration (OIC)  has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration to provide additional security settings and functionality. In the November 2020 release, Oracle Integration offers new security-related functionality for the Database and FTP adapters. The features discussed here include: Integration with ATP Serverless configured with Private Endpoint Support for Wallet based authentication with privately hosted databases Automatic Database Wallet and Password refresh Message payload security capabilities with privately hosted SFTP servers Two of these features involve use of the Oracle Integration Connectivity Agent. Using the connectivity agent, you can create hybrid integrations and exchange messages between applications in private or on-premises networks and Oracle Integration. 1. Integration with ATP Serverless configured with Private Endpoint Autonomous Database (ATP) is becoming more widely adopted, along with its use within integration flows using OIC. When configuring your Autonomous Database, you can specify that it use a private endpoint within your VCN in your tenancy. This allows you to keep all traffic to and from your Autonomous Database off of the public internet. When using the ATP adapter in Oracle Integration to connect to an ATP instance using a private endpoint, you need to set up the connectivity agent. Inside the connection details for the ATP adapter, there are 2 options for security: JDBC Basic Authentication and JDBC over SSL. When selecting JDBC over SSL, you are prompted to enter the wallet and wallet password. Prior releases of Oracle Integration do not allow you to use the JDBC over SSL (wallet) option with the connectivity agent. In addition, Username-token policy is not supported by ATP Serverless, This means that there were no options for integrating OIC with ATP-S with the connectivity agent. 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

Overview Oracle Integration (OIC)  has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration...

Cloud

Read ZIP files in Oracle Integration Cloud by Ankur Jain

We all know the capabilities of Oracle Integration Cloud FTP adapter of reading and writing files. There are situations where the files are in the zip format and required to read the zip files, parse each and every file under the zip file and send the data into the downstream applications. In the article, we will explain how to read ZIP file from FTP location and push the content of each file under the zip file into the Oracle database. Download the zip file from here. This zip file contains three CSV file in the below format Below are some pre-requisites which are required to execute this use case: Oracle Integration Cloud instance subscription. If  you don’t have please subscribe for the free trial from here FTP which should be accessible publicly Oracle Database OIC agent should be up and running Download the SQL script from here. Run these script which will create a table USER_MASTER table and a package UserPKG along with one procedure AddUser Let’s start and achieve the use case: 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

We all know the capabilities of Oracle Integration Cloud FTP adapter of reading and writing files. There are situations where the files are in the zip format and required to read the zip files, parse...

Cloud

How to use the OCI Object Storage from the Oracle Integration Cloud by Daniel Martins Teixeira

The Oracle Cloud Infrastructure (OCI) offers a great set of services that can be very useful in combination with the Oracle Integration Cloud (OIC) for a wide variety of use cases. Things like the Object Storage, Oracle Streaming Service, Functions etc, can easily be accessed from OIC. The OCI ecosystem has a rich set of API’s that can be used for that purpose - https://docs.cloud.oracle.com/en-us/iaas/api/#/ In this post I am going to show how to create a file in the Oracle Object Storage. What is the Object Storage “The Oracle Cloud Infrastructure Object Storage service is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability. The Object Storage service can store an unlimited amount of unstructured data of any content type, including analytic data and rich content, like images and videos.” Traditional integration use cases rely heavily on File Servers and SFTP access as an harbour for files. Object Storage and similar services are picking up fast in replacing them. We see more and more customers leveraging the benefits of these services for the handling of all different types of content that need to be stored and moved. How to Start Before jumping to the Integration Cloud, we need to create an object storage bucket and we need API signing keys. 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

The Oracle Cloud Infrastructure (OCI) offers a great set of services that can be very useful in combination with the Oracle Integration Cloud (OIC) for a wide variety of use cases. Things like the...

Cloud

Oracle Integration – Adapter Enhancements to Non Oracle Applications by Arvind Venugopal

Overview Oracle Integration (OIC) has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration to provide additional enhancements and features on existing Application Adapters. In the November 2020 release, Oracle Integration added the following capabilities to third party application adapters: Salesforce Adapter:  Enablement for Salesforce Government Cloud Customers ServiceNow Adapter: Graceful downgrade of User Experience PayPal Adapter Inbound Support and New Modules Shopify Adapter New Modules Salesforce Adapter:  Enablement for Salesforce Government Cloud Customers In the recent past, the Salesforce Adapter was enhanced with the elimination of the need to upload the enterprise WSDL on the Connections page. With this enhancement the customers, who were using the Salesforce Government Cloud, were unable to create new connections due to login considerations as mentioned in this help document. With the November release, the Salesforce Adapter provides support to create a connection of the Salesforce.com application that can integrate with Salesforce Government Cloud. You simply need to select the target Salesforce instance type as Government and provide your custom domain name and API version on the Connections page. So let's start with a quick tour of the new field on the Connection page: 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

Overview Oracle Integration (OIC) has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration...