A Proposed ERP Data Collector to Converge the Old Legacy Data into the New ERP

Sultan T Alanazi, Hael Al-bashiri, Yousef Sanjalawe


Nowadays, one of the biggest Information Technology investments is in Enterprise Resource Planning (ERP) structure. ERP provides for the flow across the whole of an organization’s information by integrating and controlling the core business processes into a single application and single data repository. Moreover, ERP is considered time-consuming and expensive in terms of money and effort. ERP faces an obstacle in transforming data from the old legacy systems into new ERP systems since there is no defined standard model that can be used. Thus, in this paper, a new practical, simple, and effective solution to convert data from the old legacy system into the new ERP is proposed. This solution assumes that the data source and the target ERP are mismatched in data type formats, data values, data incompatibility, and missing data exist. The proposed solution defined a semi-auto data conversion process based on the meta-data of the source and target databases with the consultant of predefined mapping rules. First, the mapping process suggests a mapping list based on the predefined rules and the mapping confidence level (a threshold). Next, the final uploading process, human intervention is required to guarantee the correctness of the final loading process. The paper ends with a conclusion and future work.

Full Text:



Alhammadi, Z. H., & Shaalan, K. (2018). Lean Transformation in Information Technology: The Case of IT Services in Financial Firms. International Journal of Information Technology and Language Studies, 2(2).‏

Al-Sharafi, M. A., Arshah, R. A., & Abu-Shanab, E. A. (2019). Questionnaire Development Process to Measure the SMEs’ Continuous Use behavior towards Cloud Computing Services. Paper presented at the Proceedings of the 2019 8th International Conference on Software and Computer Applications, Penang, Malaysia. https://doi.org/10.1145/3316615.3316723.

Al-Sharafi, M. A., Arshah, R. A., Abu-Shanab, E. A., & Alajmi, Q. (2019). The Effect of Sustained Use of Cloud-Based Business Services on Organizations' Performance: Evidence from SMEs in Malaysia. Paper presented at the 2019 5th International Conference on Information Management (ICIM).

Borovskiy, V., & Zeier, A. (2010). Data manipulation APIs for ERP systems. Paper presented at the 2010 6th International Conference on Advanced Information Management and Service (IMS).

Çınar, E., & Ozorhon, B. (2018). Enterprise resource planning implementation in construction: challenges and key enablers. Journal of Construction Engineering, 1(2), 75-84.‏

Elbahri, F. M., Al-Sanjary, O. I., Ali, M. A., Naif, Z. A., Ibrahim, O. A., & Mohammed, M. (2019). Difference Comparison of SAP, Oracle, and Microsoft Solutions Based on Cloud ERP Systems: A Review. Paper presented at the 2019 IEEE 15th International Colloquium on Signal Processing & Its Applications (CSPA).

Gill, A. A., Amin, S., & Saleem, A. (2020). Investigation of Critical Factors for Successful ERP Implementation: An Exploratory Study. Journal of Business and Social Review in Emerging Economies, 6(2), 565-575.‏

Hamdy, M. E., & Shaalan, K. (2018). A hybrid framework for applying semantic integration technologies to improve data quality. International Journal of Information Technology, 2(1), 27-44.‏

Jenab, K., Staub, S., Moslehpour, S., & Wu, C. (2019). Company performance improvement by quality based intelligent-ERP. Decision Science Letters, 8(2), 151-162.‏

Kraljic, A., Kraljic, T., Poels, G., & Devos, J. (2014). ERP implementation methodologies and frameworks: a literature review. Paper presented at the 8th European Conference on IS Management and Evaluation (ECIME).

Mahmood, F., Khan, A. Z., & Bokhari, R. H. (2019). ERP issues and challenges: a research synthesis. Kybernetes, 10(2), 7-13. ‏

Mahraz, M.-I., Benabbou, L., & Berrado, A. (2020). A Compilation and Analysis of Critical Success Factors for the ERP Implementation. International Journal of Enterprise Information Systems (IJEIS), 16(2), 107-133.

Monteiro, J. (2019). Factors that affect effectiveness in the use of enterprise resource planning systems (Doctoral dissertation).‏

Nagpal, S., Khatri, S. K., & Kumar, A. (2015). Comparative study of ERP implementation strategies. Paper presented at the 2015 Long Island Systems, Applications and Technology.

Nagpal, S., Kumar, A., & Khatri, S. K. (2017). Modeling interrelationships between CSF in ERP implementations: total ISM and MICMAC approach. International Journal of System Assurance Engineering and Management, 8(4), 782-798.

Tarhini, A., Ammar, H., Tarhini, T., & Masa’deh, R. e. (2015). Analysis of the critical success factors for enterprise resource planning implementation from stakeholders’ perspective: A systematic review. International Business Research, 8(4), 25-40.

Viorel-Costin, B. A. N. Ț. A. (2019). The Difficulties of Transformation Sap Erp System from Actual Landscape to S/4hana Digitalization Environment. A Case Study. Annals Of'constantin Brancusi'university Of Targu-Jiu. Economy Series, (2).‏

Yadati, S., Manchala, V., Pandya, S. M., & Srikumar, A. (2012). An approach to enhance data management and reports in Multi-lingual ERP applications. Paper presented at the 2012 IEEE International Conference on Computational Intelligence and Computing Research.