Merger & Acquisition - A Successful Shift from Oracle EBS to SAP ECC

Industrial Manufacturing

Client Overview

Client is a very large global conglomerate focusing on the areas of electrification, automation and digitalization, and is a leading supplier of systems for power generation and transmission as well as medical diagnosis.

Project Scope

Client migrated a company it acquired, from Oracle EBS to SAP ECC and engaged ChainSys as its data migration partner utilizing dataZap.

The scope was to migrate more than  55 objects from Oracle EBS to SAP ECC under the following target areas: FI/CO, MM/PP, PM, QM, SD and PS. Client mandated multiple test cycles to confirm the accuracy of the data migration process. Also, the transformation logic was complex.  Approval from key object owners and business sign off was a major milestone at each test cycle. Scope also included migration of data from non-EBS Systems.

Business Situation

Client acquired a global industrial manufacturing company and wanted to migrate data from the acquired company’s Oracle EBS ERP system to its SAP ECC ERP system. This posed complex migration challenges for transformations required by SAP while retaining existing business processes. The data spanned across multiple geographies, both for manufacturing and service businesses.

Technical Situation

Data was directly extracted from the Oracle EBS source system with pre-configured templates. Data was then transformed, as defined by the mapping logic, and loaded into the target SAP system after approval from object owners. Both pre-load and post-load reconciliation gave a mechanism to assure process accuracy and provided an easy approval mechanism. Also, pre-validations were done against the target SAP system prior to the data loading.


ChainSys deployed dataZap for migrating data from Oracle EBS to SAP ECC. Solution highlights are as follows:

  • dataZap’s pre-configured adaptors to extract, cleanse, transform, pre-validate & load data
  • Effective migration facilitated reconciliation to a 6-sigma confidence level
  • Incorporated existing business processes into the target SAP environment

List of Target modules for which data had to be migrated are below:

  • SAP PM
  • SAP QM
  • SAP SD
  • SAP PS
  • Migration for six  Manufacturing locations & eight  Service locations
  • Migration for three  International locations

Migration Business Needs satisfied:

  • Complex extraction & transformation criteria
  • 182 X-Ref Tables
  • Validation of data prior to loading into SAP to minimize errors
  • Default pre-defined templates for EBS & SAP enabled fast track data testing cycles



  • A 55%reduction in Migration process timelines
  • Reliable and repeatable Process between Test Cycles
  • Improved  the data quality during Multiple Migration Iterations
  • Complex Transformation business rules, easily configured in dataZap

The key to success was the ability to transform the data per client’s needs and the reusability of templates that accelerated the data migration and assured process accuracy.

Products and Services Used

dataZap - Pre-Configured Templates & Migration Engine to Extract, Transform, Pre-Validate, Load, Reconcile & Report.


No items found.