Extracting Data from Oracle Analytics Cloud using SOAP

  Introduction This post provides a simple method of extracting data from Oracle Analytics Cloud (OAC) using web services. It uses Oracle Business Intelligence Web Services as documented in Fusion Middleware Integrator’s Guide for Oracle Business Intelligence Enterprise Edition This simple method (using HTTP) is not secure and should only be used in a development […]

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS). A compelling reason to use such a method is when data is required that is not in the standard daily extract. Such data might be planning (future) data or data […]

Loading Data into Oracle BI Cloud Service using OTBI Analyses and SOAP

Introduction This post details a method of loading data that has been extracted from Oracle Transactional Business Intelligence (OTBI) using SOAP into the Oracle Business Intelligence Cloud Service (BICS). The OTBI instance may either be Cloud-Based or On-Premise. This method may also be used to load data from Oracle Business Intelligence Enterprise Edition (OBIEE). It […]

Calling Web Services in Background Using MAF 2.1

Introduction Responsiveness of mobile applications is absolutely critical for user acceptance. This survey shows that the most important reason for users to discard an app after first use is the performance. When building enterprise mobile apps, the web service calls made to back-end services are often a bottleneck in achieving acceptable levels of performance. Moving these calls to […]

Fusion Applications WebCenter Content Integration – Automating File Import/Export

Introduction Oracle WebCenter Content, a component of Fusion Middleware, is a strategic solution for the management, security, and distribution of unstructured content such as documents, spreadsheets, presentations, and video. Oracle Fusion Applications leverages Oracle WebCenter Content to store all marketing collateral as well as all attachments. Import flow also uses it to stage the CSV files […]

Application Composer Application Containers

Details on Web Service Definitions, RunTime Messages, and Custom Object Visibility Introduction this discussion of application containers in Application Composer is not relevant to newer (post-Rel12) releases of Oracle Sales Cloud.  Application containers are no longer a structural or logical component of the toolkit, but this post will remain on-line for a time to support […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 4

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Passing User Context When Invoking ADF BC SOAP Web Services

Introduction ADF web applications often use session-scoped user context information that is also used in the ADF Business Components (ADF BC) layer. For example, the user language might be used to query language-specific data from the database. This article explains how this user context can be set up when accessing the ADF BC layer through […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 3

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 2

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 1

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Integrating with Sales Cloud using SOAP web services and REST APIs (Part 2)

This is part 2 of the blog series that covers SOAP and REST integration with Sales Cloud In part 1, I covered the topic of invoking Sales Cloud SOAP web services from external applications. In this part, I will cover the topic of invoking external SOAP services from Sales Cloud.   2. Invoking external SOAP Web Services from Sales Cloud Sales Cloud Application […]

Integrating with Oracle Sales Cloud using SOAP web services and REST APIs (Part 1)

Sales Cloud provides several types of interfaces to facilitate integration with other applications within your enterprise or on the cloud, such as SOAP web services, REST APIs, Events, file-loaders, and BI Reports. The focus of this blog series is SOAP web services and REST APIs. Sales Cloud provides SOAP web services and REST APIs for other applications to operate on core […]

Using soapUI for secure, asynchronous web service invocations in Fusion Applications   

Using secure, asynchronous web services Fusion Applications exposes across all of its product families numerous web services that allows for querying, creating and updating of business objects. In this blog we will show how to leverage these services in a secure, asynchronous fashion from a web service client tool such as soapUI. While invoking services […]

Going Mobile with ADF: Programmatically Invoking SOAP Web Services with Complex Types

Introduction This 5th article in the “Going Mobile with ADF” series explains how you programmatically invoke a SOAP web service from an ADF Mobile application. It illustrates how to handle in Java the complex type that might be returned by the web service, as well as how to set up the complex types that might […]

How to secure Web Services exposed by OAAM Server (oaam_server)

At the end it turned out very simple but I had spent long time in configuring security (authentication and authorization) for Web Services exposed by OAAM 11gR2, thought about writing a blog post on it. For native integration, OAAM Server (oaam_server) exposes Web Services. For the enterprise deployment, security of Web Services would be mandatory.  […]