New User Path
Start with the introduction, interface, repository, database connections, and the first basic transformation.
Advanced ETL Processor Tutorials
Video tutorials for ETL setup, transformations, workflow automation, scheduling, Excel automation, EDI, JSON, APIs, and cloud storage.
Start with tutorials 001, 002, 004, 008, 010, and 011 if you are new to Advanced ETL Processor. If you already know the basics, use the learning paths and search below to jump straight to Excel automation, production scheduling, EDI, JSON, APIs, or cloud storage.
Recommended Learning Paths
Production Automation Path
Move from workflows to scheduling, services, execution agent, and unattended execution.
Excel Automation Path
Import, split, merge, transform, and generate Excel files without building scripts around spreadsheets.
EDI And API Path
Process EDI messages, create JSON files, and submit data to web APIs from repeatable workflows.
Browse By Topic
Getting Started Repository, interface, connections, and first ETL jobs. 15 Excel Automation Import, split, merge, generate, and transform Excel files. 29 EDI Processing Validate, transform, and route EDI messages. 5 JSON And APIs Create JSON, send web API requests, and work with webhooks. 4 Email Automation Process email messages and send data-driven emails. 2 Cloud Storage Automate Amazon S3 and Azure Blob Storage workflows. 3 BI And File Formats QVD, TDE, Hyper, Tableau, Parquet, CSV, and HTML output. 11 Transformations Mapping, validation, lookup, data reader, and data writer tasks. 17 Workflow Automation Scheduling, services, execution agents, folders, and loops. 28 Troubleshooting Fix common runtime, mapping, upgrade, and processing problems. 4
Showing 135 tutorials
- 000 Build Your First ETL Workflow in 5 Minutes Getting Started
- 001 Getting Started Getting Started
- 002 Getting Familiar With User Interface Getting Started
- 003 Learn How To Work With ETL Repository Database Getting Started
- 004 Learn How To Create Repository Database Getting Started
- 005 Learn How To Create Repository Backups Getting Started
- 006 Learn How To Perform Repository Synchronisation Getting Started
- 007 Learn How To Create Directory Object Getting Started
- 008 Learn How To Create A Database Connections Getting Started
- 009 Learn How To Create Groups Getting Started
- 010 Learn How To Create Basic ETL Transformation Transformations
- 011 Learn How To Create Workflows And Automate Everything Workflow Automation
- 012 Learn How To Pass Parameters Between Objects Using Variables Other Tutorials
- 013 Learn The Benefits Of Using Global Variables Other Tutorials
- 014 Learn How To Use Command Line To Run ETL Workflows And Transformations Transformations
- 015 Learn How To Use Advanced ETL Processor Maintain Tab Other Tutorials
- 016 Learn How To Work With Options Dialogue Getting Started
- 017 Learn How To Build A Library Of Reusable ETL Objects Getting Started
- 018 Learn How To Use ETL Version Control Getting Started
- 019 Learn How To Work With Advanced ETL Processor Services Workflow Automation
- 020 Learn How To Schedule ETL Transformations Execution Transformations
- 021 Learn How To Use Execution Agent For Unattended Execution Of ETL Transformations Transformations
- 022 Learn How To Load Data When A New File Is Added To The Folder Workflow Automation
- 023 Learn How To Use Management Console To Manage ETL Workflow Execution Workflow Automation
- 024 Learn How To Avoid Issues Once ETL Project Is Completed Troubleshooting
- 025 Learn How To Deal With Could Not Find Any Files To Read Error Troubleshooting
- 026 Learn How To Deal With Nothing Is Mapped Problem Troubleshooting
- 027 Learn How To Create Reports Part One Other Tutorials
- 028 Learn How To Create Reports Part Two Other Tutorials
- 029 Learn How To Work With Data Reader Transformations
- 030 Learn How To Transform Fixed Width Files Transformations
- 031 Learn How To Iterate Through A List Of Files Workflow Automation
- 032 Learn How To Work With Transformer Transformations
- 033 Learn How To Work With Validator And Address Data Quality Issues Transformations
- 034 Learn The Benefits Of Universal Data Writer Transformations
- 035 Data Writer Working With Text Files Transformations
- 036 Learn How To Export All Tables From A Database Other Tutorials
- 037 Learn How To Convert QVD File Into TDE File BI And File Formats
- 038 Learn How To Switch From TDE To Hyper BI And File Formats
- 039 Learn How To Create Tableau Hyper File BI And File Formats
- 040 Learn How To Publish Tableau Files BI And File Formats
- 041 Learn How To Create QVD Files BI And File Formats
- 042 Learn How To Extract Data From QVD Files BI And File Formats
- 043 Learn What Makes Advanced ETL Processor Special Other Tutorials
- 044 Learn How To Export All Tables From MySQL Database Into Text Files Workflow Automation
- 045 How To Transform Text Files Using ETL Transformations
- 046 Learn How To Import Data From Excel File Into MySQL Database Excel Automation
- 047 Learn How To Verify A File Layout Before Import Transformations
- 048 Learn How To Load Files Content Into Blob Fields Workflow Automation
- 049 Learn How To Export Blob Fields Into Files Workflow Automation
- 050 Learn How To Perform ETL Data Transformations Using Lookup Object Transformations
- 051 Learn How To Load Data Into Google Spreadsheet Excel Automation
- 062 Learn How To Work With Very Complex Data Transformations Transformations
- 063 Learn How To Extract Data From Very Complex Excel Files Excel Automation
- 064 Learn How To Create 1 Million Rows Excel File In 3 Minutes Excel Automation
- 065 Learn How To Create One Excel File Per Source Record Excel Automation
- 066 Learn How To Merge Multiple Excel Files Into A Single File Excel Automation
- 067 Learn How To Perform Conditional Excel Column Transformation Excel Automation
- 068 Learn How To Combine Multiple Excel Sheets Into One Automatically Excel Automation
- 069 Learn How To Import Data From Excel Into A Database Excel Automation
- 070 Seven Ways Of Automating Working With Excel Files Excel Automation
- 071 Learn How To Save Excel Sheets Into Separate Files Excel Automation
- 072 Learn How To Process Files One By One Workflow Automation
- 073 Learn Working With Constantly Changing Data Sources Other Tutorials
- 075 Learn How To Create Beautiful HTML Tables Automatically BI And File Formats
- 076 Learn How To Automate Working With ChatGPT Other Tutorials
- 077 Learn How To Rename All Excel Sheets In A Directory Automatically Excel Automation
- 078 Learn How To Split An Excel File Based On The Current Date Using Validator Excel Automation
- 079 Learn How To Interact With Google Gemini AI Other Tutorials
- 080 Learn How To Automate Working With Google Gemini AI Other Tutorials
- 081 Learn How To Work With Excel Dates Excel Automation
- 082 Learn How To Extract Data From PDF Files Using Google AI Workflow Automation
- 083 Learn How To Chain Multiple Data Validations Other Tutorials
- 084 Learn How To Process Large Number Of Email Messages Email Automation
- 085 Learn How Workflow Actions Work Workflow Automation
- 086 Learn How To Perform Secure FTP Delete Other Tutorials
- 087 Learn How To Avoid Double Processing Of Data Files Workflow Automation
- 088 Learn How To Convert QVD File Into CSV Format BI And File Formats
- 089 Learn How To Generate Qlik QVX Files BI And File Formats
- 090 Learn How To Upgrade Advanced ETL Processor Troubleshooting
- 091 Learn How To Process Paypro Global Orders Data Automatically Other Tutorials
- 092 Learn How To Continue A Loop After An Error Workflow Automation
- 093 Learn How To Collect User Feedback Workflow Automation
- 094 Learn How To Ask ETL Users Questions And Show Messages Workflow Automation
- 095 Learn How To Select Value From The List Workflow Automation
- 096 Learn How To Automate Working With Amazon S3 Storage Cloud Storage
- 097 Learn How To Check If Network Server Is Running Workflow Automation
- 098 Learn How To Pause ETL Workflow Execution Workflow Automation
- 099 Learn How To Automate Working With Files Workflow Automation
- 100 Learn How To Automate Working With Folders Workflow Automation
- 101 Learn How To Automate Sending Emails Email Automation
- 102 Learn How To Automate Working With Azure Blob Storage Cloud Storage
- 103 Learn Conditional Workflow Action Execution Workflow Automation
- 104 Learn How To Check Free Disk Space Automatically Workflow Automation
- 105 Learn How To Check ETL Software License Status Automatically Workflow Automation
- 106 Learn How To Change File Encoding Automatically Workflow Automation
- 107 Learn How To Split A Large CSV File Into Multiple Excel Worksheets Excel Automation
- 108 Learn How To Install Advanced ETL Processor Enterprise Getting Started
- 109 Learn How To Load Excel Data Into Any Database Excel Automation
- 110 Learn How To Convert Excel Files Into Any Format Excel Automation
- 111 Learn How To Send One Message Per Excel File Row Excel Automation
- 112 Learn How To Connect To Existing Repository After Installation Getting Started
- 113 Learn How To Create 1 Million Rows Excel File In 30 Seconds Excel Automation
- 114 Learn How To Convert All Text Files In A Directory Into Parquet Format BI And File Formats
- 115 Simplifying Distinct String Aggregation Other Tutorials
- 116 Learn How To Convert Parquet File Into Excel Excel Automation
- 117 Learn How To Replace Non Latin Characters In XML Files Workflow Automation
- 118 Creating JSON From CSV Data And Sending To Webhook JSON And APIs
- 119 Learn How To Transform CSV Data To JSON With GUIDs JSON And APIs
- 120 Learn How To Simplify Distinct String Aggregation Other Tutorials
- 121 Learn How To Replace Non Latin Characters In File Names Workflow Automation
- 122 Learn How To Convert Text Files Into Parquet Format BI And File Formats
- 123 Learn How To Submit JSON To Web API JSON And APIs
- 124 Learn How To Create JSON Files JSON And APIs
- 125 Learn How To Transform EDI Messages EDI Processing
- 126 Learn How To Validate EDI Messages EDI Processing
- 127 Learn How To Process EDI Messages In Sub Folders EDI Processing
- 128 Learn How To Process EDI Messages In A Folder EDI Processing
- 129 Learn How To Set Up Environment For EDI Processing EDI Processing
- 130 Learn How To Pass Filename From Package To Transformer Transformations
- 131 Learn How To Use Excel Templates Excel Automation
- 132 Inserting Excel Formulas Excel Automation
- 133 Working With Excel Tables Excel Automation
- 134 Updating Existing Excel File Excel Automation
- 135 Formatting Excel Cells Excel Automation
- 136 Generating Report In Excel Format Excel Automation
- 137 Automatic Export To Excel Excel Automation
- 138 Manual Export To Excel Excel Automation
- 139 Conditional Data Update Using In List Function Workflow Automation
- 140 Introduction To Cloud Storage Actions Cloud Storage
- 141 Dynamic Lookup Transformations
- 142 Converting FoxPro To Excel Excel Automation
- 143 Filtering FoxPro Dates Other Tutorials
- 144 Import Data From FoxPro Into SQL Server Transformations
- 145 Export Data From FoxPro Workflow Automation
Need The Product First?
Download the Advanced ETL Processor trial before following the tutorials, or compare editions if you need unattended production automation.