Import data from other RDBMS

Preamble

This article describe how import data from other RDBMS of Oracle, Mysql, Postgres and MS SQL Server.
SQOOP use JDBC to connect databases. Be sure to have the .jar file to access your database.

Process

Before launch the SQOOP script be sure the job can download the .jar. Here an example to download from HDFS in the /var/lib/ folder.

hdfs dfs -get /var/lib/my_JDBC_file.jar

Add the .jar file to the HADOOP_CLASSPATH environnement variable.

export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:./my_JDBC_file.jar

Run the SQOOP script.