Fusion HCM Cloud Bulk Integration Automation by Jack Desai

 

Introduction

clip_image002Fusion HCM Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the bulk integration to load and extract data to/from cloud. The inbound tool is the File Based data loader (FBL) evolving into HCM Data Loaders (HDL). HDL supports data migration for full HR, incremental load to support co-existence with Oracle Applications such as E-Business Suite (EBS) and PeopleSoft (PSFT). It also provides the ability to bulk load into configured flexfields. HCM Extracts is an outbound integration tool that let’s you choose data, gathers and archives it. This archived raw data is converted into a desired format and delivered to supported channels recipients.

HCM cloud implements Oracle WebCenter Content, a component of Fusion Middleware, to store and secure data files for both inbound and outbound bulk integration patterns. This post focuses on how to automate data file transfer with WebCenter Content to initiate the loader. The same APIs will be used to download data file from the WebCenter Content delivered through the extract process.

WebCenter Content replaces SSH File Transfer Protocol (SFTP) server in the cloud as a content repository in Fusion HCM starting with Release 7+. There are several ways of importing and exporting content to and from Fusion Applications such as:

  • Upload using “File Import and Export” UI from home page navigation: Navigator > Tools
  • Upload using WebCenter Content Document Transfer Utility
  • Upload programmatically via Java Code or Web Service API

This post provides an introduction, with working sample code, on how to programmatically export content from Fusion Applications to automate the outbound integration process to other applications in the cloud or on-premise. A Service Oriented Architecture (SOA) composite is implemented to demonstrate the concept.

Main Article

Fusion Applications Security in WebCenter Content

The content in WebCenter Content is secured through users, roles, privileges and accounts. The user could be any valid user with a role such as “Integration Specialist.” The role may have privileges such as read, write and delete. The accounts are predefined by each application. For example, HCM uses /hcm/dataloader/import and /hcm/dataloader/export respectively.

Let’s review the inbound and outbound batch integration flows.

Inbound Flow

This is a typical Inbound FBL process flow: 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

Finally My PaaS4SaaS Workshop Blog by Debra Lilley

 

clip_image002I know this posting is a bit late but at the end of January I took part in a proof of concept workshop for PaaS4Sass and it’s been a rollercoaster ride ever since.

When I was thinking about moving to Certus one of the things that attracted me was there intent to write extensions for Oracle’s CloudApplications using the just announced PaaS4SaaS solution.

I attended Oracle Open World with an open mind and trying to learn as much as I could about the solutions. The Larry Ellison demo was really impressive but then Oracle has always been a brilliant marketing company.

I came back to UK and set about validating what was available, some of the components Database and Java Cloud had been available for a while but I wanted or would want to also use the Process and Integration Cloud offerings.

As regular readers of this blog will know, I am an OracleApplications User Experience advocate and am very committed to the user experience work that goes into Oracle Cloud Applications. Extensions delivered by Certus will have this same user experience and I made this video on the half of Certus.

The user experience team have been given funding by Thomas Kurian who is personally committed to making PaaS4SaaS work, to carry out a number of proof of concept workshops with Oracle partners. The UX team asked Certus to be part of this. Certus have not been a development company and so in the same way customers come to us because we are the best at implementing cloud applications we looked for a partner to help us with development, and weselected eProseed who have the same commitment to UX as we do.

The workshop took place in London at the end of January with four people from each of Oracle UX, eProceed and Certus taking part. We work through a use-case taken from an existing Application from one of our customers who is considering modernising this and moving it to the cloud. In three days we were able to build a working application and prove to ourselves that when the customer says, “go” we will be able to deliver what they need.

Oracle UX team have in their blog already covered the workshop and I have also written about it in the AppAdvantage blog I am a guest author for. The following month I took part in the Partner SOA Community Forum in Budapest when we had the opportunity to work with product management teams of both the Process and Integration Cloud offerings and further validate our approach, understanding the possibilities and the constraints. The UX team also had a stand there. I was very pleased on behalf off both Certus and eProceed to accept the first Community Cloud award. These awards are a bit like the Oscars and awarded to individuals Lonneke from eProseed and myself, however we had a similar thank you to all those involved in our acceptance speech. The Community Leader Jurgen Kress said: I awarded my first SOA Community Outstanding Contribution for Cloud to Debra Lilley of Certus Solutions and Lonneke Dikmanns of eProseed because they not only took on board the messaging of PaaS 4 SaaS from the last Oracle Open World, but also their collaboration between an Applications partner and a Middleware partner, sought out answers and training and with Oracle Development giving feedback and  validating their approach in this area. All good things but bringing that back to the community and sharing is the outstanding contribution. 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

SaaS-OnPremise Integration with Fusion Middleware demo available

 

clip_image002To get access to the Oracle demo system please visit first OPN (OPN account required)

With the increasing popularity of software as a service (SaaS), there is a key imperative to quickly, efficiently and securely integrate the newer SaaS applications with their existing on-premise counterparts. Using an incident management/service delivery scenario, this demo shows how Oracle Fusion Middleware streamlines this integration via a unified framework of middleware components that masks the technical differences and enforces consistency via a common integration platform for SaaS and On-Premise applications.

Highlights

  • Incident management/service delivery scenario with multiple user personas to reflect real world use case
  • SOA Suite 12c with Oracle Cloud and On-Premise Adapters to integrate Oracle Service Cloud and E-Business Suite applications
  • Scalable and secure access management for cross-application processes and transactions via OAM Mobile and Social, OAG, OID
  • This demo is mostly an iPhone based demo.

Call to Action

For more information about SaaS integration attend our Multichannel Integration hands-on workshop at the Fusion Middleware Community Forum 2015 or visit the SOA Partner Community Workspace (Community membership required).

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

Cloud Adapter for Salesforce.com free online training

 

clip_image002

Oracle Cloud Adapter for Salesforce.com Overview This video provides an overview of the Adapter and then demonstrates how you could use Oracle SOA Suite and the Salesforce adapter to synchronize Account information between Salesforce.com and E-Business Suite on-premise. For more information see oracle.com/oll/soa.

Working with the Oracle Cloud Adapter for Salesforce.com In this video, we show the concrete steps to integrate Salesforce.com with E-Business Suite, synchronizing customer Account information from E-Business Suite to Salesforce.com. First we will see how to configure the Salesforce.com adapter using Oracle JDeveloper.
Second, we see how to synchronize Account information from on-premise E-Business Suite to Salesforce.com using Oracle Salesforce.com

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

Simplify SaaS and On-Premises Integration by Using Oracle Fusion Middleware by Srikant Subramaniam

 

clip_image002With the increasing popularity of software as a service (SaaS), there is a key imperative to quickly, efficiently, and easily integrate the newer SaaS applications with their existing on-premise counterparts. This has proven to be especially challenging as each SaaS vendor enforces its own mechanisms for security, message delivery, and other integration aspects. As a result, it is not entirely surprising that 1 in 2 companies has abandoned the use of a cloud app in the last 3 years due to integration problems.
As a result, the context for this session was: given these challenges and the sobering statistics, how can customers be better equipped to avoid the pitfalls and endemic problems associated with this integration scenario.
We described how Oracle Fusion Middleware provides a single set of tools to handle all of these integration challenges. With the release of SOA Suite 12c, it is now possible to unify the disparate requirements challenges of mobile, cloud, and IoT into a single integration platform.  Also, the new Cloud Adapters in SOA Suite 12c simplify the task of developing and securing connectivity and enable users to focus on building the business logic for the integration processes.
A successful integration strategy involves much more than simple connectivity. Once the backend applications have been connected, the next step is to implement an access management solution that will allow users to access these applications in a secure manner. Oracle Identity and Access Management provides a single, secure point of entry where the user’s identity can be verified and access to enterprise resources can be managed to provide consistent role management, SSO and governance to cross- application processes and transactions. 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

Extending the Oracle Sales Cloud with SOA Suite by Gerhard Drasch

Introduction

The Oracle Sales Cloud provides an extensive set of features for extending the user interface, the underlying data model, and allows the use of Groovy scripts to extend or adjust the default business logic. If customers have requirements that go beyond these capabilities, Java Cloud Service is a viable option to build new user interface allowing a seamless UI level integration (see the samples here). If an extension is not driven by UI requirements but rather backend orchestration and integration needs, introducing the Oracle SOA stack is a logical option to consider.

This article describes how business logic implemented in Oracle SOA Suite can be invoked in a secure way while ensuring that the additional logic in SOA Suite can execute in the Sales Cloud user’s security context.
Creating SOA services for the Sales Cloud
For simplicity, we are showing here a basic SOA composite with a BPEL component that is doing nothing than receiving a JWT token from the Sales Cloud and then calling back a web service in the Sales Cloud leveraging this token. Here is an overview of the composite:
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