Cloud Adapter SDK – Part 2: Functionality by Jeroen Ninck

clip_image002

 

Introduction

So this is part 2 of a series of blog post describing building a Cloud Adapter for MongoDB. In this part I want to discuss the functionality I want to achieve.

I will use Windows 10 and PowerShell (my favourite Windows shell!) for these blogs. All sources can be found on GitHub.

Parts:

Just a small warning: Always keep track of Oracle license information and the Oracle certification matrix!

What should it do?

MongoDB has a lot of features we might want to expose in the Cloud Adapter. However I want to start relative simple and I might expend the functionality in the feature. So I want to start with inserting data. A second step will be to find the data by querying it.

MongoDB

MongoDB is a NoSQL database and stores documents. These documents are basically JSON documents (actually BSON):

{
                    "_id" : ObjectId("56fa75781f1378215c215709"),
                    "field1" : "value1"
}

Basically there are no foreign keys. Of course you refer to other documents, however these is no foreign key like in a relational database. Each document does have a primary key called _id (which is of type ObjectId). A document is stored in a collection and a MongoDB database can have multiple collections. A single instance of MongoDB can host multiple databases. Read the complete article here.

SOA & BPM Partner Community

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

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

Integration Cloud Service (ICS): A developer’s first impression by Maarten Smeets

clip_image001

 

Oracle provides ICS (Integration Cloud Service) as a simple means for citizen developers to do integrations in the cloud and between cloud and on-premises. On the Oracle Fusion Middleware Partner Community Forum I got a chance to get some hand-on experience with this product in one of the workshops. In this blog post I will describe some of my experiences. I’m not the target audience for this product since I am a technical developer and have different requirements compared to a citizen developer. I’ve not been prejudiced by reading the documentation

I experimented with ICS on two use-cases. I wanted to proxy SOAP and REST requests. For the SOAP request I used a SOA-CS Helloworld web-service and for the REST request I used an Apiary mockservice. I will not go into basics too much such as creating a new Connection and using the Connection in an Integration since you can easily learn about those in other places.

ICS: Calling a SOAP service on SOA-CS

When you want to call a SOAP service which you have exposed on ICS, you require two sets of headers. The WS-Timestamp headers and the WSS-UserName token headers (with the password in plain text).

This is required even when you have not specified a security policy (currently username/password token and basic authentication are supported). When you don’t provide them, you get Service Bus errors (as shown in the screenshot below) which indicates ICS is running on the Service Bus (in case you didn’t know this yet, it is no secret). This was not required when directly calling the SOA-CS service. Read the complete article here.

SOA & BPM Partner Community

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

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

Are you doing SaaS, or EBS, integrations and using Oracle Integration Cloud Service (ICS)? By Angelo Santagata

clip_image002

 

Are you doing SaaS, or EBS,  integrations and using Oracle Integration Cloud Service (ICS)?

Do you need some inspiration? Well this is your lucky day!

Below you’ll find a collection of ICS Integration videos , produced by our product managers and our UA development team which go though, step by step, how to integrate  two SaaS applications

There are plenty more videos available at the Oracle Help Centre here and read the complete article here.

SOA & BPM Partner Community

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

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

Using the ICS Connectivity Agent with an On-Premises Database by Robert van Mölken

clip_image002

In this third article about the Connectivity Agent we deep-dive into the details. We learn how to use the ICS Connectivity Agent in combination with an on-premises database. For more information about the architecture and installation of the agent I recommend to read these two articles first. This article continuous where the previous article about the installation ended.

Taking the Agent for a test drive

Now that the Connectivity Agent is installed, registered and running we can use the Agent to create connections to our on-premises applications and create integration on top of these applications.

Preparing the connection to the on-premises database

Now that we know the Agent is running we can make a connection to the on-premises database. For this example I use the HR sample schema that is part of my database installation. Navigate to the connections page of ICS and click on the “Create new Connection” button. My instance is running the latest 16.1.3 version. The “Create Connection” dialog now at lot nicer and user friendlier.

Select the Database adapter to create a connection your database instance. the connection is named OnPremisesHRDB which creates the associated identifier ONPREMISESHRDB. Read the complete article here.

SOA & BPM Partner Community

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

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

Integration Cloud Service 16.4.1 Fall Release available including free trials for Partners

image

We are pleased to announce the availability of 16.4.1 – Fall release of Integration Cloud Service (ICS) .

This October release continues to broaden it’s connectivity portfolio in various segments. These include:

  • Oracle Utilities – New Adapter
  • Oracle Eloqua – Inbound (Trigger) Support

New Oracle Utilities Adapter:

imageA recent survey of 100 North American electric, water and gas utility industry executives completed by Zpryme and Oracle Utilities GBU shows that Utility Companies are embracing the Cloud. With 45% of organizations using the Cloud in some form today and another 52% planning to move to the Cloud. Nearly 97% of interviewees told us they have become involved with Cloud technologies or applications and computing resources delivered as services over a network connection instead of through in-house resources at a utility. This means integration is imperative to all Utility customers without doubt!

This release introduces the new Oracle Utilities adapter taking the list of total adapters closer to 50! This adapter enables you to easily integrate with Oracle Utilities applications that use Oracle Utilities Application Framework v4.3.0.0 or later and supporting Web Services.

For those Utilities Applications using JMS or DB integration services, you can continue to leverage the generic ICS adapters instead.

New Status and Usage APIs:

imageThe brand new /status API is now available that can be queried for system health status (runtime, storage, messaging, and security services). Similarly, the new /usage API returns metrics for system design-time (adapters, agent, application instances, lookups, integrations, packages, and runtime – messages and messaging system). Refer to the REST API documentation for more details.

Support for Service Callbacks:

Starting this release, you can configure outbound SOAP invocations to specify callback ICS flows for asynchronous conversations with external systems/web services.

For example, if you are invoking a credit rating service that responds to you asynchronously (One-Way with Async Call back), you can receive that callback as a delayed response. Remember that the callback flow will be specified within the SOAP adapter design-time as a separate ICS flow.

Learn More: More details on what’s new is available here. Learn more about Oracle Integration Cloud Service at http://cloud.oracle.com/integration

Want to try ICS Cloud Service? Get access here.

Partner Resources (community membership required):

Sales kit for partners: Cloud and On-Prem Integration: Integrate CRM SaaS Apps with On-Premises ERP & Integrate HCM Cloud with on-premises ERP

Marketing kit for partners: SOA Campaigns

SOA & BPM Partner Community

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

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

Salesforce to SAP Integration with Oracle ICS

 

clip_image001

Watch the video here.

SOA & BPM Partner Community

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

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

Preparing & installing the ICS on-premises Connectivity Agent by Robert van Molken

clip_image002

 

In this second article about the Connectivity Agent we deep-dive into the details. We take a look in preparing and installing the agent. This is done in combination with Integration Cloud Service. For more information about the architecture and inner workings of the agent I recommend to read this article first.

What is the Connectivity Agent?

Basically it is a gateway between cloud and on-premises. The Agent eliminates common security and complexity issues previously associated with integrating on-premises applications from outside the firewall. With the agent it is possible for example to connect with an on-premises database or ERP application using the existing JCA adapter framework.

Downloading the Connectivity Agent

There are a few steps in installing the agent. First the installer can only be downloaded from your Integration Cloud Service instance. Secondly the installer can only be run on a linux environment. Thirdly some settings can be tuned / changed after installation.

Downloading the Agent

The agent first need to be downloaded from Integration Cloud Service. Login into your ICS instance and navigate to the Agents page.


At the top-right corner the user can find the “Download Agent installer” button. When clicking on the button it will show two options; the connectivity and execution agent. This article describes the first option. The second agent is evenly interesting, because it will install an instance of Integration Cloud Service on-premises. More details on this agent at a later time. Read the complete article here.

SOA & BPM Partner Community

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

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

E-Business Suite Integration with Integration Cloud Service and DB Adapter by Ulrich Janke

clip_image002

 

Introduction

Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This article will introduce into the use of ICS for integrating an on-premise E-Business Suite (EBS) instance via Database Adapter. While EBS in recent releases offers a broad set of integration features like SOAP and REST support (i.e. via Integrated SOA Gateway), these interfaces are not available in older versions like 11.5.x. In the past it has been a proven approach to use Oracle Fusion Middleware Integration products (SOA, OSB etc.) running on-premise in a customer data center to connect to an EBS database via DB Adapter. In a short time this feature will be available also in a cloud based integration solution as we will discuss in this article.

Unless we focus on EBS integration here the DB Adapter in ICS will work similarly against any other custom database. Main reason to use an EBS context is the business case shown below, where ICS is connected to Mobile Cloud Service (MCS) to provide a mobile device solution.

Business Case and Architecture

Not hard to imagine that Oracle customers running EBS 11.5.x might have a demand to add a mobile channel for their end-users. One option could be an upgrade to a recent release of EBS. As this will be in most cases a bigger project, an alternative could be the creation of a custom mobile solution via Oracle Jet and MCS as figured below. MCS is a PaaS offering and requires access to an underlying database via REST/JSON. This is the situation where ICS appears in this architecture.

In absence of native SOAP or REST capabilities being available in EBS 11.5.x tech stack, the integration via ICS would close that gap. Any database access activities (retrieving data, CRUD operations etc.) can run via an ICS/DB Adapter connection to an EBS on-premise database. ICS itself will provide a REST/JSON interface for the external interaction with EBS. This external interface is generic and not restricted to MCS as caller at all. However in our business case the ICS with DB Adapter fulfills the role of a data access layer for a mobile solution. Read the complete article here.

SOA & BPM Partner Community

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

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

Integration Cloud Service (ICS) On-Premise Agent Installation by Greg Mally

clip_image002

 

The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall configurations or VPN. Additional details about the Agent can be found under New Agent Simplifies Cloud to On-premises Integration. The purpose of this A-Team blog is to give a consolidated and simplified flow of what is needed to install the agent and provide a foundation for other blogs (e.g., E-Business Suite Integration with Integration Cloud Service and DB Adapter). For the detailed online documentation for the On-Premises Agent, see Managing Agent Groups and the On-Premises Agent.

On-Premises Agent Installation

The high-level steps for getting the On-Premises Agent installed on your production POD consist of two activities: 1. Create an Agent Group in the ICS console, and 2. Run the On-Premises Agent installer. Step 2 will be done on an on-premise Linux machine and the end result will be a lightweight WebLogic server instance that will be running on port 7001.

Create an Agent Group Read the complete article here.

SOA & BPM Partner Community

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

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

Implementing an SFDC Upsert Operation in ICS by Ricardo Ferreira Leave a Comment

clip_image002

 

Introduction

While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is upsert. Upsert is an acronym that means the union of “update plus insert”. The idea behind is having a unique operation that decides which action to take – either update the existing record or insert a new one – based on information available in the message. Having one operation instead of two, makes the SOA service interface definition clearer and simpler.

Some SaaS applications offer upsert capabilities in their exposed services, and leveraging these capabilities can considerably decrease the amount of effort required while designing SOA services in an integration platform such as ICS. For instance, if you need to develop an upsert operation and the SaaS application does not have this functionality; you will have to implement that logic using some sort of conditional routing (see Content-Based Router pattern) or via multiple update and insert operations.

Salesforce.com (or SFDC for short) is one of those SaaS applications that offers built-in support for the upsert operation. This post will show how to leverage this support with ICS. Read the complete article here.

SOA & BPM Partner Community

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

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