Import Excel to MariaDB Automatically

1. Launch Advanced ETL Processor Enterprise
2. Set up a MariaDB connection if you haven’t already.
3. Define a Directory connection pointing to the folder with your Excel files.
4. Create a new Transformation:
   • Navigate to a Transformation group
   • Right-click and select New
5. Remove the Validator object from the default workspace to keep it clean.
6. Configure the Data Reader object:
   • Double-click to open its properties
   • Select the appropriate Directory connection
   • Choose an Excel file (.xls or .xlsx)
   • Specify a sheet, table, or named range
   • Use wildcards (e.g., *.xlsx) to process multiple files automatically

   There’s no need to pre-process Excel files. The reader supports multiple sheets and dynamic filenames.

7. Configure the Data Writer object:
   • Double-click to open properties
   • Select your MariaDB connection
   • Choose or create the target table
8. Map Fields:
   • Open the Transformer object
   • Drag and connect source fields to destination columns
   • Use AutoMap to quickly match names where applicable
   • Add transformations like trimming, case formatting, or type conversion as needed
9. Execute the Import:
   • Click Execute to run the job
   • Review the logs to verify success and view row-level metrics
10. Automate the Workflow:
    • Use the built-in scheduler to run imports hourly, daily, or based on file arrival
    • Integrate into larger workflows or trigger based on system events

This method is ideal for ETL pipelines, internal tools, or ongoing Excel-based data feeds. It simplifies the entire process while offering robust control over data handling. IT teams can automate imports without the need for scripts, macros, or manual intervention.