Does Sqoop support SFTP protocol?

[#1]

Does Sqoop support SFTP protocol? Pulling data from mainframe using SFTP.

I see FTP is used but not sftp

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html

[#2 · Accepted solution]

@Sunile Manjee Very good questions..I don't think so but sqoop2 jira is open

https://issues.apache.org/jira/browse/SQOOP-2218

[#3]

Thanks @Neeraj Sabharwal. Outside of NiFi, what other options do we have to pull data from SFTP if sqoop does not support it?

[#4]

@Sunile Manjee Do you want to transfer data from RDBMS to Hadoop? Or any source?

[#5]

@Neeraj Sabharwal Transfer data using SFTP to hadoop.

[#6]

@Sunile Manjee https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-hdfs/WebHDFS.html

You can use webhdfs to transfer data into HDFS.

http://hortonworks.com/blog/webhdfs-%E2%80%93-http-rest-access-to-hdfs/