question

Gangadhara M.B avatar image
Gangadhara M.B asked Erick Ramirez answered

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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