Posts: 26
Registered: ‎06-18-2014
Accepted Solution

SQLJDBC4.jar - where to put it?

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?

Cloudera Employee abe
Cloudera Employee
Posts: 109
Registered: ‎08-08-2013

Re: SQLJDBC4.jar - where to put it?

Hey there,


Have you tried /var/lib/sqoop2?