Installation Steps for Oracle Integration Cloud Service Connectivity Agent

Oracle Integration Cloud Service (ICS) is one of the major Cloud Integration platforms which enables Line of Business (LOB) users to easily build SaaS to SaaS and SaaS to On-Premises integrations in just few clicks.

ICS provides an agent framework that enables you to create integrations and exchange messages between on-premises applications and Oracle Integration Cloud Service.  This type of agent is known as Connectivity Agent. 

The Connectivity Agent is installed and runs in an on-premises environment on the same network as internal systems such as Oracle Database, Oracle Siebel, Oracle E-Business Suite and others.

Configure WinSCP to Use SFTP with Oracle Compute Instance

WinSCP is a popular useful windows utility which is easy to use as long as users have access to a SSH server with SFTP/SCP support. 

WinSCP lets users to move files on their remote server, change permissions, create new directories or delete them. They can also edit a file directly from WinSCP by using its internal text editor. Also an external text editor can be integrated with WinSCP.

This blog post shows on how to configure WinSCP to use with Oracle Compute Instance using the Private key.

Configure Putty to SSH Into Oracle Compute Instance

In Cloud Computing environments there are many reasons why users need to access the VM environment to perform certain tasks.  Due to security concerns, Cloud vendors generally accept incoming access requests using Secure Shell (SSH) connections.

This blog post shows detailed information on how to configure Putty to access a Linux based Oracle Cloud Compute Instance using SSH.

Clone Block Storage Volumes in Oracle Cloud Infrastructure in Seconds

As per recent announcement, Oracle Cloud Infrastructure (OCI) has added the capability to clone a Block Storage Volume in seconds.  This is an important milestone at a time where cloud wars are experienced between various cloud platform vendors.

Cloning of a Block Storage volume is a critical functionality required by many of the enterprise customers.  How quickly a clone can be created is an important aspect for a Cloud Infrastructure provider.  

Does the time taken to create a clone of a block storage volume vary depending on the capacity of the block storage volume i.e., in GBs to TBs?

Configure Oracle SQL Developer to Connect to Database Cloud Service Using SSH

In the previous blog post, I have shown on how to create a new Oracle Database Cloud Service (DBCS) using Oracle Cloud Infrastructure Classic environment.

In this blog post, I will show on how to configure Oracle SQL Developer tool to get connected to the DBCS service in the cloud.

By default the DBCS listener port (default value is 1521) is not exposed to the outside world so tools like SQL Developer cannot be used to get connected to the Database Cloud Service.

So how do we get connected to the Database to perform the usual basic activities such as creating tables etc?

Create Database Cloud Service (DBCS) using Oracle Cloud Infrastructure Classic

Most of the applications do require a Relational Database to store and retrieve data.  With the introduction of Cloud based database by various Cloud vendors enable organisations to pay a subscription fee to own a database which would be fully managed by the Cloud provider.

All the major software vendors such as Oracle, Amazon, Google and Microsoft do have options to subscribe to a Database Cloud Service.

This blog post shows how quickly and easily an Oracle Database can be provisioned in the Oracle Cloud Infrastructure Classic (OCI Classic) environment.  Please note that OCI Classic was previously known as Oracle Public Cloud (OPC).

Oracle ICS Stage File Action To Combine Results Inside a Loop

With Oracle Integration Cloud Service (ICS), Enterprise grade Cloud Integrations can be developed in less time compared to the usage of traditional middleware tools.

This blog post addresses on how to combine the results of multiple calls to return the result set through ICS.

Use Case

Requirement is to invoke a service hosted at a SaaS application and return the result set.  But each record in the result set from the SaaS service contains Ids. Due to this, the result set has to be iterated through to make further calls to SaaS services based on Ids to retrieve the relevant details and each record is populated with the results from multiple calls.