Using Integration flows with File Transfers by Michael Meiner

image

Oracle Integration (OIC) eliminates barriers between business applications through a combination of machine learning, embedded best-practice guidance, pre-built integration and process automation. Integration Cloud provides the means for integrating applications, automating processes and building applications visually. Integration Cloud can also consume, produce, and perform transformations, on files.

For use cases where an sftp server is needed, Integration Cloud can be coupled with Oracle Managed File Transfer (MFTCS) Cloud Service to build and end-to-end solution. MFTCS has an embedded sftp server, along with features not available in traditional sftp solutions. For instance, MFTCS can integrate with other endpoints including: SOAP, Storage Service, ODI, B2B and WebCenter.

When provisioning OIC and MFTCS, you’ll want to provision them in the same Oracle datacenter for maximum performance.

Use Case

In our use case, we perform a bulk data import of external transactions into ERP cloud.  We introduce the following marketing personas: Mary is responsible for Customer Relationship Management (CRM) in Oracle EBS. We also introduce Bob, responsible for Enterprise Resource Planning (ERP) in Oracle Fusion ERP. Mary and Bob need these systems to sync automatically, without human intervention. EBS will be generating content that needs to be consumed by ERP.

The demonstration uses Oracle’s cloud integration capabilities to automate the bulk data import process. A .csv file of transaction records is transferred to an SFTP server (i.e., MFTCS), where it is picked up and processed by the Integration Cloud. If necessary, the integration flow can add additional data to the inbound transactions prior to passing the data off to ERP 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.

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

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

Change date time format in Oracle Integration Cloud by Ankur Jain

image

We got a request from multiple folks saying they are struggling to change the date time format in Oracle Integration Cloud.

We are writing this article to see how to change the default date format(2019-04-13T05:09:05.049+00:00) to a different format.

Oracle Integration Cloud Service provides an Out of the box function(xp20:format-dateTime) which allows us to change the date time format. We are on ICS version (18.4.3.0.3) and the function is available(xp20:format-dateTime). Let us see how to apply this function and change the date format as per the requirement. The function(xp20:format-dateTime) takes below two arguments:

  1. dateTime: Provide the DateTime input parameter as a string which needs to be the format
  2. Format: Provide the format as a string as per the requirement

Example-1: Parse the date time in the format “dd-MM-yyyy“, below will be the syntax: Read the complete article here.

PaaS Partner Community

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

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

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

How to use Pick action in OIC Orchestration by Sumeet Singh

image

REST Adapter in its current version only publishes a single resource with a single verb in the inbound. Also, there can only be a single source within an integration flow. This is somewhat restrictive as the users have to create multiple integrations (each with a separate resource URI) for related resources and verbs.

Let’s say someone has a requirement to create, update and delete a resource. Naturally, the expectation is that there would be a single resource which can be manipulated with different HTTP verbs. This is not possible with REST adapter and in the current version, users are forced to create multiple integrations for performing these different operations.

Pick is a solution to this. Have a look at how your pick integrations will look in canvas.

PICK is protected with ‘ oic.cloudadapter.adapter.rest.mvrp ‘ feature flag. Check this link on how to enable feature flag. Read the complete article here.

PaaS Partner Community

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

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

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

Fetch Email attachments using Microsoft Email adapter in Oracle Integration Cloud by Ankur Jain

image

In the article, we’ll show how to fetch the attachments from email and dump the attachments on the SFTP server.

To complete this article, we should have in place:

  1. MS email connection: If not created, use the post to create a connection with Microsoft outlook
  2. FTP connection: If not created, use the post to create a connection with FTP

Below is the end to end use case which is demonstrated in the article:

  • Fetch the emails from MS outlook
  • Extract the attachments from each and every email
  • Dump all attachments on the SFTP server

Let’s go ahead and see how to achieve this

  • Create a scheduled integration with name "GetAttachments"
  • Drop the Microsoft Email adapter just below the scheduled activity. The configuration wizard will be opened. On the very first screen enter below information and click the Next button. Read the complete article here.

PaaS Partner Community

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

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

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

OIC Integration with Netsuite – initial setup and basic troubleshooting by Niall Commiskey

image

It’s always good to try new things, so here I am checking out OIC integration with Netsuite.
This post covers the following –

1. Creating a new user in Netsuite, giving them login permissions and assigning roles.
2. Activating that user in Netsuite for web services access.
3. Creating a connection to Netsuite in OIC, leveraging the user created.
4. Creating a simple integration to Netsuite – Contact Creation.
5. Troubleshooting – what permissions does my user need to create a contact in 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.

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

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

Integration, Process and Visual Builder by Jin Park

image

OIC makes integration easy with ODI

We know OIC (Oracle Integration Cloud) is capable of file based integration for ERP over API.
And we do know that ODI (Oracle Database Integrator from Data Integration Platform Cloud) is capable of ingesting large file and processing it for ERP through the database layer aka ETL / ELT.

Okay, what if those cloud services work together and give you a simple pattern which can be applied to typical use case such as large number of big files integration with ERP through the database layer.

Following scenarios would be typical integration use case scenarios;

Financial transaction records from branches / retail merchants come in large number of big files
Files have to be ETL / ELT before cut-off time
Business / IT want to know what’s happened for last batch job processing or current job happening
Financial transaction records have to be kept for certain periods for internal audit and legislative requirements

Now let me show how those integration use cases are implemented by OIC and ODI.

Firstly ODI (Oracle Database Integrator) will do take heavy workloads such as ingesting large files, transforming raw transaction records and load them to target database. Luckily OdiInvokeWebService Tool is available for ODI as an API and Integration (from OIC) will invoke this API. Read the complete article here.

PaaS Partner Community

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

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

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

Full Podcast Series Now Available – Integration: Heart of the Digital Economy by Vika Mlonchina

image

Rapid cloud adoption, mobile devices, and AI technologies are rapidly changing the way customers interact with businesses. And organizations are quickly assembling ad-hoc solutions to meet these challenges. The result is a tangled mess of hardwired enterprise systems that can no longer support business needs. Modern applications and data infrastructures are needed to enable mission-critical business systems to work with big data systems. Cloud-agnostic integration platforms are required to support agile processes that can take advantage of new tools like AI and blockchain. In this podcast series, learn how organizations can leverage integration technologies to compete successfully in the digital age.

All six podcasts in this series are now available at the Oracle Cloud Café or you can listen directly in the links below:

PaaS Partner Community

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

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

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

Dive Deep into Wells Fargo’s Best Practices for Cloud ERP Integration by Vika Mlonchina

image

Recently, Daryl Eicher, Oracle Director of Product Marketing for Oracle Integration, sat down for a webcast with Aneri Shah, Wells Fargo Senior Vice President, ERP Strategist to explore the business and technical considerations that make ERP integration and automation work for agile finance and supply chain management leaders. Read on for a deep dive into their conversation to learn about Wells Fargo’s best practices for cloud ERP integration along with several other customer integration journeys.

View the full webcast

Daryl Eicher: Let’s start with why your integration strategy deserves a fresh look in light of developments in ERP modernization and emerging technologies including block chain, digital assistants, and robotic process automation. Since 2015, Oracle has been investing in our customers to provide a hybrid integration platform for their digital businesses. And today, we’re honored to be considered a leader in Gartner’s Enterprise Integration Platform-as-a-Service Magic Quadrant for two years running. So why is integration as usual not good enough for your digital business?

CFOs and IT innovators are united in their pursuit of practical solutions to the long standing issues of on-premises ERP complexity, agile finances, and connected digital strategy and offer CFOs the chance to use conversational AI, robotic process automation, and hybrid integration platforms to drive efficiencies, simplify procure to pay processes, and enable new data-driven revenue streams for the business. It’s a journey our customers are on that begins with design thinking about what matters most to your digital future. Aneri, can you tell us what you’re hearing from the CFO as you work with their IT leads? Read the complete article here.

PaaS Partner Community

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

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

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

A brief look at the evolution of interface protocols leading to modern APIs by Luis Weir

image

Application interfaces are as old as the origins of distributed computing and can be traced back to the late 1960’s when the first request-response style protocols were conceived.  For example, according to this research, it wasn’t until the late 1980’s when the first popular release of RPC (described below) was introduced by SUN Microsystems (later acquired by Oracle), that internet-based interface protocols gained wide popularity and adoption.
This is perhaps why the term Application Programming Interface (API) even today can often result in ambiguity depending on who you ask and in what context. This is probably because of the fact that historically the term API has been used to (and to a degree continues to) describe all sorts of interfaces well beyond just web APIs (e.g. REST).
This article therefore attempts to demystify (to an extend) the origins of modern web-based APIs. This is done by listing and describing in chronological order (as illustrated below) the different interface protocols and standards that in my view have had major influence to modern web-based APIs as we know them today (e.g. SOAP/WSDL based web services, REST, GraphQL, gRPC to name a few). Read the complete article here.

PaaS Partner Community

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

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

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

PaaS (Process & Integration) Partner Community Newsletter November 2019

Dear PaaS Partner Community,

An Oracle OpenWorld 2019 marketing kit (community membership required) is available, your opportunity to update your customer base on the latest Oracle Cloud Platform services. You can promote, free of charge, your events via the Oracle.com website. Conference rooms at the Oracle customer visitor centers across the world are available via your Oracle partner manager.

For all consultants we offer a free on-demand Oracle integration training including a free certification. Additional Anthony published the Oracle Integration Get Started free hands-on training labs from OOW 19. Please feel free to post your technical questions in our community slack channel.

imageWatch Rutger Hierck how Accenture is helping a utilities client to implement a large scale work management solution with Oracle PaaS. The products involved are Oracle Integration Cloud and Visual Builder. We want to promote also your customer success, submit your story via the customer reference program.

In the integration section you can calculate How Much Oracle Integration Cloud You Need and why it is a very attractive priced solution.

Thousands of customers around the world are using Oracle SOA Suite. A great partner opportunity to expand this on-premises Integration platform in the Cloud. Oracle Integration offers a new SOA Suite adapter for a hybrid platform to leverage your customers investments. Thanks to the community for sharing all the integration articles: OIC ERP Integration Using File Based Data Import (FBDI) & Fusion ERP Batch Imports with OIC Integration Patterns – Publish/Subscribe (Part1) & Oracle Integration Cloud Patterns: OIC & OIC SOA Suite Adapter available as feature flag & ADVISOR WEBCAST: Best Practices and Troubleshooting Oracle Integration Cloud, Oracle Fusion ERP to be held on November 26, 2019.

In the process & innovation section Marcel keeps on serving fresh Jarvis Pizzeria articles on Using a DM in ICS & How to manage Masterdata of a DM (part 1) & ORDS-CRUD Generator. Jan published microprocess considerations and how to handle them in Oracle Integration process functionality.

For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The November edition highlights Oracle OpenWorld marketing kit to update your customer base and all resources to become a Digital Assistant certified expert. This month’s community webcast will be an adapters update Yogesh Sontakke. Join our PaaS Partner Community Webcast November 21st 2019.

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/PaaSNewsNovember2019

Please like and share the newsletter at Twitter and LinkedIn

Jürgen Kress

PaaS Partner Adoption
Oracle HQ
Tel. +49 89 1430 1479
E-Mail: juergen.kress@oracle.com
clip_image003Blog clip_image004LinkedIn clip_image005 Twitter

image

PaaS Partner Community

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

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

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