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.