I unexpectedly inherited an ETL process that was integrated with Centerprise with very little transition time. It is user friendly enough that I am able to maintain the system with minimal experience. For most data flows I am able to make adjustments as needed. The prior admin set up alerts when there are errors which is helpful for me. Centerprise has been very reliable.
My score of 10 is based on my limited experience of inheriting and maintaining a fully implemented process -- I've never used or evaluated any competitors.
Certain data flows sources have many fields and exceptions. When the files are so complex the visual map is hard to follow.
My understanding is the decision to go with Centerprise was in part to ensure users with non technical backgrounds would be able to maintain Centerprise. I believe the product has lived up to those expectations.
Financial market information. Taking disparate data sources; standardizing, adding information and loading into internal internal SQL-based platform.