SQLJDBC4.jar - where to put it?

Warren — Tue, 21 Apr 2026 14:01:33 GMT

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?

Re: SQLJDBC4.jar - where to put it?

abe — Fri, 20 Jun 2014 17:04:39 GMT

Hey there,

Have you tried /var/lib/sqoop2?

-Abe

question SQLJDBC4.jar - where to put it? in Archives of Support Questions (Read Only)

SQLJDBC4.jar - where to put it?

Re: SQLJDBC4.jar - where to put it?