Migrating data to DataStax Enterprise

Methods to migrate data to DataStax Enterprise solutions.

DataStax Enterprise uses several solutions for migrating from other databases:

  • The CQL COPY command mirrors what the PostgreSQL RDBMS uses for file/export import.

    You can use COPY in the CQL shell to read CSV data to Cassandra and write CSV data from Cassandra to a file system. Typically, an RDBMS has unload utilities for writing table data to a file system.

  • The Cassandra bulk loader provides the ability to bulk load external data into a cluster.

ETL tools

If you need more sophistication applied to a data movement situation than just extract-load, you can use any number of extract-transform-load (ETL) solutions that support Cassandra. These tools provide transformation routines for manipulating source data and then loading the data into a Cassandra target. The tools offer features such as visual, point-and-click interfaces, scheduling engines, and more.

Many ETL vendors who support Cassandra supply community editions of their products that are free and able to solve many different use cases. Enterprise editions are also available.

You can download and try ETL tools from Jaspersoft, Pentaho, and Talend that work with DataStax Enterprise and Cassandra.