Based on our experience, in the on-premise world, most ODI Developers are using ODI Studio on Windows. So, we thought detailing how to deploy ODICS on a Windows Image on Compute might be useful. This can be used to connect to an ODICS Repository that has already been installed.
PLEASE NOTE THAT THIS IS ONLY FOR STUDIO – USING AN AGENT ON COMPUTE AS AN IMPACT ON LICENSING
It is now possible to deploy a Windows Server Image in Compute Cloud.
Although Linux images can be deployed out of the box from Compute Cloud Service, to get the Windows Image it is required to go to the Market Place and select the Microsoft Windows Server 2012 R2 Standard image.
Once the image selected, it is required to have the Administrator privilege to be able to install it on your Compute Cloud Service
The “administrator_password” is the password that will be used to access your Image once deployed – this is NOT your Oracle Cloud password. You can choose any password and then change it just before deploying your image in a next step. Do not worry to see it in clear text!
If you do not see the screen shown above, you have a problem linking the Market Place to you Oracle Cloud Account. In that case make sure you have checked the right preference for your Oracle Cloud Account:
After clicking on Install you will get after a while:
Once you have that nice picture it means you can select this image to create a Compute Instance.
Just follow the bellow screen shots
Follow the documentation: Accessing a Windows Instance Using RDP
Once you have followed the above steps to enable RDP access, you can connect to your instance using the Remote Desktop Client (select the IP of your Compute Instance) – connect as Administrator and change the password to make it secure.
Once you are connected to your Windows Image, just follow the standard steps to install ODI.
I recommend the following steps:
to host in C:\Windows\System32\drivers\etc
We need to access a DBCS instance either to connect to an existing Repository or either to create one. In order to connect the Compute Instance with DBCS we need to create a Security rule:
Open the Compute Service Console and select the Network Tab. Click on Create Security IP List to start.
Creating this list will enable the communication between the VMs on Port 1521.
You can chose to either connect to an existing one or create a new one
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”.
Special thanks to David Allan, Oracle Data Integration Architect, for his help and support.