Oracle has recently released OAC with Private Access Channel(PAC). PAC is used to connect OAC with private data sources for e.g. Database hosted in private network such as OCI private subnet, on-premise corporate network and other Clouds.

At present there is not any Automated Tool exists for OAC Deployment on OCI, which means in order to setup an OAC instance manual steps are needed However, there is a solution to automate these steps and use Terraform based Auto Deployment Process for OAC (Private) with PAC on OCI and you can use this Tool to Create and Drop more and more…


ODI stands for Oracle Data Integrator which is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services.

An ODI migration typically means the migration of “master Repository “ and “work Repository” from source to target environment. Although, ODI Studio provides a tool for exporting and importing ODI master and work repositories, it only works when source and target Instances are on same ODI repository version. …


At present there is not any Automated Tool exists for OAC Deployment, which means in order to setup two OAC instance manual steps are needed on both instances. For example, if we need to setup Remote Data Gateways on two OAC instances then following manual tasks are required to perform for each Instance.

  1. Provision the OAC with providing all required Size and Shape Parameters.
  2. Download Remote Data Gateway(RDG) Setup from Oracle OAC Website
  3. FTP RDG Setup to RDG Linux Compute.
  4. Either Setup Display on RDG Linux Compute or Create Response File to install Remote Data Gateway
  5. Execute RDG Setup and…

Amit Tyagi

Oracle Cloud Solution Architect, Oracle Analytics Architect

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store