OIC May 21 Release – B2B support for UN EDIFACT Part 1 by Niall Commiskey

The May 21 release of OIC brings lots of new features to B2B. This post will focus on the new UN EDIFACT support, but will also detail our new auto-generation of – send/receive pre-processor integrations – feature.

The usual caveat from me at the outset – I am not an EDI/EDIFACT expert – many folks tasked with creating such integrations are also not, so this is for you! Version 1 of B2B in OIC supported X12, now we are also providing UN EDIFACT support. So what is the difference between the 2, apart from the fact that the latter is mainly used in Europe? Apparently X12 has made inroads into the healthcare market (HIPAA), whereas UN EDIFACT has not. Both standards are used in areas such as supply chain, government etc.

This post begins with an introduction to the format of an order in UN EDIFACT, it is rather pedestrian, if fact probably boring for most of you, who are at home in EDI. I go through the order document line for line, this I am mainly doing for my own benefit, so that I actually understand the values being sent.

The post continues with a short introduction to the transport protocol I will use, AS2. Finally, we get to the section that covers the implementation of a simple UN EDIFACT orders based B2B transaction 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

May 2021 Enhanced Security in Adapters by Michael Meiner

Oracle Integration enables our customers to connect applications and technologies in a secure manner. We are thrilled to share that we continue to enhance Oracle Integration to provide additional security settings and functionality. In the May 2021 release, Oracle Integration offers new security-related functionality as described below. This further extends OIC security options and capabilities; see February 2021 OIC Security Adapters blog and  November 2020 OIC Security Adapters blog.

With our May release, we are adding support in the REST adapter for SHA-256 signature method for OAuth 1.0a authentication scheme

We are introducing an option in the REST adapter connections page. By default, SHA1 is used. But you now have the option to select SHA-256. 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

May 2021 Third-Party application adapters update by Michael Meiner

Oracle integration has a rich portfolio of adapters for connectivity with 3rd party applications. Lilly our official mascot is happy to announce enhancements to our 3rd party adapters!!  These enhancements are intendend to meet critical usecases required by our customers.

In this release, we are providing the following enhancements to our 3rd party adapters.

• (new) Jira Adapter
• Shopify adapter support for multiple domains (i.e., stores)
• Salesforce Commerce Cloud Adapter: Shop APIs Support
• Workday adapter: support for additional operations

Jira Adapter

The Jira Adapter is the newest addition in the Social/Productivity segment of adapters. With the May release, the Jira Adapter will enable you to connect with the Jira application. Jira is a powerful work management software and it is used for project management, bug tracking, and issue tracking.

Example usecases with the Jira adapter include:

• Incident created in Incident tracking system auto creates Issue in Jira
• Case created/updated in CRM system will create/update issue in Jira
• Sync new/updated issue from Jira to customer ticketing system

The Jira Adapter connection page needs hostname, username, and password for establishing the connection with the Jira application. On the Connection page, an API token is used (instead of your account password) as a password whenever you programmatically authenticate with basic authentication. 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

May 2021 Technology Improvements in Adapters by Michael Meiner

In the May 2021 release, we are making the following updates to our Database adapters and connectivity agent:

1. MS SQL adapter: support for Azure SQL
2. My SQL adapter: support for MySQL version 8
3. Connectivity agent: support for JDK 11

Microsoft SQL on Azure

Many of our customers need to integrate with Microsoft Azure SQL. In this release, you can leverage the same SQL Server adapter that is available in OIC, and connect to Azure SQL. You will set up a connectivity agent, and then use the connections page to fill in the Azure SQL host and port, database name and the credentials.

Once you configure the connection, you can use this connection in an integration flow in exactly the same way as SQL Server on-premise. Note that SQL on Azure can be installed in a private network, where the ports are not open to the internet. For such a setup, the OIC connectivity agent needs to be installed on an Azure VM in the same subnet. This is so the agent will be able to reach the Azure SQL instance. If SQL on Azure is configured with open ports, then the connectivity agent can be installed anywhere (including on Oracle Cloud). We will be adding more options for security policies in an upcoming release. 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

May 2021 Oracle Integration Pre-built Recipes by Michael Meiner

What is a Recipe?

When cooking a meal, you often use a recipe. You don’t need to start from scratch. The recipe gives you the ingredients and amounts to cook your meal. Similarly, when using OIC recipes, we give you the "ingredients". You start  with one of more pre-assembled solutions that bundle all the resources required by the integrations, such as the connections and lookups, into one package. Use a recipe to quickly get started cooking your meal (or in our case, building your integration).

We continue to add pre-built recipes to our repository. In the May 2021 release, here are some of the recipes we are adding:

• Retrieve and place files to/from NetSuite File cabinet
• Create, Update and Delete ServiceNow Incidents
• Get feeds or posts from Facebook
• Create channels and push notifications to Slack
• Send a Docusign envelope and get status

So How Do I Use A Recipe?

Well, I’m glad you asked. It’s actually quite simple. Just log into your OIC console and on the Home Page you will see the recipes. (Note: this Home Page is for Oracle Integration Generation 2 instances). 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

May 2021 Oracle Integration Update by Antony Reynolds

It is time for the May quarterly update to Oracle Integration. With Spring in the air we are excited to share all our exciting new features and improvements. Note that testing is still underway for these features and, although unlikely, it is possible that some will not meet our quality standard and be deferred to a later release.

Announcements & Update Windows

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

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

Developer Productivity Enhancements

We are making the following improvements for developers:

• Configurator Enhancement
  • Allow replacing a connection within a package if connection is used by one of more inactive Integrations
• Move Integration Test UI from swagger to OpenAPI
• OpenAPI allows us to improve the test UI experience as it provides more information about the integration to be called. Read the complete article here and watch the on-demand webcast 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