Best Practices from Oracle Development's A‑Team

Oracle Data Integrator Cloud Service (ODICS) : Where to Run Studio

Oracle Data Integrator (ODI) is now available as a Cloud Service: Oracle Data Integrator Cloud Service (ODICS). For customers who are interested in a subscription model for their ODI installation and want to integrate and transform data in the Cloud, this is the solution.

Start by deploying ODICS following the Oracle By Example document Provisioning Oracle Data Integrator Cloud Service.

As detailed in above document, when deploying ODICS it comes with ODI Studio which users will access with VNC. Do not try to use ODI on Premise when connecting to a Cloud Repository or you will experience very painful performance and timeout .... ODI Studio is chatty and needs to be close to its Repository.

What about having multiple users? What are the other alternatives to use Studio in the Cloud?

1. Multiple developers

When deploying ODICS, the choice of the shape has a direct impact on the number of developers you can run in parallel.
We have observed that

1 OCPU=1 Agent and/or 1 OCPU=1 Studio

So, deploying ODICS on a 4 OCPUs shape would allow to deploy, for example, 2 Agents and to connect using 2 distinct Studio, using distinct VNC Servers.

In order to have multiple users to connect to VNC Server you can create multiple Linux users on the server where your ODICS is deployed as described in the Article

"Oracle Linux: How to configure VNC Server on OL6" (Doc ID 2113867.1) or  https://wiki.centos.org/HowTos/VNC-Server

2. ODICS Studio

If you do not have enough OCPUs on your ODICS instance, another solution is to install ODI Studio on Compute Cloud Service. Either on a Windows Image as detailed in Deploying ODICS Studio on a Windows Image (Compute Cloud Service) either on a Linux Compute Image, as detailed bellow.

Note that if you choose to install it on a Windows Image you can only have ONE Studio per Instance as the provided Windows image does not allow more than one remote user. But, as we have seen above, when connecting to Linux we can connect multiple users, as long as there is enough memory

We have observed the same rule

1 OCPU=1 Studio

Do not install or run any Agent as this has a direct impact on licensing. As long as only ODICS Studio is used, the only cost is the Compute Cloud Service one.

To install ODI Studio on Compute Cloud Service:

  • Create a Compute Instance and deploy a Linux Image (for example Linux 6.6)
  • Start a VNC Server and connect using Putty for example (refer to  ODI on Compute Cloud Service: Step by Step Installation if more details are needed for that part)
  • Disable the screen saver
  • Add login.oracle.com to /etc/hosts file
  • Download the same ODI version than ODICS (today, May 2017, this is ODI
  • Download JDK 1.8.0_101 and later (for example jdk-8u101-linux-x64.rpm )
  • Apply Recommended patches, for example

25436913 ODI Studio Performance Issue When Trying To Create A Project, Folder etc..
24622481 new Salesforce Technology required for use with Data Direct JDBC Driver

As a reminder – referring to readme file:

Set variables:
setenv ORACLE_HOME=/u01/app/oracle/middleware
setenv PATH=${PATH}:/u01/app/oracle/middleware/OPatch

unzip patches
opatch apply

  • Install ODI Studio following Installation Guide for Oracle Data Integrator: HTML
    Start the installer by running /home/Oracle/Java/jdk1.8.0_101/bin/java —jar fmw_12.
    Select the Standalone installation as we do not need any J2EE Component
  • Once installed, start ODI Studio and create a new login to your existing ODICS Repository. If needed, create a link between your Compute Image and the DBCS instance where the repository is running by creating a Security Rule (this is detailed in Deploying ODICS Studio on a Windows Image (Compute Cloud Service) / Create a link between DBCS and your Windows Image)


For more ODI best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners, visit Oracle A-Team Chronicles for ODI.


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha