Extract, Transform, Load Monitoring sales Multi Marketplace

Leonardus Adityo Toto Pratomo; Deni Mahdiana

doi:10.24036/jtip.v16i1.721

Leonardus Adityo Toto Pratomo Universitas Budi Luhur
Deni Mahdiana Universitas Budi Luhur

DOI: https://doi.org/10.24036/jtip.v16i1.721

Keywords: ETL, RDBMS, MySQL, Microsoft Access, Multi Marketplace

Abstract

This research is made in the design of a database system and online sales files for sales on a medium business scale, Era 5.0 Society many marketplaces make it easy for medium businesses to sell products, So business actors need to see the development of digital business and forecast their merchandise that is sold out online. As for the implementation of 1) database from RDBMS into MYSQL. The research uses an open source database, namely MYSQL, 2) The research method uses Microsoft Access program tools with the link to the Windows 10 operating system odbc in Extract Transform Load (ETL) which is carried out automatically with button 3 process Extract, Transform, Load from the download folder into the relational database management system (RDMS) in ms access and stored in the MySQL database. 3) This research forms raw data facts from several marketplaces and is processed into normalized table dimensions in the data warehouse. This research aims to design a combination of open-source systems and Microsoft access licenses, for business actors who need sales analysis that is sold multichannel (online or offline), to optimize stock and provide products consistently in each sales channel.

References

[1] A. Rahmat Iskandar, A. Junaidi, and A. Herman, “Extract, Transform, Load sebagai upaya Pembangunan Data Warehouse,” 2019.
[2] I. Putu, W. Prasetia, I. Nyoman, and H. Kurniawan, “Implementasi ETL (Extract, Transform, Load) pada Data warehouse Penjualan Menggunakan Tools Pentaho,” TIERS Information Technology Journal, vol. 2, no. 1, pp. 39–47, 2021, [Online]. Available: https://journal.undiknas.ac.id/index.php/tiers
[3] E. Abdelhamid, N. Tsikoudis, M. Duller, M. Sugiyama, N. E. Marino, and F. M. Waas, “Adaptive Real-time Virtualization of Legacy ETL Pipelines in Cloud Data Warehouses Frequent Subgraph Mining View project Efficient Techniques for Modular Past State Systems View project Adaptive Real-time Virtualization of Legacy ETL Pipelines in Cloud Data Warehouses,” 2023, doi: 10.48786/edbt.2023.64.
[4] B. Rianto, F. Yunita, M. Amin, and R. Rahma, “Information Systems of Official Trips at General Election Commission Office (KPU),” Jurnal Teknologi Informasi dan Pendidikan, vol. 14, no. 1, pp. 1–9, 2021.
[5] D. Novaliendry and V. D. Puteri, “E-Retail Percetakan Anambaleh Desain Menggunakan Framework Laravel,” Jurnal Teknologi Informasi dan Pendidikan, vol. 13, no. 1, pp. 10–19, 2020.
[6] F. Oktavia and Y. Hendriyani, “PERANCANGAN E-REPORT FINANCIAL SYSTEM BERBASIS WEB (STUDI KASUS: TOKO KRIPIK BALADO MAHKOTA),” Jurnal Teknologi Informasi dan Pendidikan, vol. 13, no. 1, pp. 87–95, 2020.
[7] M. Hendayun, E. Yulianto, J. F. Rusdi, A. Setiawan, and B. Ilman, “Extract transform load process in banking reporting system,” MethodsX, vol. 8, Jan. 2021, doi: 10.1016/j.mex.2021.101260.
[8] D. Andriansyah, “Implementasi Extract-Transform-Load (ETL) Data Warehouse Laporan Harian Pool”.
[9] K. Y. Cheng, S. Pazmino, and B. Schreiweis, “ETL Processes for Integrating Healthcare Data - Tools and Architecture Patterns,” in Studies in Health Technology and Informatics, IOS Press BV, Nov. 2022, pp. 151–156. doi: 10.3233/SHTI220974.
[10] A. D. Barahama and R. Wardani, “Utilization Extract, Transform, Load for Developing Data Warehouse in Education Using Pentaho Data Integration,” in Journal of Physics: Conference Series, IOP Publishing Ltd, Dec. 2021. doi: 10.1088/1742-6596/2111/1/012030.
[11] F. L. Gaol, L. Abdillah, and T. Matsuo, “Adoption of Business Intelligence to Support Cost Accounting Based Financial Systems-Case Study of XYZ Company,” Open Engineering, vol. 11, no. 1, pp. 14–28, Jan. 2020, doi: 10.1515/eng-2021-0002.
[12] aljanabi alharqi haider, “An Optimal Warehouse Design for Crime Dataset,” International Journal of Advanced Trends in Computer Science and Engineering, vol. 9, no. 5, pp. 9080–9088, Oct. 2020, doi: 10.30534/ijatcse/2020/313952020.
[13] G. Khan Ghajar, M. Plager, and S. Hallberg, “CONVERSATIONAL AND LIVE INTERACTIONS DEVELOPMENT AND MARKETPLACE DISTRIBUTION SYSTEM AND PROCESS,” 2018, doi: 10.1109/I.
[14] R. Venkatakrishnan, “Design, Implementation, and Assessment of Innovative Data Warehousing; Extract, Transformation, and Load(ETL); and Online Analytical Processing(OLAP) on BI,” International Journal of Database Management Systems, vol. 12, no. 3, pp. 1–6, Jun. 2020, doi: 10.5121/ijdms.2020.12301.
[15] J. C. Quiroz, T. Chard, Z. Sa, A. Ritchie, L. Jorm, and B. Gallego, “Extract, Transform, Load Framework for the Conversion of Health Databases to OMOP,” 2021, doi: 10.1101/2021.04.08.21255178.
[16] Mr. R. S. Ratnaparkhi, “The Extract Transform Load (ETL) Process and Optimization using Ab Initio,” Int J Res Appl Sci Eng Technol, vol. 7, no. 5, pp. 1714–1717, May 2019, doi: 10.22214/ijraset.2019.5287.
[17] Chatzistefanou Dimitra, “Data Warehousing in Business Intelligence and ETL Processes Chatzistefanou Dimitra,” 2023.
[18] alexander sychev, Data Analytics and Management in Data Intensive Domains, vol. 1427. in Communications in Computer and Information Science, vol. 1427. Cham: Springer International Publishing, 2021. doi: 10.1007/978-3-030-81200-3.
[19] Ardhian Agung Yulianto, “Extract Transform Load process in distributed database academic datawarehouse,” 2021.
[20] S. M. Bouknight, “AUTOMATED ETL WORKFLOW,” 2022, doi: 10.1109/W1.2016.0083.
[21] B.-E. B. Semlali, C. El Amrani, and G. Ortiz, “SAT-ETL-Integrator: an extract-transform-load software for satellite big data ingestion,” J Appl Remote Sens, vol. 14, no. 01, p. 1, Jan. 2020, doi: 10.1117/1.jrs.14.018501.
[22] A. Ta’a, N. Ishak, E. M. Elias, and N. Mahidin, “AN IMPACT ANALYSIS OF EXTRACT TRANSFORM LOAD PROCESS FOR MAINTAINING THE SYSTEM OF DATA WAREHOUSE,” Journal of Information System and Technology Management, vol. 7, no. 27, pp. 168–186, Sep. 2022, doi: 10.35631/jistm.727014.