Call Us @ +91 97873 71365 , +91 88252 47866

Connecting ODI 12c to Oracle Public Cloud (OPC)

November06

Connecting ODI 12c to Oracle Public Cloud (OPC)

Toolkit:

Oracle VM VirtualBox
ODI 12c Virtual Machine – download from OTN here.
Oracle Public Cloud (Trial version will work)
SSL tunneling via odi_ssl.jar
SSH Key from when you created your OPC database

This post will not go into signing up for the trial, but I will identify parameters necessary to configure the ODI connection.

 

Get Parameters from your OPC Database:

Public IP: x.x.x.x
SQL *Net Port: 1521 (default)
User Name: oracle (default)
Connect String: <dbname>:1521/PDB1.<identity domain>.oraclecloud.internal
Administrator Password: (this was established when you provisioned the OPC database)

OPC DB1

 

 

OPC DB2

Now that you have this information, let’s get into ODI 12c VM and connect to this database.

From your toolkit, spin up the ODI 12c Getting Started VM.

You now need to do two simple setups before launching ODI 12c in order to enable connectivity to the OPC Database Service.

  1. Copy the odi_ssl.jar file referenced in the toolkit to the following directory: /u01/Middleware/Oracle_Home_1213/odi/sdk/lib
  2. Copy your private key file to a directory of your choice on your guest OS. ie: /home/oracle/Documents/ODI/MyDBaaSKey.txt
  3. Launch and log into ODI 12c Studio.

OPC_ODI

 

Now that you have logged in, we will create a New Data Server which will be the connection to the OPC Database Service.

  1. Expand the Technologies tree under the Topology tab, right click the Oracle Technology, and create a new Data Server.

OPC_ODI2

  1. The Definition tab will open
    • Provide a name for the Data Server
    • Enter your OPC Database Server administrator account and password. I am using system with the password established during the provisioning of the database.
    • Save your setting, and click OK on the Information popup.

OPC DB4

 

OPC DB5

Note that the location we copied the odi_ssl.jar file is important as this is where ODI looks for the drivers. Your implementation may have a slightly different location if you ODI_HOME is in a different path, but if you are using the VM from OTN, you should be fine.

Unlike the normal process of using the search feature to find the JDBC Driver, you will have to manually enter the information below.

  1. Click the JDBC tab and enter the JDBC Driver and JDBC URL
    • JDBC Driver: oracle.odi.example.SSLDriver
    • JDBC URL: jdbc:odi_ssl_oracle:thin:@localhost:5656/PDB1.<identity domain>.oraclecloud.internal

OPC DB6

  1. Review your OPC parameters collected earlier and click on the Properties tab and create the Key | Value pairs by clicking on the green +
    • sslHost: <cloud ip address>
    • sslRHost: <cloud ip address>
    • sslUser: oracle
    • sslRPort: 1521
    • sslPrivateKey: <path to your private key>
    • sslPassword: <private key password>
  2. Save your connection information and click OK to any Information popups
 OPC DB7
  1. Test your connection

Click the Test Connection button. You can either choose an Agent or use the Local (No Agent). If everything went well, you should get a Successful Connection notification.

OPC DB8

Next we will use this connection to perform some E-LT operations from on premise to our DBaaS.

 

  • Posted by asquare technologies
  • 1 Tags
  • 0 Comments

CATEGORIES Uncategorized

COMMENTS

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>