Abstract: Data integration is a popular technique or method today for data converting and sharing within new application with different database format and location. The interaction of data from one application system to another application system requires an intermediary software or middleware that allows the data to be transferred or read systematically and easily. The development of dynamic algorithms allows data in various formats, whether structured or unstructured, to be transferred to various types of databases smoothly. A case study was conducted for the Bill of Quantity (BQ) data in the known Excel format generated through CostX software in a single sheet Excel file. It was transferred to a single workbook with multiple sheets with formulation generated automatically. Thus, an algorithm was developed and tested through the development of the J-Selaras System. This algorithm can remove the noisy data or data symbols that are not related in the excel single sheet (CostX) file and automatically transfer to multiple excel sheets with macros formulation quickly. The implementation results indicate a significant contribution where it reduces in execution time of BQ processes and manpower resources used.

Mustafa Man, Wan Aezwani Wan Abu Bakar, Mohd. Kamir Yusof, Norisah Abdul Ghani, Mohd Adza Arshad, Raja Normawati Raja Ayob, Kamarul Azhar Mahmood, Faizul Azwan Ariffin, Mohamad Dizi Che Kadir, Lily Mariya Rosli and Nurhafiza Binti Abu Yaziz, “J-Selaras: New Algorithm for Automated Data Integration Tools” International Journal of Advanced Computer Science and Applications(IJACSA), 13(8), 2022. http://dx.doi.org/10.14569/IJACSA.2022.0130862

@article{Man2022,
title = {J-Selaras: New Algorithm for Automated Data Integration Tools},
journal = {International Journal of Advanced Computer Science and Applications},
doi = {10.14569/IJACSA.2022.0130862},
url = {http://dx.doi.org/10.14569/IJACSA.2022.0130862},
year = {2022},
publisher = {The Science and Information Organization},
volume = {13},
number = {8},
author = {Mustafa Man and Wan Aezwani Wan Abu Bakar and Mohd. Kamir Yusof and Norisah Abdul Ghani and Mohd Adza Arshad and Raja Normawati Raja Ayob and Kamarul Azhar Mahmood and Faizul Azwan Ariffin and Mohamad Dizi Che Kadir and Lily Mariya Rosli and Nurhafiza Binti Abu Yaziz}
}