Talend OpenStudio building your EDW at $0 cost
- JSON parsing, if you are into highly nested JSON object parsing Talend has the ability to display the structure of JSON and allows you to define the extraction logic in the metadata. Same with XML source.
- Customization, For mostly all ETL work you will have a component in Talend. And in case you have a very specific requirement you can end up easily designing a custom component that you can code and reuse and share with others.
- Talend has a connectivity option to almost all the databases (relational or NOSQ)L and sources available. It also has generic JDBC/ ODBC drivers in case you need it.
- I like the ease of deployment across environment (DEV and PROD) with the use of context variables.
Cons
- The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.