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

 

question

Gangadhara M.B avatar image
Gangadhara M.B asked ·

What is the best approach to migrate data from an Oracle database?

We have oracle 11.2.0.4 version database running on On-prim data center ,now want to migrate the this oracle database which is around 6TB to Cassandra , what is the best and simple approach to migrate the database from Oracle to Cassandra .

Any third party tools which makes our job easy for migration

Thanks

Gangadhara

migration
10 |1000 characters needed characters left characters exceeded

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

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

At a high level, you will need to:

  • unload the data from your Oracle database
  • do the necessary transformations to denormalise the data
  • load the denormalised data to Cassandra

The best way to do this is through Apache Spark. Otherwise, there are ETL solutions from various vendors such as Talend and Informatica that supports DSE. See Migrating data to DataStax Enterprise for some overview.

My recommendation is to log a ticket with DataStax Support so our engineers can assist you with any follow up questions you may have. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

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