spViewer Software

HBasePumper for Oracle

Apache HBase is a NoSQL object-oriented BigData database designed to host very large tables - billions of rows and millions of columns. Apache HBase is an open-source, distributed, versioned, column-oriented NoSQL database providing linear and modular scalability, strictly consistent reads and writes, automatic and configurable sharding of tables, etc.

HBasePumper for Oracle is an innovative, powerful and convenient product which is a part of our BigData migration suite. It provides high-performance data migration functionality between Oracle and Hadoop/HBase databases in two directions. With HBasePumper GUI wizard you can easily perform data migration between Oracle table and Hadoop/HBase databases. You can create your custom data transformations on the fly and import several Oracle based data sources (based on your custom complex SQLs) to HBase databases in parallel. All main Oracle data types (including XML, CLOB and BLOB) are supported for data migration to HBase and back. You are able also to view and manage HBase database tables and export it to a readable file format. 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 HBase database versionsall stable versions up to 1.3.0 Oracle client software versions32 bit version 8.1.7 or later.

Licensing Schema

HBasePumper 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 HBasePumper for Oracle software. In this case the user is granted to install HBasePumper 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 HBase 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 HBase database stable versions up to 1.3.0
  • 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 HBase column families attributes using linked Oracle data sources
  • Support of data view, query and modifications using intuitive GUI
  • More advanced features