Cost-Effective Big Data Orchestration via n8n Workflow Automation for Digital Health Transformation in Resource-Constrained Hospitals

Authors

  • Wandi Purnama Department of Information Technology, Pradita University, Tangerang, Indonesia
  • Akhmad Unggul Priantoro Department of Information Technology, Pradita University, Tangerang, Indonesia

DOI:

10.33395/sinkron.v10i3.16286

Abstract

Achieving compliance with Indonesia’s national SATUSEHAT health data mandate remains a complex hurdle for underfunded regional medical centers. The primary operational challenges stem from isolated departmental information architecture combined with the exorbitant licensing expenses of commercial middleware systems. To overcome these barriers, this study introduces a budget-friendly Big Data integration framework powered by n8n, an open-source, low-code workflow engine designed to dynamically unify disparate hospital environments. The methodology employs a Hadoop-based ecosystem and Apache Kafka for robust data ingestion, while n8n automates the Extract, Transform, Load (ETL) process to map raw clinical records into standardized HL7-FHIR JSON resources. Additionally, a lightweight Linear Regression model is applied as a low-compute operational optimization for dynamic batch-size prediction to prevent network overload during data transmission. Experimental results under a 72-hour continuous simulation on a single-core legacy server using 25,000 synthetic records demonstrate that the n8n-driven framework successfully sustains a throughput of 150 to 180 records per minute with a prediction error (RMSE) of 0.042. Furthermore, by eliminating proprietary software licensing fees and utilizing existing hardware, a comparative financial model indicates an estimated 85% reduction in the Total Cost of Ownership (TCO). Ultimately, this research provides a scalable technical blueprint for automating healthcare data integration, enabling under-resourced hospitals to achieve national interoperability mandates efficiently without compromising data integrity or financial stability.

GS Cited Analysis

Downloads

Download data is not yet available.

References

Aisyah, D., Setiawan, A., Mayadewi, C., Lokopessy, A., Kozlakidis, Z., & Manikam, L. (2025). Understanding health information systems utilisation across public health centres in Indonesia: A cross sectional study (Preprint). JMIR Medical Informatics, 13, e68613. https://doi.org/10.2196/68613

Aisyah, D. N., Setiawan, A. H., Lokopessy, A. F., Faradiba, N., Setiaji, S., Manikam, L., & Kozlakidis, Z. (2024). The information and communication technology maturity assessment at primary health care services across 9 provinces in Indonesia: Evaluation study. JMIR Medical Informatics, 12, e55959. https://doi.org/10.2196/55959

Amir, A. R. (2026). Evaluating workflow automation efficiency using n8n: A small-scale business case study. ScienceOpen Preprints. https://doi.org/10.14293/PR2199.002882.v1

Apriliyanto, E. (2026). Integrasi pertukaran data DICOM radiologi ke platform SATUSEHAT menggunakan arsitektur interoperabilitas berbasis FHIR. JTINFO: Jurnal Teknik Informatika, 5(1), 358–365. https://doi.org/10.02220/jtinfo.v5i1.1781

Author, A. A. (2025). Implementation of n8n platform for IoT sensor monitoring: Real-time analysis in smart farming. International Journal of Software Engineering and Computer Science (IJSECS), 5(3), 112–120. https://doi.org/10.35870/ijsecs.v5i3.5064

Chansanguan, S., Rittippant, N., Ueki, Y., & Jeenanunta, C. (2025). Sustainable digital transformation in public hospitals: Strategic enablers for smart healthcare systems. Sustainability, 17(19), 8614. https://doi.org/10.3390/su17198614

Compagnucci, I., Corradini, F., Fornari, F., Polini, A., Re, B., & Tiezzi, F. (2023). A systematic literature review on IoT-aware business process modeling views, requirements and notations. Software and Systems Modeling, 22(3), 969–1004. https://doi.org/10.1007/s10270-022-01049-2

Ge, K., Nguyen, P., & Arnaout, R. (2024). Lucie: An improved Python package for loading datasets from the UCI Machine Learning Repository. bioRxiv [Preprint]. https://doi.org/10.1101/2024.10.18.618994

Gharibvand, V., Kolamroudi, M. K., Zeeshan, Q., et al. (2024). Cloud based manufacturing: A review of recent developments in architectures, technologies, infrastructures, platforms and associated challenges. International Journal of Advanced Manufacturing Technology, 131, 93–123. https://doi.org/10.1007/s00170-024-12989-y

Hanifa, S., Mudiono, D., & Wicaksono, K. (2025). Analisis peluang dan tantangan integrasi data kesehatan berdasarkan aspek 5M (Man, Money, Material, Method and Machine). Journal of Public Health Education, 4(4), 112–125. https://doi.org/10.53801/jphe.v4i4.435

Harahap, N. C., Handayani, P. W., & Hidayanto, A. N. (2023). Integrated personal health record in Indonesia: Design science research study. JMIR Medical Informatics, 11, e44784. https://doi.org/10.2196/44784

Hutabarat, R. (2025). Challenges of health information systems in Indonesia. Journal Health of Indonesian, 3(02), 72–77. https://doi.org/10.58471/health.v3i02.181

Höfflin, J., Goschnick, P., Brecht, P., & Hahn, C. H. (2025). DPAF - Digital Platform Software Architecture Framework: Designing software architecture for digital platform business models linked to cyber-physical systems. Procedia CIRP, 136, 272-277. https://doi.org/10.1016/j.procir.2025.08.048

Idaiani, S., Hendarwan, H., & Herawati, M. (2023). Disparities of health program information systems in Indonesia: A cross-sectional Indonesian health facility research 2019. International Journal of Environmental Research and Public Health, 20(5), 4384. https://doi.org/10.3390/ijerph20054384

Jangam, S. K. (2024). Scalability and performance limitations of low-code and no-code platforms for large-scale enterprise applications and solutions. International Journal of Emerging Trends in Computer Science and Information Technology, 5(3), 68–78. https://doi.org/10.63282/3050-9246.IJETCSIT-V5I3P107

Kawichai, T. (2024). Stacking Ensemble Learning with Regression Models for Predicting Damage from Terrorist Attacks. ECTI Transactions on Computer and Information Technology (ECTI-CIT), 18(3), 250–259. https://doi.org/10.37936/ecti-cit.2024173.255276

Li, Y., Tao, W., Li, Z., Sun, Z., Li, F., Fenton, S., Xu, H., & Tao, C. (2024). Artificial intelligence-powered pharmacovigilance: A review of machine and deep learning in clinical text-based adverse drug event detection for benchmark datasets. Journal of Biomedical Informatics, 152, 104621. https://doi.org/10.1016/j.jbi.2024.104621

Mahida, A., Chintale, P., & Deshmukh, H. (2024). Enhancing fraud detection in real time using DataOps on elastic platforms. International Journal of Scientific Research in Computer Science, Engineering and Information Technology, 10(3), 10-25. https://doi.org/10.32628/CSEIT2410310

Naghib, A., Jafari Navimipour, N., Hosseinzadeh, M., & Sharifi, A. (2023). A comprehensive and systematic literature review on the big data management techniques in the internet of things. Wireless Networks, 29(3), 1085–1144. https://doi.org/10.1007/s11276-022-03177-5

Pappula, K. K. (2023). Reinforcement learning for intelligent batching in production pipelines. International Journal of Artificial Intelligence, Data Science, and Machine Learning, 4(4), 76–86. https://doi.org/10.63282/3050-9262.IJAIDSML-V4I4P109

Pacella, M., Papa, A., Papadia, G., & Fedeli, E. (2025). A scalable framework for sensor data ingestion and real-time processing in cloud manufacturing. Algorithms, 18(1), 22. https://doi.org/10.3390/a18010022

Pradita, R., & Fitriana, S. (2024). Implementasi standar interoperabilitas HL7-FHIR pada pertukaran rekam kesehatan elektronik di Puskesmas. Jurnal Ilmiah Perekam dan Informasi Kesehatan Imelda, 9(1), 20–30. https://doi.org/10.52943/jipiki.v9i1.1334

Ramezani, S. B., Cummins, L., Killen, B., Carley, R., Amirlatifi, A., Rahimi, S., ... & Bian, L. (2023). Scalability, explainability and performance of data-driven algorithms in predicting the remaining useful life: A comprehensive review. IEEE Access, 11, 41741–41769. https://doi.org/10.1109/ACCESS.2023.3267960

Raptis, T. P., & Passarella, A. (2023). A survey on networked data streaming with Apache Kafka. IEEE Access, 11, 85333–85350. https://doi.org/10.1109/ACCESS.2023.3303810

Ravikumar, R. (2022). The impact of big data quality analytics on knowledge management in healthcare institutions: Lessons learned from big data’s application within the healthcare sector. South Eastern European Journal of Public Health (SEEJPH). https://doi.org/10.11576/seejph-6194

Sarwar, Z., Song, Z. H., Ali, S. T., Khan, M. A., & Ali, F. (2025). Unveiling the path to innovation: Exploring the roles of big data analytics management capabilities, strategic agility, and strategic alignment. Journal of Innovation & Knowledge, 10(1), 100643. https://doi.org/10.1016/j.jik.2024.100643

Sebaa, A., Chikh, F., Nouicer, A., & Tari, A. (2018). Medical big data warehouse: Architecture and system design, a case study: Improving healthcare resources distribution. Journal of Medical Systems, 42(3), Artikel 59. https://doi.org/10.1007/s10916-018-0894-9

Tian, H., Zhao, C., Xie, J., & Li, K. (2024). Dynamic operation optimization of complex industries based on a data-driven strategy. Processes, 12(1), 189. https://doi.org/10.3390/pr12010189

Valenti, R., Elona, R., Despitasary, Hartono, B., & Daud, A. (2025). Global challenges of health information systems in Indonesia: A literature review. PKM-P, 9(2), 394–399. https://doi.org/10.32832/jurma.v9i2.2785

Vemulapalli, G. (2023). Architecting for real-time decision-making: Building scalable event-driven systems. International Journal of Machine Learning and Artificial Intelligence, 4(4), 1–20.

Venkiteela, P. (2025). n8n: An open-source workflow automation platform for enterprise integration and AI-driven orchestration. International Journal of Computer Applications, 186(6), 31–45. https://doi.org/10.5120/ijca2025926031

Vitorino, J. P., Simão, J., Datia, N., & Pato, M. (2023). IRONEDGE: Stream processing architecture for edge applications. Algorithms, 16(2), 123. https://doi.org/10.3390/a16020123

Wali, M., Nasir, N., & Iqbal, T. (2025). Implementing workflow automation with N8N to enhance operational efficiency and performance in the Sharia Cooperative of Bank Indonesia, Aceh Province. Journal Digital Technology Trend, 4(1), 36–47. https://doi.org/10.56347/jdtt.v4i1.341

Wang, J., Antwi-Afari, M. F., Tezel, A., Antwi-Afari, P., & Kasim, T. (2024). Artificial intelligence in cloud computing technology in the construction industry: A bibliometric and systematic review. Journal of Information Technology in Construction, 29, 480–502. https://doi.org/10.36680/j.itcon.2024.022

Downloads


Crossmark Updates

How to Cite

Purnama, W., & Priantoro , A. U. . (2026). Cost-Effective Big Data Orchestration via n8n Workflow Automation for Digital Health Transformation in Resource-Constrained Hospitals. Sinkron : Jurnal Dan Penelitian Teknik Informatika, 10(3), 1250-1260. https://doi.org/10.33395/sinkron.v10i3.16286

Issue

Vol. 10 No. 3 (2026): Article Research July 2026

Section

Articles

License

Copyright (c) 2026 Wandi Purnama, Akhmad Unggul Priantoro

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Crossref
Scopus
Google Scholar
Europe PMC