The Oracle BI Application Blogs provides the latest and tips and tricks on Oracle BI Applications Product (OBIA)

BIAPPS on PAAS – Source Connectivity

OBIA 11g: Oracle BI Applications Installation on Cloud Services, Doc ID 2136376.1 white paper describes how you can install BIAPPS on PaaS or in other words OBIA on the cloud. This article explains the options available to connect to various cloud and non-cloud sources using BIAPPS on PAAS.

Connectivity to Cloud Sources:


For supported cloud sources like Fusion and Taleo, BI Apps connects to the sources via https and then loads the data to the SDS. From there the data is transformed and loaded into the warehouse (DWH).

Connectivity to On Prem Sources:

There are two options when you need to load data from On Prem Sources to the BI Apps on PaaS.

Option 1: Using Corente VPN

In this option, you establish a VPN connection between the Oracle Cloud PaaS machines and the On-Prem source thereby allowing a two way communication between the two. From BIAPPS perspective, it is as though both machines are on the same network and no additional configuration is required. Diagram 2 below shows the data flow when using VPN. Refer to the Oracle Cloud Documentation for more information on Corente VPN.

Option 2: Using a Replication tool to load the SDS via ssh tunnel

In this option, you use a replication tool like DataSync (which comes with BICS), Oracle Golden Gate (has a cloud option as well) or any other mechanism to load the SDS via a SSH tunnel. The same is also shown in above diagram. The replication client could reside on the On Prem network and then configured to pull data from the On Prem source and load the SDS to the database on Oracle DBCS (Database Cloud Service). Data is then moved from the SDS to the warehouse by the ODI ETL mappings.


Comparison between the two options:



Bi-Directional tunnel.

Data flows from On prem to Cloud

Data is extracted at the time of ETL load. If load
on source is a concern, the ETL has to be timed to run when load on source is

is done outside the ETL load. Can be scheduled to run at a time when the load
on Source in minimal

Will need to spare additional OCPU for hosting
Corente Gateway on the cloud

Likely need
to host the Replication Tool client on an on-prem machine

SDS is not required for data from On-Prem Sources. Data loaded directly to the

SDS is
mandatory and to that extent additional space is required

No additional configuration required after
installing BIAPPS and registering the source

configuration required to setup the replication (specify tables to replicate, set up schedule to replicate etc)

Will work with all BIAPPS Mappings

BIAPPS Mappings which rely on Source PL/SQL packages or views may not be
supported on SDS

Both options have their pros and cons and the customer will have to understand them and accordingly decide which option is best suited for them. The choice solely rests with the customer and hence it is best he tries out the various options. Most of Oracle Cloud offerings (including BICS/Data Sync and Corente VPN) have trial versions that can be used for this purpose. Also note that the Replication to SDS is the customer's responsibility. BIAPPS can be configured to pick data from the SDS once loaded. 

Disclaimer: Refer to the latest BIAPPS and Oracle Cloud Documentation as things might have changed since this blog was written.

All blogs related to BIAPPS on PAAS


Join the discussion

Comments ( 4 )
  • Neil Ashton Thursday, April 6, 2017

    We are looking to install both OBIA and eBS source in the cloud.

    What are the options to get OBIA on Paas to exteact data from eBS on a seperate cloud? Can either of the solutions provided in this white paper be extended for a cloud source?

  • Guna Vasireddy-Oracle Thursday, April 6, 2017

    That will depend on the connectivity options that the cloud where EBS is installed, has. If it is on Oracle cloud for example, you can likely define a security rule that will allow direct connectivity between the EBS and OBIA. In that case, you just configure your ODI connection as normal. However you will need to see if the network latency is acceptable in such a case as that will have a bearing on the ETL load timing.

  • Neil Ashton Thursday, April 6, 2017

    Yes. Oracle Cloud.

    But I am not sure about how to define a "security rule that will allow direct connectivity"

    In this Blog (https://blogs.oracle.com/biapps/entry/the_3_different_modes_of), I can see that only direct options for BIApps are a JDBC connection or DBLink.

    Oracle cloud does not allow either of these and requires a SSH connections.

    In this blog (https://blogs.oracle.com/dataintegration/entry/odi_12c_and_dbaas_in) I can see that this is solved in ODI 12c, but BI Apps uses

    Do you have some further details on setting up a security rule that would get around this issue.



  • Guna Vasireddy-Oracle Friday, April 7, 2017

    Please refer to the Oracle Cloud documentation on how to setup network on the cloud. This link might be a starting point


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.