OIC and ICS File based integrations for Oracle HCM Cloud using UCM webservices

Introduction This blog details the solution using Oracle Integration Cloud (OIC) and Integration Cloud Service(ICS) for file based integrations using Universal Content Management (UCM) Webservices for Oracle HCM Cloud integration. Deprecation of SaaS sFTP servers for Oracle HCM Cloud and other Oracle Cloud applications was announced recently. Refer to the below MOS Support Doc Note for the announcement […]

Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 2: Step-by-Step Example

Following the overview in Part 1, I will now show detailed steps how to create the event subscriptions. In our example, we will use an “Item Creation” event (from SCM cloud). Prerequisite: Register CSF Key in SaaS In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the […]

SSO “like” functionality with Oracle Fusion JWT Tokens

Introduction There are many instances where customers want to extend Oracle’s Fusion SaaS applications with PaaS components. Depending on the Oracle PaaS components being used, they may get SSO with Fusion Applications pre-configured OOTB however sometimes this is not the case and they will need to manually setup SSO federation to achieve their needs. If […]

Transport Layer Security (TLS) and Web Service Connections in SaaS Integrations

A Checklist for Success with TLS Why We Need This Despite the full feature sets and capabilities that Oracle builds into their software-as-a-service (SaaS) cloud applications, there are still going to be occasional customers with business requirements that cannot be satisfied solely with a single SaaS subscription.  In these cases, it is possible to extend […]

Everything you Should Know about the API Platform Groovy Policy

Introduction Developers using the API Platform Cloud Service often make use of the built-in policies that comes with the platform; to implement any logic that needs to be executed before delivering the actual message to the backend service. One common policy used is the Groovy policy, which allows API developers to write Groovy scripts that […]

Performing ELT Lookups with Data Sync

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), and other relational databases. In the 2.3 release of Data Sync, new […]

Performing ELT Data Transformations with Data Sync

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), and other relational databases. In the past, if you needed to transform the […]

Using Native SSH Tunnel Functionality within the Data Sync Tool to Secure Connections

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), and other relational databases. Last year I covered an approach that could […]

Integrity check, content validation and encryption of files over ICS FTP adapter

Oracle Integration Cloud Service (ICS), an industry-leading iPaaS offering, provides rich orchestration and mapping capabilities over FTP connections.   ICS FTP adapter supports connections over secure or non-secure channels.  Files can be transferred and processed by ICS without validating content upon transfer, which is the default behavior.  Files transferred over secured FTP benefit from inherent integrity […]

Forwarding Messages from WebLogic to TIBCO EMS

Introduction Messaging is one of those technologies that have been around for decades, but only recently people got aware of the important role that messaging plays to any software-based architecture. Any use case that requires messages to be exchanged between systems in a reliable, fault-tolerant and scalable way may leverage messaging to fulfill its needs. […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part III

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part II

  Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service […]

Using Business Events in E-Business Suite to send messages to other applications via ICS

Introduction In this article, I will discuss and demonstrate the use of Business Events in E-Business Suite (EBS) to integrate it with other applications using Integration Cloud Service (ICS). The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. This functionality is leverage […]

Integrating with Taleo Enterprise Edition using Integration Cloud Service (ICS)

Introduction Integration Cloud Service (ICS) provides Oracle SaaS customers with pre-defined to connections to most SaaS subscriptions and zero-code integration features to quickly connect SaaS applications. Oracle Taleo provides talent management functions as Software as a service (SaaS). Taleo often needs to be integrated with other human resource systems. For customers looking to use ICS for […]

Using Oracle Data Integrator (ODI) to Load BI Cloud Service (BICS)

For other A-Team articles about BICS, click here Introduction Oracle Data Integrator (ODI) is a comprehensive data integration platform that covers most data integration scenarios.  It has long been possible to use ODI to load data into BI Cloud Service (BICS) environments, that use Database as a Service (DBaaS) as the underlying database. The recent 12.2.1.2.6 release […]

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

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) using RESTful services. It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP . Both this post and […]

Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Identity Cloud Service (IDCS) into the Oracle Business Intelligence Cloud Service (BICS). It builds upon the A-team post IDCS Audit Event REST API which details the REST API calls used. One use case for this method is for analyzing trends regarding audit events. […]

Automated Deployment to SOA Cloud Services using Developer Cloud Services

Introduction The process of deploying SOA Projects to Oracle SOA Cloud Services (SOACS) can be significantly simplified and streamlined using the Oracle Developer Cloud Services (DevCS) by facilitating the inbuilt Maven and GIT repositories. This article is a walk-through on how create a SOA Project in JDeveloper and get it deployed on SOACS using DevCS. […]

Loading Data into Oracle BI Cloud Service using BI Publisher Reports and REST Web Services

Introduction This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Extracting Data from Oracle Business Intelligence 12c Using the BI Publisher REST API. […]

Loading Data into Oracle BI Cloud Service using BI Publisher Reports and SOAP Web Services

Introduction This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Using Oracle BI Publisher to Extract Data from Oracle Sales and ERP Clouds. […]