G2 Crowd Acquires Siftery to Create a New Way to Buy and Manage Software Spend 🚀
G2 Crowd User in Computer Software

How can I move data from an RDBMS to DataStax Enterprise?

almost 2 years ago

How can I move data from an RDBMS to DataStax Enterprise?

Vendor Responses

Response by DataStax

almost 2 years ago

The most efficient way to move data from any RDBMS to DSE is to leverage Spark. Spark uses the JDBC driver in an RDBMS to create a Dataframe in Spark (see here). Once the data is in a Spark Dataframe, you can use the Spark Apache Cassandra™ Connector to save the Dataframe to Apache Cassandra™.

DataStax Enterprise also includes Sqoop to move data from any RDBMS with a JDBC driver (e.g., Oracle, MySQL) to the DataStax Enterprise server. One or more tables are simply mapped to new Apache Cassandra™ column families and the Sqoop interface takes care of the rest.

You can also use third-party tools such as Pentaho’s Kettle, which has full ETL capabilities and is free to download and use. Lastly, you can unload RDBMS data into delimited (e.g. comma, tab, etc.) flat files and load them into Apache Cassandra™ with the COPY load utility.