The 21st Minute


Transferring Data from Legacy Systems into SAP – Data Validation & Verification


A publicly-traded company based in the U.S. with subsidiaries that designs, markets and sells apparel and accessories had outsourced the process of migrating its clothing inventory data into SAP to better track information.


Different brands are individually processed through different systems and countries. An extract, transform, load (ETL) process was needed to transform and prepare the data in the proper format to prepare the data for SAP. The company also wanted to eliminate mismatches and irrelevant data, such as cancelled purchases and completed orders prior to the SAP upload. All extracted data needed to be validated and verified to ensure accuracy. A separate objective analysis was desired to validate whether the outsourced ETL process was being performed correctly.


The Audimation Services Solutions Development team developed an ETL-emulation process, including an Open Database Connectivity (ODBC) interface to access and extract data from the various legacy systems. The data was imported into IDEA for verification and elimination of mismatched or irrelevant data. IDEAScripts were used to automate the testing process and fetch open sales order numbers, and corresponding purchase order numbers, to match fields in the reports. The team carefully evaluated the process to ensure the correct data was being loaded into SAP from the legacy systems. SmartExporter, an SAP data extraction tool, was used to pull the data from the SAP system so it could be compared to the ODBC pulls from the legacy system to verify accuracy.


More than 1,000 errors were identified, which enabled the client to identify potential errors, which were corrected to ensure accuracy. The IDEAScript saved time, effort and provided the organization with accurate reports. It also allowed the client to efficiently ensure that the outsourced ETL process and migration of their clothing data to SAP was being performed accurately.


Automate Procedures , Success Story

Posted By

By Team Audimation

Related Posts
Task Automation Using IDEA
Apr 16 Audit scenarios rarely require an entirely unique process. Having a preferred set of tests ready to go is a great time saver, but that can be further improved i...
Gain Productivity with RPA
Apr 16 Leaders of professional associations are urging auditors to embrace emerging technologies to advance the industry, create audit efficiencies and manage organiza...
Turn Your Data into a Competitive Advantage
Nov 05 Download the eBook We are in the midst of a data explosion where every action is collected, from a credit card swipe to the vibration of a factory machine. Y...

This website has been designed for modern browsers. Please update. Update my browser now