Connection with Oracle db in sqoop


#1

Sir how to link oracle db jar for sqoop as you showed in the video that already for
"mySql the jars point to a particular location similarly how to do it for oracle db to get the connection",

leaving reference for understanding in sqoop to create a connection this is mandatory,how to do it for Oracle db,how to make that point to the particular location/

Ex: mysql-connector-java.jar—>/usr/share/java/mysql-connector-java.jar


#2

You can download the jar file from the below link:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Copy the Oracle JDBC Jar file to the Sqoop lib directory.

Then you can use the corresponsding Sqoop command to connect to Oracle db in sqoop/