06-18-2014 06:05 AM
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?