Posted by : Arjun Lagisetty Monday, February 22, 2016

For us, Data Geeks. Security is least of our concern it's somewhere in back of our minds, scratch that may be it's not even there. When it comes to ODI administration, Some admins out there think that security is just creating restrictive profiles for user roles in Security Navigator. That's only part of the security solution. But have you ever considered security over Wire, We are moving tonnes of data over the network where it's prone to sniffing and tapping. Most of our work loads often happen behind the firewall in our data center but, in this cloud era where we are sharing the network with others it's important to consider encrypting data over the wire.

In this blog topics we are limiting our discussion to, connecting to Oracle Databases using JDBC thin driver.

Pre-requisites:

Features are only available in Oracle 11g r2. Oracle DBA has to enable Oracle Advanced Security on the server side.

Configuration:

  • Navigate to Topology
  • Select the Oracle data server to add properties.
  • On the Properties tab click Add a Property.
  • Specify a Key identifying this property. This key is case-sensitive.
  • Specify a value for the property.
  • From the File menu, click Save.
You should set the following four properties for encrypting the client connection.



Optionally: You can also use the following parameters to enable authentication services.

See these links for more details:
https://docs.oracle.com/database/121/DBSEG/asojbdc.htm#DBSEG9613
https://docs.sdbor.edu/oracle/db11gr2/network.112/e40393/asojbdc.htm#ASOAG9608


Using Thick Drivers:
How to enable encryption using thick drivers?
https://kb.berkeley.edu/page.php?id=23274
How to use thick oci drivers in ODI?
http://blog.whitehorses.nl/2011/06/21/using-the-thick-oci-drivers-in-odi-11g-ide/

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty