spViewer Software

CassandraPumper for Oracle

Apache Cassandra is a NoSQL object-oriented BigData database providing scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data. Cassandra's support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages. Cassandra's data model offers the convenience of column indexes with the performance of log-structured updates, strong support for denormalization and materialized views, and powerful built-in caching.

CassandraPumper for Oracle is an innovative, powerful and convenient software product which is a part of our BigData migration suite. It provides high-performance data migration functionality between Oracle and Apache Cassandra databases in two directions. With CassandraPumper GUI wizard you can easily perform data migration between Oracle table and Cassandra databases. You can create your custom data transformations on the fly and import several Oracle based data sources (based on your custom complex SQLs and CQLs) to Cassandra databases in parallel. All main Oracle data types (including XML, CLOB and BLOB) are supported for data migration to Cassandra and back. You are able also to view and manage Cassandra data and database objects. The data migration process can be parallelized up to 20 degrees providing a very high migration performance of big amounts of data.

Software Requirements

Client operating systemsWindows 95/98/ME, Windows NT 4.0, Windows XP, Windows 2000/2003/2008, Windows Vista, Windows 7, Windows 8, Windows 10 Oracle database versions8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0 Cassandra database versionsall stable versions up to 3.9 Oracle client software versions32 bit version 8.1.7 or later.

Licensing Schema

CassandraPumper for Oracle product is licensed by a number of client workstations where the software is installed. For example, if you install the software on 10 client workstations or PCs, you have to acquire 10 software licenses. You can also purchase an UNLIMITED client license for CassandraPumper for Oracle software. In this case the user is granted to install CassandraPumper for Oracle software on unlimited number of client workstations. Read below more details about software licensing options and prices available.

Read More

Key Features

  • High performance data transfer between Oracle and Cassandra databases in both directions
  • Intuitive GUI wizard to facilitate data mapping and migration operation
  • Support for all Oracle database versions including 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0
  • Support for all Cassandra database stable versions up to 3.9
  • Most main Oracle data types (XML, CLOB, BLOB) and data type conversions are supported
  • Support of parallel data migration procedure for optimal performance
  • Support of loading Cassandra collections like maps, sets and lists
  • Support of data view, query and modifications using intuitive GUI
  • More advanced features