The software is very powerful, intuitive to use, and support has been responsive. One of the best features is the ability to preview the input or output of any step in the data flow.
Primary complaint would be I haven't seen much by way of events or community outreach. It would be great to have access to other users, or training/networking events.
Most of my dislikes are tactical and more of a wish-list. For example, refreshing the project tree view causes the tree to collapse, so you lose your place in the tree. As another example, sometimes we write UPDATE statements into SQL Query Source objects - it would be nice to be able to control whether these were executed when previewing the results of a data flow.
Try it out using some real-world data. Find a way to get training or advice - the available documentation is moderately extensive but also only moderately useful.
The main benefits are time saved and quality increased.
We are conducting data migrations as part of new software implementations. Most of the work is around migrating a client's data from their existing system's data model into ours. Using Centerprise, we've been able to build out a "baseline" migration process that incorporates our business logic and a lot of logging and error-catching. Having this reusable baseline has saved us time as well as increased the quality and capability of our migrations.
Our migrations encounter plenty of client-specific issues, of course, and we also deal with smaller one-off migrations outside of our baseline. We're able to use Centerprise, and in some cases portions of our baseline process to flexibly deal with these quickly and in a high-quality way.