How to Move Data from Relational Databases to DataStax Enterprise / Cassandra using Sqoop
The text discusses how to migrate data from an RDBMS (Relational Database Management System) such as MySQL, Oracle or SQL Server to a NoSQL database like Apache Cassandra using the tool Sqoop. This is made possible by DataStax Enterprise 2.0 which combines Cassandra, Hadoop and Solr into one big data platform. The process involves downloading the JDBC driver for the source RDBMS, placing it in a directory accessible to Sqoop, and then using the dse command to specify the source database details, destination keyspace and column family name, primary key of the column family, Cassandra node IP address, and whether to create a new keyspace. The result is the successful migration of data from RDBMS to Cassandra.
Company
DataStax
Date published
March 21, 2012
Author(s)
Robin Schumacher
Word count
481
Language
English
Hacker News points
None found.