US Patent 11893037 Dynamic code generation utility with configurable connections and variables

A dynamic code generation process with configurable connections and variables for extraction, transformation, and load (ETL) processing and validation is disclosed. A code generator loads an input requirement document and a configuration file, and generates workflows, database objects, and parameters. Database code is deployed in a database, ETL code is deployed in an ETL repository, and server code is deployed in an ETL server. A code validator reads the ETL code from the ETL repository and the database code from the database, and performs in-built stage unit testing. The code validator performs a quality check, metadata validation, definition comparisons, and outputs validation results.