Pentaho data integration is a multiplatform (Java) ETL tool (and more) it allow their users to intuitively integrate data through multiple data sources, it is easy to use and really powerful
1. While using Kettle environment variables the appication doesnt work as intended which can be frustrating. 2. Unless paying for the tool, the implementation is something that one has to figure out by themselves.
There is an open source version which allows you to get started. It has 100s of connectors to connect to Salesforce, SAP, Oracle, ODBC, JDBC, XML, Access, flat files. Also a whole host of other components WebServices, FTP and Email. The transformation tools...
The fact that it's a code generator and requires compiling of the entire code-base anytime you want to test a small change can lead to a frustrating development experience. Job re-use is difficult to achieve with this tool, passing data back and forth is...
Pentaho data integration is a multiplatform (Java) ETL tool (and more) it allow their users to intuitively integrate data through multiple data sources, it is easy to use and really powerful
There is an open source version which allows you to get started. It has 100s of connectors to connect to Salesforce, SAP, Oracle, ODBC, JDBC, XML, Access, flat files. Also a whole host of other components WebServices, FTP and Email. The transformation tools...
1. While using Kettle environment variables the appication doesnt work as intended which can be frustrating. 2. Unless paying for the tool, the implementation is something that one has to figure out by themselves.
The fact that it's a code generator and requires compiling of the entire code-base anytime you want to test a small change can lead to a frustrating development experience. Job re-use is difficult to achieve with this tool, passing data back and forth is...