Great ETL tool for businesses of all sizes
What do you like best?
The application as a whole is very intuitive and easy for anyone to pick up on. From business line users to developers and system admins, the application is well designed to suit all knowledge levels.
Although it is simple to get started, the tools available are extremely flexible and can be very powerful, in particular, the data mapper functions.
What do you dislike?
Because the application runs on Java, it comes inherently with some of the flaws of java. In particular, memory leaks. The processflows can be tedious to set up, especially larger ones with multiple streams and object flows. The datamappers are powerful and allow for a wide range of function but in many cases, it requires a strong understanding of the available functions and some creativity to get around constraints that results from the design.
Recommendations to others considering the product:
A clustered environment is a must if this is a business critical application. It'll also help immensely to balance the resource load.
What problems are you solving with the product? What benefits have you realized?
I utilize the Adeptia to standardize thousands of files daily. Files that comes in all shapes an sizes from various sources. This allows us to be more efficient given the ability to be flexible in what type of files we are able to accept and utilize without issue.
