1. Install a VNC viewer on your local computer.

   Note:

   In order to access the ODI instance using VNC, perform the following:

   1. Log in to the provisioned ODI instance on Oracle Cloud Marketplace using SSH as opc user:

      ssh –i <private_key> opc@<<IP Address>

   2. Execute the following firewall commands to open the VNC ports:

      sudo firewall-cmd --permanent --new-service=odissh
      sudo firewall-cmd --permanent --service=odissh --set-description="ODI SSH
      server"
      sudo firewall-cmd --permanent --service=odissh --add-port=5901-5905/tcp
      sudo firewall-cmd --permanent --add-service=odissh
      sudo firewall-cmd --reload

2. Use SSH to connect to the compute instance running the Oracle Data Integrator Image, as described in Connecting to ODI Compute Instance .
3. On your local computer, connect to your instance and create a ssh tunnel for port 5901 (for display number 1):

   $ ssh -L 5901:localhost:5901 –i id_rsa oracle@<IP Address>

4. On your local computer, for the VNC to work, add an Ingress rule as follows:

   No 0.0.0.0/15 TCP All 5901 TCP traffic for ports: 5901

5. On your local computer, start a VNC viewer and establish a VNC connection to localhost:1.
6. Enter the VNC password that you had provided during the stack creation.
7. For connecting multiple users, after the vncpasswd utility exits, start the VNC server by typing vncserver. This will start a VNC server with display number 1 for the oracle user, and the VNC server starts automatically if your instance is rebooted. For example vncserver@:2 or vncserver@:3.

To launch the ODI instance,

1. From the Applications menu, navigate to Programming -> ODI Studio

   or

   Double click the short icon for ODI Studio present in your Desktop

   or

   Navigate to the location $MW_HOME/oracle/odi/studio/bin/odi in the VNC.

2. Connect to the repository with already populated login credentials. The Login Name value varies based on the selected repository. For ADB repostiory, the Login Name is ODI_ADW_REPO and for MySQL Embedded repository it is ODISA_MYSQL.

3. Post successful configuration, check if the newly created data server is available in the Topology navigator -> Technologies -> Oracle.

   
   Description of the illustration data-server.png

   For more details on MySQL services, refer to Troubleshooting ODI on OCI

   .

4. In ODI studio, navigate to Topology -> Physical Architecture -> Agent -> OracleDIAgent1 and click Test, to check if the Standalone Agent is working.

5. Depending on your network, you may need to provide proxy details for the database server JDBC connection.

   
   Description of the illustration jdbc_connection_url.png

6. Click Test connection, to check if the created ADB Dataserver is working.

7. Depending on your network, you can setup a proxy for ODI. In ODI Studio, navigate to Tools, Preferences, Web Browser and Proxy, to setup a proxy for your network. Proxy may be required for accessing certain hosts, for example - Oracle Object Storage.

   Note:

   Depending on your OCI network configurations, you may or may not require access through proxy-hosts. While you are connecting through proxy, make sure that the proxy address/port or the source dataserver is allowed through OCI VCN configurations.

   Note:

   If you are using a BI Cloud Connector Dataserver, you may need to add the BI Cloud Connector host to the Proxy Exclusion field.

Connecting to the Pre-created ADB Dataservers in ODI Repository

Connect to the readily available or pre-created ADB dataservers in ODI studio. You have to add actual username and password by connecting to the dataserver, do a test connection and continue with your data integration project in ODI studio.

Using Dataserver Setup in ODI Studio

You can create additional ADB Dataservers using the Oracle technologies Dataserver setup in ODI Studio.

Upon successful test connection, the new Dataserver gets created in the ODI repository.