Work

Automation of PL/SQL-based ETL Process Using Shell Script

Year: 2025
Type: article
Abstract: This paper presents an automated ETL (Extract, Transform, Load) framework using SQL, PL/SQL, and Bash scripting to process structured data files and insert them into an Oracle database. The system is enhanced with a critical notification mechanism via SMS alerts using public SMS APIs. The primary focus is on database automation, error logging, and alert integration, providing a lightweight yet scalable solution for ETL operations in academic and real-world settings.
Author: Malarkodi M
Language: English
Subfield: Software
Open Access status: hybrid
OpenAlex ID: W4412667079
FWCI:
Cites: 7
Cited by:
Related to: 10