Active Data Transformer

Product Focus

Data Transformation, Cleaning and Loading

Product Description

Active Data Transformer provides a mechanism to automatically import raw data on a schedule, clean the data using user defined rules, followed by data loading via generation of merged insert scripts as well as merged flat files.

Product Architecture

The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.

  • Database Compatibility:

    Oracle

    SQL Server

    DB2

  • Operating System Compatibility:

    Windows95/98/ME

    WindowsNT/2000 client connecting to ANY Database on the corporate network

  • Technical Requirements:

    Pentium 100MHz or higher

    10MB hard disk space

    64 MB RAM (128 MB recommended).

Benefits

  • Enables Data Cleaning on a scheduled as per user defined rules stored in the ActiveDataTransformer repository
  • Enables transformation of the data as per user defined rules
  • Allows merging of multiple record sets into a uniform set or insert script
  • Allows the user to migrate the data between disparate sources and databases.

Application Area

  • Where there is a need to merge data from multiple databases and/or data dumps from various legacy systems
  • When the data fields are incorrect and requires correction by the application of standard arithmetic rules, date formatting rules, data concatenation with pre and post fixes, nullifying the data based on defined conditions, switching data based on user defined conditions, etc
  • Generation of insert scripts from data obtained from multiple files and databases.
  • When data needs to be transformed, cleaned, merged and loaded on a schedule.