Migration of SQL Script Execution from CLI to Apache Airflow with Daily Triggering System

Ashila Harashta, Muhammad Fadhlan (2025) Migration of SQL Script Execution from CLI to Apache Airflow with Daily Triggering System. Project Report. [s.n.], [s.l.]. (Unpublished)

Text 5025211068-Project_Report.pdf - Accepted Version Restricted to Repository staff only Download (2MB) | Request a copy

Abstract

PT Telkom Indonesia merupakan perusahaan telekomunikasi di Indonesia. Sebagai perusahaan telekomunikasi terbesar di Indonesia, Telkom perlu memproses data pelanggan, karyawan, dan rekaman data pelayanan dengan jumlah yang sangat besar setiap harinya. Saat ini sistem pembaruan basis data telkom menggunakan script SQL yang dieksekusi melalui Command Line. Meskipun sistem ini bekerja dengan baik, sistem ini sangat sulit untuk dikelola, diperbarui, atau diperbaiki ketika terjadi error. Sistem juga perlu mencegah jadwal update baru untuk dimulai apabila jadwal update sebelumnya belum selesai. Itulah mengapa diperlukan sistem baru yang lebih mudah untuk dibaca dan diperbarui. Di sinilah penggunaan Apache airflow digunakan. Apache airflow adalah platform orkestrasi workflow open-source. Tidak seperti menggunakan CLI, UI dan log airflow memungkinkan programmer untuk memahami alur kerja dari suatu program dengan lebih mudah. Airflow juga dilengkapi dengan penjadwalan bawaan yang mempermudah pengelolaan jadwal maupun pembatalan jadwal.
===================================================================================================================================
PT Telkom Indonesia is the largest telecommunication company in Indonesia. As the largest telecommunication company in Indonesia, Telkom must process a vast amount of customers, employee, and service record data daily. The current Telkom database update system uses SQL script that is executed from Command Line. While it works, it is difficult to maintain, update or debug. The system also must prevent new update schedule to from starting if the previous one is not yet finished. That is why a new system is needed which is easier to read and update. This is where Apache Airflow comes. Apache airflow is an open-source workflow orchestration platform. Unlike using CLI, airflow UI and log allow programmer to understand the workflow of a program. Airflow also has a built-in scheduler which make it easier to manage the schedule or cancel a schedule.

Item Type:	Monograph (Project Report)
Uncontrolled Keywords:	Apache Airflow, SQL, Database, Schedule
Subjects:	T Technology > T Technology (General) > T57.5 Data Processing T Technology > T Technology (General) > T58.5 Information technology. IT--Auditing
Divisions:	Faculty of Intelligent Electrical and Informatics Technology (ELECTICS) > Informatics Engineering > 55201-(S1) Undergraduate Thesis
Depositing User:	Muhammad Fadhlan Ashila Harashta
Date Deposited:	13 Oct 2025 04:30
Last Modified:	13 Oct 2025 04:30
URI:	http://repository.its.ac.id/id/eprint/128556

Actions (login required)

View Item