/plushcap/analysis/datastax/datastax-how-move-data-relational-databases-datastax-enterprise-cassandra-using-sqoop

How to Move Data from Relational Databases to DataStax Enterprise / Cassandra using Sqoop

What's this blog post about?

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

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.