= 2013-12-01 =

== import data from MS SQL Server using Sqoop ==

 * <參考> [https://www.facebook.com/notes/james-chang/using-sqoop-to-improt-data-from-microsoft-sql-server-under-cloudera-cdh-440/730480376969050 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
 * <來源> [http://www.microsoft.com/zh-tw/download/details.aspx?displaylang=en&id=11774 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/
}}}