ETL Framework allows you to create data integration and ETL scenarios using XML-based language or Java. You can easily embed framework in your application or deploy it as a Web application and connect to the open API. There is a wide selection of built-in transformations and you can develop your own using JavaScript and SQL.
This is a solid ETL tool. A great deal of flexibility in what can be done and this can be leveraged to fit your needs. The UI can be a bit clunky and hard to navigate. A bit expensive as well. You can build a very complex ETL process that would otherwise require multiple scripts. We used the ETL Framework for integrating our data from different ERP systems into our BI server.
The tool is fast and easy to use. The documentation is complete and easy to follow. There are many useful functions in…
Pros
Data quality control built in., intuitive user interface & powerful analysis capabilities across all dimensions (iDM) , excellent support