FAQ: Integrating E-Business Suite using Integration Cloud Service

1. Is the connectivity agent necessary for the EBS Adapter even when my services are deployed inside DMZ and publically accessible. No. The connectivity agent is only required when EBS REST services are not available on public internet. 2. Can I connect to EBS database from ICS and invoke PL/SQL procedures? Yes, you can use […]

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

Integrating with Oracle Field Service Cloud using ICS REST adapter

Oracle Field Service Cloud (OFSC) helps transform Customer Experience by building efficient field service solutions. It is built on time-based, self-learning, and predictive technology. Oracle Integration Cloud Service (ICS) provides the Oracle Field Service adapter (OFSC adapter) to create inbound and outbound integrations with OFSC. Refer here for OFSC adapter documentation. The OFSC adapter can be […]

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

A python REPL for accessing the ICS via REST API

What it is This is a small set of python, wrapped into a REPL for easy interaction with ICS in bulk. It has the ability to be fed simple scripts that can perform various tasks, as well as interactive capability. It is the culmination of much playing around with the ICS REST API over the […]

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

ICS Connectivity Agent stdout Log Rotation

When monitoring and/or troubleshooting the ICS Connectivity Agent server, it is important to not only have the standard logs (e.g., AdminServer-diagnostic.log) but also the standard out/error (stdout/stderr).  One of the big challenges of capturing the stdout is not exhausting the disk storage over time.  Since the ICS Connectivity Agent is a WebLogic server installation, there […]

Integrating with ERP Cloud using ICS

Introduction Integration Cloud Service (ICS) is a PaaS cloud offering from Oracle that provides capabilities of integrating applications both on-cloud and on-premise (on-prem). ICS provides rich set of connectors/adapters to connect to Oracle’s SaaS and on-prem applications and many third-party cloud and on-prem applications. One such connector that ICS provides is the Oracle ERP Cloud […]

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

Connecting ICS and Apache Kafka via REST Proxy API

Introduction Apache Kafka (Kafka for short) is a proven and well known technology for a variety of reasons. First it is very scalable and has the capability of handling hundreds of thousands of messages per second without the need of expensive hardware; and close to zero fine tuning, as you can read here. But another […]

Using Oracle Managed File Transfer (MFT) to Push Files to ICS for Processing

Introduction In a previous article I discussed the use of the Enterprise Scheduler Service (ESS) to poll for files, on a scheduled basis, to read from MFT.  In that article we discussed how to process many files that have been posted to the SFTP server.  At the end of that article I mentioned the use […]

ICS Connectivity Agent – Update Credentials

When installing the Connectivity Agent, there are several mandatory command-line arguments that include a valid ICS username (-u=[username]) and password (-p=[password]). These arguments are used to verify connectivity with ICS during installation and are also stored (agent credentials store) for later use by the agent server. The purpose of storing them is to allow the […]

Understanding the Enterprise Scheduler Service in ICS

Introduction   In many enterprise integration scenarios there is a requirement to initiate tasks at scheduled times or at user defined intervals. The Oracle Integration Cloud Service (ICS) provides scheduling functionality via the Oracle Enterprise Scheduler to satisfy these types of requirements.  The Oracle Enterprise Scheduler Service (ESS) is primarily a Java EE application that […]

Integrating Sales Cloud and Service Cloud using ICS – troubleshooting issues with security configuration

Introduction This blog talks about a few “gotchas” when integrating Oracle Sales Cloud (OSC) and Oracle Service Cloud (OSvC) using Oracle’s iPaaS platform, the Integration Cloud Service(ICS). The idea is to have a ready reckoner for some common issues faced, so that customers can hit the ground running when integrating between OSvC and OSc using […]

Eloqua ICS Integration

Introduction Oracle Eloqua, part of Oracle’s Marketing Cloud suite of products, is a cloud based B2B marketing platform that helps automate the lead generation and nurture process. It enables the marketer to plan and execute marketing campaigns while delivering a personalized customer experience to prospects. In this blog I will describe how to integrate Eloqua […]

Integrating Big Data Preparation (BDP) Cloud Service with Business Intelligence Cloud Service (BICS)

Introduction This article presents an overview of how to integrate Big Data Preparation Cloud Service (BDP) with Business Intelligence Cloud Service (BICS).  BDP is a big data cloud service designed for customers interested on cleansing, enriching, and transforming their structured and unstructured business data.  BICS is a business intelligence cloud service designed for customers interested […]

Uploading a file to Oracle storage cloud service using REST API

Introduction This is the second part of a two part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service. In the previous article of this series, we demonstrated Oracle GoldenGate functionality to write to a flat file using Apache Flume File Roll Sink. If you would […]

Bulk import of sales transactions into Oracle Sales Cloud Incentive Compensation using Integration Cloud Service

Introduction Sales Cloud Incentive Compensation application provides API to import sales transactions in bulk. These could be sales transactions exported out of an ERP system. Integration Cloud Service (ICS) offers extensive data transformation and secure file transfer capabilities that could be used to orchestrate, administer and monitor file transfer jobs. In this post, let’s look […]

Publishing business events from Supply Chain Cloud’s Order Management through Integration Cloud Service

Introduction In Supply Chain Cloud (SCM) Order Management, as a sales order’s state changes or it becomes ready for fulfillment, events could be generated for external systems. Integration Cloud Service offers Pub/Sub capabilities that could be used to reliably integrate SaaS applications. In this post, let’s take close look at these capabilities in order to […]

Best Practices – Data movement between Oracle Storage Cloud Service and HDFS

Introduction Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for data that is uploaded from the customer’s data center. Big Data Cloud Service ( BDCS ) supports data transfers between Oracle Storage Cloud Service and HDFS. Both Hadoop and Oracle […]