Data Conversion/Migration

Implement Data Conversion/Migration at Business Entity Level minimizing risk and achieving high data quality.

The Data Conversion/Migration Scenario

  • New Application Implementation. Data from Legacy System need to be converted and loaded into new application
  • Application Upgrade
  • Application Consolidation
  • Mergers and Acquisitions
  • Company/Business Unit split. A company or business unit is split into two or more separate and independent entities.

The Data Conversion/Migration Problem

Data Conversion/Migration projects are known to be the most risky, complex, and time consuming of all IT Projects

Critical business objectives and jobs are at risk

  • 84% of data conversion/migration projects fail to meet expectations
  • 37% experience project budget overruns
  • 30% on average budget under scoped
  • 67% are not delivered on time

Source: Data Migration in the Global 2000, Bloor Research, September 2007

20% of the Projects' budget is spent on moving the data

  • Physically moving the data constitutes a significant amount spend in these projects
  • Often involves high volumes of data in heterogeneous environments
  • Little to no automation is used 50% of the time
  • Lack of Methodology
  • Moving the data warrants significant attention to lowering costs and risk

DataGlance Functionality

DataGlance was designed and developed to fully automate the movement of data between systems for conversion/migration projects. DataGlance provides developers and business analysts functions that have been designed to address unique challenges common to these projects.

  • A common development canvass for key stakeholders: Analysts and Developers
  • Business driven Data Conversion/Migration architecture
  • Implement Data Conversion/Migration at Business Entity Level minimizing risk and achieving high data quality
  • Define Data Conversion/Migration Rules and move data at Business Entity Level, as opposed to table to table
  • Analyze, Validate, and Cleanse Data at Business Entity Level
  • Real time data viewer for Data Validation process
  • Eliminates orphan data load
  • Automatic documentation of Data Conversion/Migration Rules
  • Import and Export Data Mapping from and into Excel Worksheet
  • Where-Used-Analysis for Data Auditing and Compliance
  • Metadata driven, codeless engine
  • Back out feature to back out the converted/migrated data at any stage
  • Extensive error handling options
  • Support iterative Data conversion/Migration approach to support changing requirements
  • LIVE and Multi-Stage Data Conversion/Migration support to minimize system downtime, reducing cost and business continuation
  • Highly scalable and fast execution platform to support enterprise wide Data Conversion/Migration

DataGlance ROI: 40% reduction in Data Conversion/Migration costs

DataGlance lowers project costs and risks and reduces data movement costs by 40%, typically 20% of the overall project budget.

  • Data Glance moved 300 database tables (from PeopleSoft) to the target application in 3 days -- One of the big three System Integrator moved 300 tables in 6 weeks
  • DataGlance reduced the personnel by 50% for Fortune 500 System Integrator to support Data Conversion/Migration project
  • DataGlance saved 75% in development costs for Fortune 500 System Integrator

Fortune 500 customers

The DataGlance product was developed at and funded by one of the its first Fortune 500 Customers.

DataGlance customer includes Fortune 500 customers

  • Duke Energy
  • Entergy
  • American Electric Power
  • Progress Energy
  • Pennsylvania Power and Light
  • Florida Power and Light
  • SAIC
  • Xcel Energy

Related Documents

Data Sheet