Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQLJDBC4.jar - where to put it?

Solved Go to solution
Highlighted

SQLJDBC4.jar - where to put it?

Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: SQLJDBC4.jar - where to put it?

Expert Contributor

Hey there,

 

Have you tried /var/lib/sqoop2?

 

-Abe

1 REPLY 1

Re: SQLJDBC4.jar - where to put it?

Expert Contributor

Hey there,

 

Have you tried /var/lib/sqoop2?

 

-Abe