Posts Tagged ‘legacy systems

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!

Advertisements



September 2017
M T W T F S S
« Mar    
 123
45678910
11121314151617
18192021222324
252627282930  

Categories

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

Join 443 other followers