Products >> Products Overview

Products Overview

Our patented technology and services:

  • Provide a repeatable process for creating and/or repopulating replica databases that ensures its referential integrity while protecting the proprietary information contained within the source database.
  • Provide an automated method of creating copies of a database that are referentially-intact subsets (or supersets) of the source database (e.g., creates a test database that is 10% the size of production).
  • Provide a process for managing the workflow associated with database reloads to help reduce the overall time and effort required to complete these typically manual tasks and reduce the risk of overwriting a database currently in use.
  • ROI is achieved by
    • Cutting the development cycle by automating time-consuming, complex tasks
    • Reducing the cost of manually creating, reloading and maintaining test databases
    • Reducing the cost of reloading a database among its various users
    • Ability to use cost-effective resources for database reloads (e.g., testers can reload)
    • The ability to create referentially-intact subsets of existing databases leads to:
      • Smaller test and development databases
      • More databases within the same amount of storage
      • Less users per database leading to less conflicts and greater resource
    • The automated, consistent masking of proprietary information leads to
      • Reduced potential for paying data-privacy related penalties and legal fees
      • Ability to work with in-house and outsource development staff faster
      • Reduced risk of legal action due to propagation of proprietary corporate/customer data
    • Reducing the effort associated with auditing your test and development environment

TransReplicator  Modules/Architecture

The TransReplicator solution consists of several modules that we integrate into your environment.  The modules work together to provide our clients with a complete solution for creating and maintaining (among other things) their RDBMS test and development environments.

Major modules include:

TransReplicator Navigator and Loader

TransReplicator is a replica-database creation process consisting of several application components that provides an automated method of creating/refreshing test databases in standard RDBMS environments. It creates and repopulates the replica database by extracting information from an existing database and implements a patented data transformation process to protect the proprietary information contained within that source database. The result is a replica database that has referential integrity and contains all or a portion of the source database's information. The user can specify:
  • The size of the replica database as a percentage of the source database or in megabytes
  • The distribution of the data relative to that in the source database
  • Optional table level filtering logic
  • Logical foreign key definitions
  • Data transformations
  • and more...