Before You Begin

This 30-minute tutorial shows you how to how to obtain the Public IP of your service instance, configure PuTTy to connect to your VM and start VNC server, and then launch ODI Studio.

Background

Now that you have your Data Integration Platform Cloud services provisioned, you can configure VNC server for your VM and launch ODI Studio.

What Do You Need?

• Your Oracle Cloud account
• A Data Integration Platform Cloud subscription
• Database Cloud and Data Integration Platform Cloud services provisioned
• PuTTy or other SSH client
• Your private key in a PuTTy-compatible or OpenSSH format (Need a new key pair? Learn how to update your private/public keys.)
• VNC Viewer

Obtaining the Public IP of your Data Integration Platform Cloud Instance

1. After you log in to Oracle Cloud, open the navigation menu in the upper left corner, select Platform Services, and then Data Integration Platform or Data Integration Platform Classic.

   

2. Select your Data Integration Platform Cloud instance from the list of services.

   

3. In the Services Overview, locate the Resources section and copy the Public IP.

   

Verifying Your Listening Port

1. Open PuTTY and connect to your Data Integration Platform Cloud instance using the Public IP.
2. Switch to the opc user:

   $ sudo su - opc

3. Start VNC Server:

   $ vncserver -nolock

4. Verify that VNC Server is running:

   $ ps -ef |grep vnc

5. Verify the listening port:

   $ netstat -tulpn

   Take note of the port number. For the purposes of this tutorial, the listening port number is 5901.

6. (Optional) Use Telnet to test the connection:

   $ telnet 127.0.0.1:<listening_port_number>

7. Close the PuTTy window.

Configuring PuTTy to Connect to Your VM and Start VNC server

1. Open PuTTy.
2. Enter your instance's Public IP address into the Host Name field.

   

3. In the Category pane, expand Connection, select Data, and then enter opc in the Auto-login username field.

   

4. In the Category pane, under Connection, expand SSH, and select Tunnels.
5. Enter the listening port number for VNC Server in the Source port field and 127.0.0.1:<listening_port_number> into the Destination field, then click Add.

   

6. In the Category pane, under SSH, select Auth.
7. For Private key file for authentication, click Browse and locate your private key.

   

8. In the Category pane, select Session, and then enter a name for this session under Saved Sessions and click Save.

   

9. Click Open to establish the connection.
10. After you've successfully connected, enter the following command to switch to the oracle user:

    $ sudo su - oracle

    

11. Enter the following command to start VNC server:

    $ vncserver -nolock

    

    If you're prompted to enter a password to connect to the VNC server, enter a password and confirm the password. VNC server will start automatically.

    The SSH tunnel redirects the VNC output of your VM to localhost (127.0.0.1).

12. Open Tiger VNC Viewer, enter 127.0.0.1:<listening_port_number> in the VNC server field, and then click Connect.

    

13. Enter the password that you set in step 11 and click OK.

    

14. After you've successfully connected to your VM with VNC viewer, your desktop appears similar to the following:

    

15. (Optional) Disable the screen saver to avoid getting locked out of the instance. In the System menu, go to Preferences, and select Screensaver. Deselect Activate screensaver when the computer is idle, and then click Close.

    

    Alternatively, you can set a password for the opc user.

Launching Oracle Data Integrator 12c Studio

1. Open a Terminal window and enter the following:

   /u01/app/oracle/suite/suite_mw/odi_studio/odi/studio/bin/odi

   

2. Oracle Data Integrator Studio 12c starts and is ready to use.

   

Granting users access to ODI Studio

1. Using Identity Cloud, you can assign roles to users to access ODI Studio through Data Integration Platform. You can assign any of the following roles:
   • Administrator (Service application administrator role), which is equivalent to ODI Supervisor
   • Developer (Service application developer role), which is equivalent to ODI Designer
   • User (Service application user role), which is equivalent to ODI Operator

   For more information on how to assign roles to users, see Manage Security for Services Instances.

Connecting to the ODI Repository

1. From your Oracle Cloud Service Console, locate your service instance, and then from the Manage this Service menu, select Open WebLogic Server Console.

   

2. Log in to the WebLogic Server Console.

   

3. In the Change Center panel, click Lock & Edit.

   

4. In Domain Structure, expand Services, and then click Data Sources.

   

5. Select odiMasterRepository from the list of Data Sources.

   

6. Under Settings for odiMasterRepository, click Connection Pool, and then copy the user and URL values.

   

7. Back in ODI Studio, click Connect to Repository.

   

8. In the Oracle Data Integrator Login dialog, click New.

   

9. In the Repository Connection Information dialog, complete the fields. Paste the user and URL values from the WebLogic Server Console into the User and URL fields in the Database Connection (Master Repository) section. Use your WebLogic Server as the Master Repository password.

   

10. Click Test to test the connection details. If successful, click OK. If not successful, go back to the WebLogic Server Console to check your user and URL details.

Want to Learn More?

• Data Integration Platform Cloud on Oracle Help Center
• Oracle Data Integrator on Oracle Help Center