- Easy use friendly GUI
- Full automation capabilities
- Can do complex formulas via drag n drop formula editor + also allow simple formulae writing directly through excel import functionality.
- Extremely flexible mapping rules allowing full control over ETL processes.
- Data warehouse maintenance is easy due its builtin DB schema management capability where user just need update database table script before importing back newly created tables from Excel file during run time execution phase; thus no changes needed at all between different runs even
- There are disadvantages