Tuesday 23 September 2014

Sqoop Import from SQL Server, MySQL, Oracle in CDH5


mkdir -p /var/lib/sqoop
chown sqoop:sqoop /var/lib/sqoop 
chmod 755 /var/lib/sqoop
$ sudo cp mysql-connector-java-version/mysql-connector-java-version-bin.jar /var/lib/sqoop/

1. Connect to SQL Server
--connect jdbc:sqlserver://ip_address;instanceName=ins_name;database=db_name

2. Connect to MySQL
--connect jdbc:mysql://ip_address/db_name

3. Connect to Oracle
--connect jdbc:oracle:thin:@ip_address:1521/db_name



Reference:
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/CDH5-Installation-Guide/cdh5ig_jdbc_driver_install.html

No comments:

Post a Comment