Configuration of tSqoopimport in CommandLine and Java API mode

Configuration of tSqoopimport in CommandLine and Java API mode to transfer data from a relational DB to HDFS.

Additional Versions

Cloudera 5.7, Talend 6.3.1.20161216_1026

Product (Required)

Talend Data Fabric

Component (Required)

tSqoopImport

Problem Description

How-to make tSqoopImport work in Commandline and API mode.

Problem root cause

N/A

Solution or Workaround

Server side preparation

Add database drivers into the /var/lib/sqoop folder.

Run a script on the Hadoop server side to ensure that sqoop has been installed and is configured properly, and there are no connection problems with the relational database that stores the data you're copying (substitute your own values as appropriate).