| To make an ERP implementation successful data | | | | module to purchase modules to stocks and |
| migration is the key factor. When data can | | | | inventory. |
| migrate effectively that proves that the ERP | | | | D: Transaction Data - These are the data which |
| system is just appropriate for them. And this | | | | are entered at the end of all these above data |
| projection builds their confidence in the system | | | | entry order. It consists of balance sheets, reports, |
| and which in n turn becomes the key factor of | | | | and other end results. |
| the success of ERP implementation. | | | | Data load timing |
| Though while implementing an ERP the main focus | | | | 1. As we discussed above the timing should starts |
| is on the modules attached with it and how | | | | from set up data and it will end at transaction |
| popular it is, but what they lack is the focus in the | | | | data. But as set up data can be entered just one |
| operation of the system, that is real time | | | | time so exception caution should be taken while |
| migration, which cannot be determined till the ERP | | | | entering it. |
| is started working full fledged with all real time | | | | 2. And same rule goes for the case of sub |
| information, and when some one find out that the | | | | master's data entry. |
| information is not migrating efficiently and | | | | 3. And for Master data and transaction data, both |
| effectively then the ERP implementation is | | | | are continuous process so loads on tools need to |
| becomes a failure. | | | | be taken care. |
| The real problem lies in the fact that data | | | | Templates |
| migration is the last activity we do, because real | | | | These are sharable components mostly for |
| time data can only migrate when the system is | | | | various users, between different countries or |
| about to working live, so the real problem area | | | | continents so it should be created and modified |
| starts after that. | | | | keeping the exact purpose of sharing. |
| Strategy | | | | Tools to be used |
| There are few strategies that need to be | | | | There are four different tools can be used to load |
| followed while migration of data - | | | | data into the database. |
| 1. Data identification for migration. | | | | 1. Desktop Integration - This tool is used for one |
| 2. Determine the time for data migration. | | | | window based process. |
| 3. Generation of the data templates. | | | | 2. SQL Loader - These tools accept data from |
| 4. Data migration tools need to free zed. | | | | databases. |
| The data Identification for migration | | | | 3. Oracle Standard APIs - This tool is meant for |
| The Identification of the need to be migrated to | | | | oracle database. |
| any applications consists of four groups of data. A | | | | 4. Custom Built Interfaces - These are custom's |
| particular order need to be followed while entering | | | | verified data for loading into database. |
| the data as, all data is interdependent. | | | | Conclusion |
| The order is like | | | | Data migration is very important activity in |
| A. Configuration Data - These data are for one | | | | establishing the success of an ERP implementation. |
| time feeding into system that's required for set | | | | An accurately migrated data is a reflection to the |
| up. | | | | stakeholders that the ERP system is perfect and |
| B. Sub master Data - These data are mainly | | | | gives clear indication of their current organization. |
| related to any transaction procedures. | | | | This increases their level of confidence in the |
| C. Master Data - These are the data which are | | | | system and in turn is a key factor in the ultimate |
| being regular updated. It relates from sales | | | | success of ERP implementation. |