How Sqoop and Tera Data Connector for Hadoop differ from each other

Question

I'm very much confused between Sqoop & TDCH. My question is that which is recommended to implement different type of loads like Incremental, History and Append?

Answer 1

In order to make use of TD and HDFS distribution we must use TDCH jar while exporting data from TD into HDFS.

TDCH supports hive, HCatalog, but does not support all file formats: only supports TextFile, SequenceFile, and RCFile.

Now, almost all hadoop distributions have added sqoop Teradata connector, so you can use all sqoop features (Incremental , History, Append etc.) which TDCH does not support.

Hope this will answer your question to some extent.