About Sqoop

You can use Sqoop for migrating data and supports password authentication for Sqoop operations.

Sqoop is an Apache Software Foundation tool for transferring data between an RDBMS data source and Hadoop or between other data sources, such as NoSQL.

DataStax Enterprise support for Sqoop empowers you to import data from an external data source to the Cassandra File System (CassandraFS), the Hadoop File System (HDFS) counterpart. An analytics node runs the MapReduce job that imports data from a data source using Sqoop.

You need a JDBC driver for the RDBMS or other type of data source.

Importing data 

You can import data from any JDBC-compliant data source. For example:

  • DB2
  • MySQL
  • Oracle
  • SQL Server
  • Sybase