Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started



aravinth_chakravarthyr_173918 avatar image
aravinth_chakravarthyr_173918 asked Lewisr650 answered

Data movement

We have to migrate our data from Oracle database to DSE . Is there any specific tool for doing that

10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Lewisr650 avatar image
Lewisr650 answered

There are several ways to go about loading data from Oracle to DSE Cassandra, depending on how much data you intend to load. The first would be to extract a table from Oracle into a CSV file and load it using CQLSH "Copy" command:

The second way would be to extract the data from Oracle and use the Bulkloader:

A third way may be to support a more complex ingestion process supporting multiple tables that can be mapped into the ingestion process:

These are for fairly straight forward copying of data into Cassandra, however, moving data from a relational environment to a distributed partitioned database has additional considerations around partitioning, data distribution and creating efficient collections of data within a partition for efficient querying. This is done through data modeling and when loading more complex data you can use DSE Analytics spark engine to read from Oracle, map the data or enhance it prior to storing it in Cassandra. For example, you might read data from 3 tables in Oracle and merge them into a single data stream in Cassandra that supports the partition stored data that encapsulates the relationship of the data into the partition. This discussion can help you get started down that path:

And this:

You can always reach out to your Sales team or Services team members for deeper dive discussion to address specifics around what you are trying to achieve.

10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.