SQLJDBC4.jar - where to put it?

[#1]

I downloaded and installed the latest Cloudera package on a 3-node linux cluster.  Now I need to import data from MS Sql Server 2012.  I've downloaded sqljdbc4.jar from Microsoft, but I don't know where to put it.  All the docs I've found say to put in /usr/lib/sqoop/lib/ or similar.  But it appears Cloudera installed Hadoop et. al. in /opt/cloudera/parcels/CDH/... there is no /usr/lib/sqoop on my system.

I tried putting it in /opt/cloudera/parcels/CDH-5.0.1-1.cdh5.0.1.p0.47/lib/sqoop2 but that didn't seem to help.

I'm using the Hue UI and trying to set up a scoop import job.  The only DB connector available is the Generic JDBC connector.  How do I get my sqljdbc4.jar connector on the drop-down list so I can use it?  Do I need to move the jar file to a different directory?  I did try restarting the Hue and SQOOP2 services, but that didn't help either.  I'm baffled, please help?

[#2 · Accepted solution]

Hey there,

Have you tried /var/lib/sqoop2?

-Abe