Posts Tagged ‘extraction tools

15
Mar
15

Data Migration – Legacy System Extraction Tool

We are working on a data migration strategy to migrate current 2 years’ financial transactions to the new system.  In between, we need to determine what are the transaction data/tables and master configuration data/tables to extract from today’s legacy system over to the new one.  One concern is how to get the extracted tables to map onto 1 or more excel/CSV templates which are those that map and migrates over to the new system.

The engineer suggests we obtain the new system’s current data dictionary, share with the legacy system’s vendor to design the extraction tool to follow the new system’s structure. This will use as a supporting tool to validate the correctness and integrity of the extraction tool.

We looked onto the types of data to migrate over to the new financial system and below are the few identified:

  1. Aging ARs (Accounts Receivables) and APs (Accounts Payables).
  2. Opening balances
  3. Master data (Fixed Assets, Suppliers, Customers, etc).  Note: The fixed assets data may not need to migrate over as doing so may results double-entries of assets depreciation to the new system.

Good job, team!




July 2017
M T W T F S S
« Mar    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Categories

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 443 other followers