I haven’t tried it myself, but as Sqoop is “yet another JDBC client”, I think that it generally should work.
One thing that you might need to do extra is to ensure that the all the SSL relevant files (trust strore, …) are either available on all nodes in your cluster or ship them to backend via “-file” argument. I’m expecting that it will be required because Sqoop can open connection to the database from any node in the cluster. Jarcec > On Oct 27, 2015, at 3:57 AM, Pablo Torre <[email protected]> wrote: > > Hi guys, > > I was reading a book about Hadoop Security , and I realized that Sqoop can be > configured to connect to a database that supports SSL with SSL enabled. > > Something similar to this: > > $ URI="jdbc:mysql://mysql01.example.com/sqoop" > $ URI="${URI}?verifyServerCertificate=true" > $ URI="${URI}&useSSL=true" > $ URI="${URI}&requireSSL=true" > ... > > Anyone tried it? I would appreciate any help with this. > > Best, > > -- > Pablo Torre. > Freelance software engineer and Ruby on Rails developer. > Oleiros (Coruña) > Personal site > My blog
