Pros
- Easy to install & deploy.
- Free, open source solution (no cost)
- Ability store data in many formats including SQL server database tables,
- Supports complex transformations / mappings between several sources/destinations easily via intuitive user interfaces
Cons
- Inability access underlying metadata stored inside DB directly when needed