FastReader - High speed DIRECT PATH data export, migration and load from very large database tables, fast logical snapshot
More Info | ||||||||||||
|
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.
WisdomForce FastReader along with WisdomForce Database Sync (Change Data Capture) gives customers a full data movement solution for Databases and Data Warehouses. Such powerful combination of features allows a high data sync quality and immediate access to most recent business data.
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 or multi-core environments, 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, Comp-3 and Teradata binary format.
- Extracted data is in portable ASCII format and can be transferred or migrated to any data source without additional efforts.
- FastReader automatically prepares input for high-speed database loaders such as Oracle SQL*Loader or bcp; dynamically generates schema definition scripts and scripts for Oracle External Tables load.
- FastReader works with major databases and data warehouses, including Oracle, DB2, MSSQL, MySQL, Teradata, Netezza, Sybase, PostgreSQL, Neoview and Greenplum .
- 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).
- FastReader has built-in integration with WisdomForce Database Sync (Change Data Capture) and efficiently can be used for high-performance DIRECT PATH Initial Synchronization prior to replication of transactions
- FastReader Server enables landing the extracted data remotely in heterogeneous environment into flat text files or pipe while performing DIRECT PATH extract
