I like the way tool has been structured, the infrastructure, and integration capabilities.
The most important one is the transformation capabilities with efficiency.
The graphical interface is once of the best features once can have for transformation activities.
The object hierarchy i.e. workflow, data flow and then transformation objects brings in a lot of flexibility and parallel processing.
an expert designer on this tool can build some of the wonderful transformations possible.
The designer is little bit heavy to use. crashes some times when you perform some heavy design changes / load etc.
The job scheduler is too lousy and not at all intuitive.
Need some more improvement on collaborative development when more than one developers work in this.
Shared repositories need more flexibility.
Source code control and integration with such tools is must.
though the current object library is sufficient to complete all kind of transformations, it would be nice to have some more objects which provides commonly used operations.
I have personally used other couple of similar tools in the market. and can confidently say this is the best one you can have for your integration needs. very easy to use, powerful and can easily get skilled resources in market.
we do a lot of integration and transformations using this tool. transforming data from all hybrid systems to ware house, reporting databases etc.
Data Transformation is one of the key activity of any large enterprise when it comes to integration.
we have almost 90% of the system integrated using this tool.