Author(s)

Manthan Joshi, Vijay K. Madisetti

School of Cybersecurity and Privacy, Georgia Institute of Technology, Atlanta, GA, USA.

Enterprise applications utilize relational databases and structured business processes, requiring slow and expensive conversion of inputs and outputs, from business documents such as invoices, purchase orders, and receipts, into known templates and schemas before processing. We propose a new LLM Agent-based intelligent data extraction, transformation, and load (IntelligentETL) pipeline that not only ingests PDFs and detects inputs within it but also addresses the extraction of structured and unstructured data by developing tools that most efficiently and securely deal with respective data types. We study the efficiency of our proposed pipeline and compare it with enterprise solutions that also utilize LLMs. We establish the supremacy in timely and accurate data extraction and transformation capabilities of our approach for analyzing the data from varied sources based on nested and/or interlinked input constraints.

Structured Data, Relational Model, LLM-Powered Agents, Field-Level Extraction, Knowledge Graph

Joshi, M. and Madisetti, V. (2025) Intelligent ETL for Enterprise Software Applications Using Unstructured Data. Journal of Software Engineering and Applications, 18, 44-65. doi: 10.4236/jsea.2025.181003.