I have not tried the Oracle thin JDBC driver with Sqoop myself, but I suspect you need to set the SSL related properties as java options via HADOOP_OPTS similar to this write-up: http://hortonworks.com/blog/how-to-do-secure-apache-sqoop-jobs-with-oracle-wallet/
To test whether packets are secured, you could use something like wireshark. For DataDirect Oracle JDBC drivers, there is packet logging built in which can be enabled via JDBC URL connection options. Sumit 919-461-4284 From: Suraj Nayak [mailto:[email protected]] Sent: Friday, July 17, 2015 6:11 AM To: Sumit Sarkar Cc: [email protected]; [email protected] Subject: Re: Does Sqoop 1.4.4 support JDBC over SSL? Hi Sumit, I am using Oracle JDBC. Is it based on Java Secure Socket Extension (JSSE) ? What I think is, we need to set some flags by passing it to JDBC url parameter. That should take care of it. Correct me if am wrong. Also, how do you test the connection whether data packets are actually secured? Thanks! On Thu, Jun 25, 2015 at 1:54 PM, Sumit Sarkar <[email protected]<mailto:[email protected]>> wrote: Which driver(s) are you trying and what issue have you faced? SSL is transparent to sqoop for the DataDirect JDBC drivers I have been testing. From: Suraj Nayak <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Sunday, June 21, 2015 at 7:20 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Does Sqoop 1.4.4 support JDBC over SSL? Hi Sqoop Users and Developers, Does Sqoop 1.4.4 support JDBC over SSL? If yes, how can I enable it? If no, which version of sqoop supports JDBC over SSL? Or any workaround for making sqoop work on SSL? Any help and pointers is well appreciated :) -- Thanks Suraj Nayak M -- Thanks Suraj Nayak M
