Standard
Choose Standard for manual desktop ETL, local data loading, mapping, validation, and transformations. Standard does not include automation.
View StandardWhat Advanced ETL Processor Can Do
Build self-hosted ETL projects for data integration, transformation, import/export, validation, reporting, and automation without cloud lock-in.
Advanced ETL Processor Enterprise is the best starting point when you need self-hosted ETL software for databases, files, APIs, Excel, validation, reporting, scheduling, FTP/SFTP, email, messaging, and execution logs. Your data stays on your systems, which is how data should behave when it has been properly brought up.
Start with the Right Edition
The right edition depends on the job. Standard is for manual desktop ETL, Professional is for building and testing data integration projects, and Enterprise is for scheduled production automation.
Professional
Choose Professional when developers need to build, test, debug, and refine ETL projects before production deployment.
View ProfessionalEnterprise
Choose Enterprise when ETL jobs must run on a schedule, process files unattended, send notifications, and keep execution logs.
View Enterprise
Features by Edition
| Feature area | Standard | Professional | Enterprise |
|---|---|---|---|
| Manual desktop ETL | Yes | Yes | Yes |
| Visual mapping and transformations | Yes | Yes | Yes |
| ETL project design and testing | No | Yes | Yes |
| Scheduled production automation | No | Development use | Yes |
| Unattended ETL execution | No | Development use | Yes |
| Execution logs and operations control | Basic desktop logs | Developer logs | Production logs |
Connect databases, files, APIs and business systems
Typical Data Integration Projects
| Need | Useful features | Where to start |
|---|---|---|
| Self-hosted production ETL | Scheduling, transformations, import/export, validation, file actions, logging | Advanced ETL Processor Enterprise |
| Repeatable imports and exports | File readers, mapping, validation, database loading, Excel output, text exports | Visual Importer ETL Enterprise |
| Data quality checks | Required fields, ranges, formats, duplicate checks, business rules | Data validation examples |
| API, EDI and business-system integration | HTTP calls, JSON/XML transformation, EDI processing, database loading | EDI processing |
| Event capture | Email, URL, file, HL7, MQTT, Kafka, RabbitMQ, MSMQ, SMS logging | Event Loggers |
| Controlled database editing | Forms, menus, reports, user permissions, table editing | Active Table Editor |
Fast Data Import, Export and Loading
Move data between databases, files and business systems with bulk loading, native database access, and repeatable execution logs. If the data is large, strange, or both, this is where the heavy lifting happens.
Bulk Data Loading
Move large record sets with bulk operations, database-specific loading options, and execution logs for each run.
Native API Integration
Use native APIs for Oracle, SQL Server, MySQL, and PostgreSQL where direct database access is the fastest option.
Multi-threaded Processing
Process large volumes of data with parallel execution and bulk operations.
500+ Transformation Functions
Transformations cover common ETL work such as cleaning text, parsing dates, applying calculations, checking required values, and using lookups. See the transformation documentation and data validation examples for the full function area.
String Operations
Uppercase, Lowercase, Trim, Replace, Regex, Substring, Concatenate, and more.
Number Operations
Round, Floor, Ceil, Abs, Math Expressions, Format, Currency.
Date Operations
Format Date, Parse Date, Add/Subtract Days, Timezone Conversion.
Data Validation
Required Field, Email Format, Phone Format, Date Format, Range Check.
Lookup Functions
Database lookup, Conditional lookups, Caching for performance.
Excel Functions
Excel cell manipulation, sheet operations, formula evaluation.
What You Can Build with 140+ Automation Actions
Automation actions let a package move files, run SQL, send messages, process email, call APIs, branch on conditions, and handle errors. See the automation actions documentation for examples.
File Operations
Copy, Move, Delete, Rename, Zip/Unzip, Watch Folder.
Database Actions
Execute SQL, Run Stored Procedure, Export/Import from Database.
Automation
Schedule Task, Run Package, Loop, Condition, Error Handling.
Cloud & API
REST API Call, FTP Upload/Download, Email Send/Receive.
Email Processing
Send emails, receive and process emails with attachments.
Compression
Compress and decompress files automatically.
Data Sources & Destinations
Use the same ETL project for files, databases, spreadsheets, cloud services, APIs, and EDI. Start with download links if you want to test a source or destination.
Databases
SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2, Sybase, Firebird, SQLite.
Files
CSV, Delimited Text, Fixed Width, XML, JSON, Excel, QVD/QVX.
APIs and Business Systems
Salesforce, Google Sheets, Amazon S3, Azure Blob, Brightpearl, REST APIs, XML, JSON, and EDI.
Run ETL Jobs Without Cloud Lock-In
Automation features are useful when ETL jobs must run without a user watching the screen. Advanced ETL Processor is self-hosted, so there are $0 execution fees and $0 row transfer fees. For examples, see automation examples and video tutorials.
Scheduled Execution
Schedule tasks using Windows Task Scheduler for automatic processing.
Event-Based Triggers
Run when files arrive in a folder or via webhook.
Command Line
Run from command line or batch files for integration.
Get Started Without Scripting
The fastest way to judge the software is to build a small job. Start with the First 5 Minutes tutorial, then test your own files.
Drag-and-Drop Interface
No coding required. Design data mappings visually.
Magic Button
Preview transformations at any stage before committing.
Learn in Minutes
Build a first ETL project in 10 minutes or less, then expand it with validation, reporting, and automation.
Which Product Fits the Job?
Choose Advanced ETL Processor
Use it when the job includes transformations, automation actions, schedules, file handling, database work, cloud services, FTP, email, or messaging.
Choose Visual Importer ETL
Use it when the main job is importing files and external data into databases with repeatable mapping rules.
Choose Event Loggers
Use it when the job is capturing protocol, message, file, or URL events and writing them into a database.
Not sure which feature set you need?
Book a free ETL consultation. We will look at the job and tell you whether Advanced ETL Processor, Visual Importer ETL, or a simpler tool is the right fit.
Advanced ETL Processor Feature Questions
Which product has the broadest feature set?
Advanced ETL Processor Enterprise has the broadest feature set. Start there if you need transformations, scheduling, file actions, database work, cloud connections, email, FTP, messaging, and execution logs in one product.
Can these tools run ETL jobs automatically?
Advanced ETL Processor Enterprise can run scheduled and unattended jobs with logging and error handling. Advanced ETL Processor Standard is for manual desktop ETL and does not include automation. Advanced ETL Processor Professional is for developers building and testing ETL projects.
Do I need to write code to transform data?
No. Transformations are designed visually. You can use built-in functions for strings, dates, numbers, lookups, validation, Excel handling, and database operations without writing scripts.
Which tool should I use for simple data imports?
Use Visual Importer ETL when the main task is importing files or external data into a database with repeatable mapping rules. Use Advanced ETL Processor Standard for manual desktop ETL, Professional for developer project work, and Enterprise when the import is part of scheduled production automation.
Which edition should developers use?
Developers should start with Advanced ETL Processor Professional when they need to build, test, debug, and refine ETL projects before production deployment. Use Enterprise when those jobs need scheduled production execution.
Does Standard include scheduling or unattended execution?
No. Advanced ETL Processor Standard is for manual desktop ETL. It handles user-run loading, mapping, validation, and transformations, but it does not include scheduling, package automation, or unattended execution.