WisdomForce.com solutions make enterprise data universally and securely

Rating: 0 - 0 votes

Company Logo

Company Name

WisdomForce Technologies, Inc.

Company Contact

phone: (425) 481-8475

email:

Website Analysis

Domain Whois

WHOIS information for WisdomForce.com

Powered by who.is

Page Type

This page is about a company.

Title

WisdomForce High Speed Data Unload to text files, Export & Archiving for Oracle

Description

WisdomForce solutions make enterprise data universally and securely up to date accessible and useful.

WisdomForce Technologies delivers software products that help CIOs of data-intensive businesses and governmental entities to improve the quality, availability and continuity of the data within their IT systems, leading to better business decision-making, increased productivity, and an improved bottom line.

WisdomForce's high-performance products focused on the real-time database data movement and data integration market.

The Company is founded by industry veterans with a clear vision of real-time database data movement and integration and offers next generation solutions for real-time data transfer across heterogeneous systems. WisdomForce is providing customers with software infrastructure for data replication, extract, change data capture, transformation, movement and management of data from one/ many database to one/many database.

WisdomForce's customers include Walmart, Coca Cola, Verizon, Motorola, Thomson Financial, Verisign and Ross Stores. WisdomForce increases its global market reach through key relationships with major database vendors, systems integrators and ISV's.

Languages

English

Address

Seattle WA 98001 US

Additional Information

 FastReader™  - High speed data export, migration and load from very large database tables.

The WisdomForce™ FastReader™ is a popular ultra high-performance data transfer and migration product used by Database and System Administrators, Data Warehouse Architects, Developers and QA in every day and night critical IT operations. FastReader enables portable data cross multiple platforms in a heterogeneous environments and significantly improves data accessibility. It provides a fast and efficient way for unloading and extracting data into universally portable format for movement across the enterprise or for reorganization in place. FastReader delivers high levels of parallelism and distribution of data across different versions and platforms.

   * FastReader can unload and extract all or selected Oracle tables of any size (terabytes of data) into portable flat text files (or into pipe ) in a fraction of the time without compromising the performance production database systems.
   * FastReader is capable perform fast parallel and selective unload of data from Oracle which effectively utilizes the multi-processor environment. and at least 20 times faster than UTL_FILE or sqlplus spool for full table unload.
   * The data unload / load process with FastReader can significantly reduce storage needs and network overhead when used built-in fast compression on the fly.
   * The user is able to easily configure the output data format which can be csv, xml, with any kind of delimiters, fixed length, EBCDIC character set and Comp-3 format.

   * Extracted data is in portable ASCII format and can be transferred or migrated to any datasource without additional efforts.
   * FastReader automatically prepares input for high-speed loaders such as Oracle SQL*Loader, bcp, etc. and dynamically generates schema definition scripts and creation scripts for Oracle external tables.
   * FastReader™ works with major databases, including Oracle, DB2, MSSQL, MySQL, Sybase, PostgreSQL.
   * FastReader supports most operating systems and platforms: Solaris, HPUX, AIX, Tru64, Windows, Linux/386, IA64 and AMD.
   * Direct Path data unload with FastReader for Automatic Storage Management (ASM)

 Customers use the WisdomForce solutions in production and test environments to reduce costs and increase efficiencies from their IT infrastructure

   * Performing high performance Oracle data archiving into portable format.
   * Fast migration of data from Oracle to DB2, SQL Server, Sybase, MySQL or Oracle (between different versions cross different platforms).
   * Performing high speed production data feed from large Oracle tables into third-party external systems or data warehouse like Teradata, Sybase IQ or Netezza.
   * Performing upgrade of databases in a production environment.
   * Performing fast selective backup of huge tables.
     Very quickly export Oracle tables into a portable text format for selected columns, and/or filter rows by setting conditions.
   * Performing fast reorg Oracle very large tables.
     Automatic high-speed reorganization of very large Oracle tables by unload data into flat files or pipe and reload with SQL*Loader using created data and control input
   * Creating or updating a test environment with most recent data from production database.
     Performing fast and no-overhead extraction of very large tables or table partitions from production systems with the purpose of copying the unloaded data into the test environment machines in a fast and convenient way.
   * Performing high speed initial data synchronization before starting replication.
   * Performing high-performance extract and load SPATIAL objects between high-end GIS and LBS systems

   * Creating backups of large tables for Network Attached Storage (NAS).
     Very often a Database Administrator (DBA) has to copy an extremely large table from one production database instance to another. Using regular native database export/import is slow and adds a significant overhead on the production environment. DBA might create a transportable tablespace, detach it from one instance, and attach it to another. Building tablespaces on NFS is not allowed (excluding NetApp). FastReader resolves this issue by unloading data from the tablespace, residing on a regular disk or SAN into a text file on NFS or another NAS mounted device.

   * Have a need to quickly check the data from columns with BLOB, CLOB data type or Spatial objects.
   * During recovery, when the database is opened using _allow_resetlogs_corruption, _corrupted_rollback_segments or _offline_rollback_segments.
     Much faster database extraction and rebuilding, as compared to the oracle exp & imp utilities, during recovery in case of redo log corruption or loss of redo logs.