Customers use the WisdomForce DatabaseSync in production and test environments to get most efficiency from their IT infrastructure while managing mission critical business data

• Real-time data integration across different heterogeneous data stores and platforms.
  Many systems and applications depend on data being sent to or from databases from the different vendors and running on various platforms; hardware and operating system. Use the Database Sync to integrate the database data in heterogeneous environment.
• Data Warehousing.
  DatabaseSync serves to update Data Warehouses such as Oracle, Teradata, Netezza or Greenplum with the most recent changes performed on OLTP Systems.
• Query Offloading for Web Systems.
  DatabaseSync allows synchronizing data to low cost MySQL or PostgreSQL servers efficiently for cost effective query offloading.
• Real-Time Reporting for critical and timely decision making.
  DatabaseSync replaces batch process ETL tools with real synchronization between the production database and the database used for reporting.
• Back-up Systems.
  DatabaseSync allows seamless and easy creation and maintenance of hot-backup standby servers. Only transactional changes from source database systems will be propagated. Specific tables or schemas maybe selectively backed-up.
• Online Database Migration.
  In combination with FastReader (another WisdomForce product), DatabaseSync provides an extremely fast, Zero-Downtime database migration solution. Migration can be performed between databases of different vendors and different platforms.

Customers use the WisdomForce FastReader 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 initial data synchronization before starting data replication or incremental extracts using Change Data Capture software such as WisdomForce DatabaseSync
• 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-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, XMLTYPE 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.
• Fastest data extraction from Oracle for data analysis.