2013-12-01

import data from MS SQL Server using Sqoop

• <參考> ​Using sqoop to improt data from Microsoft SQL Server under Cloudera CDH 4.4.0
• Step 1 : download Microsoft JDBC Driver 4.0 for SQL Server
• <來源> ​Microsoft JDBC Driver 4.0 for SQL Server

  wget http://download.microsoft.com/download/0/9/E/09E1D1A1-79F6-4BC2-969B-406EC77C7277/sqljdbc_4.0.2206.100_cht.tar.gz
  

• Step 2 : extract the archive file and copy jar files into /usr/lib/sqoop

  unzip sqljdbc*.tar.gz
  sudo cp sqljdbc_4.0/cht/*.jar /usr/lib/sqoop/