ICS Connectivity Agent Concepts and Best Practices

ICS Connectivity Agent Concepts and Best Practices Introduction The on-premises connectivity agent enables you to create integrations between on-premises applications and Oracle Integration Cloud Service (ICS) Read all about agents in the documentation link below – Integration Cloud Service (ICS) Connectivity Agent In this blog, I wish to explain some problems that may be encountered […]

Set up Fusion SaaS BI Cloud Connector (BICC) to use Cloud Storage

For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of particular interest to Oracle Analytics Cloud customers, wanting to use the new Data Replication functionality from Fusion SaaS (for more details, […]

Fusion SaaS – Finding The View Object You Need for Data Extracts

For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool.  This pulls data from ‘View Objects’ in the Business Intelligence layer […]

Online document signing using Oracle Integration Cloud and Adobe Sign

Introduction   Here is a typical process for document signing: The document is downloaded and sent via an email. The recipient then prints, signs, scans and emails the document back. The document is uploaded back to the system of records. This process is slow and tedious, but still works for a single recipient. What if […]

Integration Cloud – File Handling Primer

Introduction The objective of this blog is to introduce to the reader all available file-based options in Oracle Integration Cloud (OIC). The blog will cover the various tools and techniques available for developers for designing file-based integration solutions The Integration Cloud documentation does contain these in relevant sections. This blog intends to present only the […]

BI Cloud Connector – Deletion of Data Extract Files on UCM

Introduction This blog post is the continuation of the formerly shared article about BI Cloud Connector (BICC) Data Extraction File Downloading. In the previous blog post I gave an introduction into BICC and we discussed the options how to download the data extraction files from Storage Cloud or the internal built-in Universal Content Management (UCM) […]

Continuous Integration with Apiary, Dredd, and Wercker

There are many tools in the market to design, develop, and test API’s. Some of these tools could be used separately. Some others could be combined. Every time a change is introduced in the design or implementation of an API, it would be nice to have tests and builds run automatically. Continuous Integration (CI) is a software […]

Testing latency and throughput

Purpose This article is meant to provide steps to test latency and throughput between servers and/or datacenters. The tests described here are not meant to test application performance from and end user perspective.   Overview This post will provide an overview of some basic throughput and latency testing. Before testing, check your route. Is it […]

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 […]

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 […]

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 […]