How to Use Custom (Apex) WSDL Option in Salesforce.com Adapter? by Shalindra Singh

December 15, 2016 Leave a comment

clip_image002

 

This blog focuses on new feature released with ‘Oracle Cloud Adapter for Salesforce.com’ on ICS starting from 16.1.5. On- Prem SOA Suite will have same feature coming up down the line.

In this blog will walk you through the features of new options; Custom WSDL Support and also how to leverage CUSTOM WSDL (Apex WSDL) of force.com to do the integration between force.com and external system with Salesforce adapter on ICS.

Before we proceed we should know answers of following questions – (If you aware of these terminology)

  1. Why Custom WSDL?
  2. What is Custom WSDL?
  3. How to Generate & Download Custom WSDL?
Why Custom WSDL:

Though Salesforce, by default, provide rich connectivity through standard SOAP and REST API, but there still be a need to extend / enrich the built in functionality in order to support business specific requirement. There could completely new business requirement that by default does not exist. Again all these things can be achieved through Apex coding / custom coding on force.com. 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

Filed under Cloud Tagged with , , , , , , , , ,

Salesforce to SAP Integration with Oracle ICS

October 30, 2016 Leave a comment

 

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

Filed under Cloud, SOA Tagged with , , , , , , , , , , ,

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

October 28, 2016 Leave a comment

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

Filed under Cloud, SOA Tagged with , , , , , , , , , ,

Why does DB-adapter return duplicate rows? by Jon Petter Hjulstad

December 21, 2015 Leave a comment

 

clip_image002Here are some DB adapter tips regarding duplicate rows.

The DB Adapter has some nice features, but sometimes you can get fooled. One of my colleagues experiences this one day. The query returned the same row – just repeated many times.

The reason for this is because the primary key was not defined correctly.

The good thing is that the documentation describes this – and more: Oracle documentation

For tables where primary key is defined – this should not be a problem, but in cases where it is not defined or you are querying a view – you would need to specify a primary key yourself. A couple of relevant notes here:

  • If you do not provide a valid primary key, then the unique constraint is not guaranteed, and this could result in possible loss of messages at runtime. That is, rows with duplicate primary key values are likely to be lost.
  • You should ensure that you primary key is less than 100 bytes.
  • Oracle recommends that you use varchar instead of char for primary key columns

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

Filed under SOA Tagged with , , , , , , ,

Using DB Adapter in SOA Suite 12c by Waslley Souza

January 6, 2015 1 Comment

clip_image001When you have a BPEL Process, and it needs to perform an operation on a Database Table, for example, insert an employee, you have to use the Database Adapter. The Database Adapter exposes to SOA, tables and SQL transparently and non-intrusively.

In this post, I will create a BPEL Process to insert employees into Employees table from HR Schema. Best practises, like the use of MDS and Mediator, are not the purpose of this post. Download the sample application: SOADBAdapterApp.zip.

Create a SOA Application.

In Step 1, set the Application Name and Application Package Prefix.

In Step 2, set the Project Name. 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

Filed under SOA Tagged with , , , , , , , ,

Integration Adaptors including SAP R/3

January 5, 2015 Leave a comment

Acelerate Integration with your Cloud, On-Premise and Legacy Applications with Oracle Integration Adapters. clip_image002
Oracle Integration Adapters provides a critical foundation for the Product, providing a Unified Connectivity Architecture, facilitating integration of information from several on-premise, legacy and cloud based applications and systems into a Service Oriented Architecture.They enables creation of Reusable service assets that publish to and extract information from disparate Cloud and On-Premise Applications such as Oracle E-Business Suite, SAP or Salesforce.com to simple but key technology assets such as FTP Servers or Databases. Oracle Integration Adapters facilitate an Integration and Extension Platform for your Applications.
Whats New!
The 12c release of SOA Suite positions the product as the only integration product in the market today that can support all major ongoing technology trends: mobile enablement via major REST & JSON improvements throughout the suite, cloud integration via the new line of cloud adapters and Internet-of-Things with Oracle Event Processing providing the impedance matching layer between devices and enterprise systems. While many vendors may boast similar claims in high-level positioning documents, Oracle goes beyond the hype by delivering tangible features to back up these assertions in SOA Suite 12c.
Please goto the SOA Suite Product Overview page for more information on this new release.
The 12c release also delivers exciting new connectivity capabilities including all new Adapters for Cloud and On-premise Integration. These include the all new Enterprise Application Adapters for SAP R/3 and JD Edwards World, and brand new Technology Adapters for integrating with Coherence, MSMQ and LDAP. Note that the new SAP R/3 and JD Edwards World Adapter have a rich and intuitive JDeveloper based design-time and advanced Runtime capabilities. The 12c release will also be the platform for several upcoming Cloud Adapters.  For more details, refer to the following document.

Accelerate your SAP Integration with the new  Oracle Integration Adapter for SAP R/3

clip_image004The Oracle Adapter for SAP R/3 provides comprehensive, bi-directional, standards-based, real-time connectivity to SAP R/3 systems. The Adapter supports both JCA and Web Service standards for creation of open and reusable service-oriented applications (SOA). High-speed, low-impact, non-intrusive access to and from SAP exposes the critical business logic and data contained with SAP for reuse: the key to building a successful e-business application or integrated enterprise. This Adapter, newly introduced in 12.1.3 is natively integrated with JDeveloper providing enhanced developer productivity and accelerated time-to-market. Refer to the following documents for more information.

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

Filed under SOA Tagged with , , , , , , ,

Cloud Integration – A Comprehensive Solution,White Paper

March 11, 2014 1 Comment

Cloud computing solutions are widely hailed as a way to reduce capital expenditures and move to an inexpensive, subscription – based IT model. However, many organizations don’t stop to consider all of the nuances of integrating cloud applications with their existing information systems. While deploying a cloud app or subscribing to a cloud-based service may be relatively straightforward, how will this new IT asset fit in with the rest of the enterprise, including on-premise systems and other cloud applications? What is the system of record from which data will be derived? Which business processes are involved?

Do you need an enterprise data model that is independent of the cloud data model? Read the complete white-paper here.

Coming Soon: New Oracle SOA Cloud Adapter for Salesforce.com Simplifying SaaS Integrations
Are Your Customers:

  • Planning for Cloud Integration initiatives as a part of or beyond their Application Integration projects?
  • Looking for a Strategic Integration Platform and Architecture (SOA) to simplify and secure connectivity?
  • Keen to enable Flexibility and Developer Productivity for their On-premise to SaaS integrations?

We will be soon launching the new SOA Cloud Adapter for Salesforce.com.  Stay tuned to  our SOA Community to learn more about:

  • Why Is It Important to Simplify Cloud to On-premise Integrations?
  • How does the Adapter make it simple with a Declarative Modeling Wizard?
  • How to learn more, where to download and who to contact about the shiny new SOA Cloud Adapter?
  • Pricing and Licensing
  • Q & A

To learn more or for any questions, reach out to Yogesh Sontakke at @yogesh_sontakke.

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

Filed under SOA Tagged with , , , , , , , , ,