We have to migrate our data from Oracle database to DSE . Is there any specific tool for doing that
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
We have to migrate our data from Oracle database to DSE . Is there any specific tool for doing that
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: https://docs.datastax.com/en/dse/6.7/cql/cql/cql_reference/cqlsh_commands/cqlshCopyFrom.html
The second way would be to extract the data from Oracle and use the Bulkloader: https://www.datastax.com/blog/2018/05/introducing-datastax-bulk-loader
A third way may be to support a more complex ingestion process supporting multiple tables that can be mapped into the ingestion process: https://docs.datastax.com/en/dse/6.7/dse-dev/datastax_enterprise/graph/dgl/dglCSV.html
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: https://www.datastax.com/blog/2012/03/how-move-data-relational-databases-datastax-enterprise-cassandra-using-sqoop
And this: http://ntier-db.com/index.php/2016/09/14/migrating-relational-data-from-oracle-to-cassandra/
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.
2 People are following this question.
What is the maximum array size allowed in a within() clause?
DSE (C*, Spark, Graph) Monitoring Starting Point, Best Practices
What does the state "DS" in the nodetool status output indicate?
Is it ok to clean OS cache memory on a DSE Search node?
Monitoring alerts OS version and OS latest patch for DSE running servers
DataStax Enterprise is powered by the best distribution of Apache Cassandra ™
© 2021 DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.
Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.
Privacy Policy Terms of Use