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?
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
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:
As a reminder – referring to readme file:
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”.