Comparison of several ETL tools (Kettle,talend,informatica, etc.)

Cost:
software costs include many aspects, including software products, pre-sales training, after-sales consulting, technical support and so on.
The open source product itself is free, the cost is mainly training and consulting, so the cost will remain at a lower level.
The commercial product itself is very expensive, but it usually offers several free consultations or support, so the use of commercial software initially costs a lot, but decreases gradually.
Manual coding initially cost is not high, mainly labor costs, but later maintenance of the workload will be more and more large.

Risk:
Projects are risky, especially big projects.
The risks of the project include: exceeding the budget, delaying the project, not meeting the customer's satisfaction and expectation.
Because of the price advantage, open source products can reduce the risk of the project to a great extent.

Ease of Use:
Talend: GUI graphical interface but provided in Eclipse plug-in mode.
Kettle: There is a very easy-to-use GUI, where problems can come to community counseling.
Informatica: There is a very easy-to-use GUI, but specialized training is needed.
Inaplex Inaport: No GUI

Technical Support:
Talend: Mainly in the United States
Kettle: In the United States, Europe (Belgium, Germany, France, the United Kingdom), Asia ( China , Japan, Korea) can find the relevant technical support staff.
Informatica: All over the world
Inaplex Inaport: Mainly in the UK

Deployment:
Talend: Create a java or Perl file and run it through the operating system scheduling tool
Kettle: You can use job Job mode or operating system scheduling to execute a transform file or job file, or you can deploy it on multiple machines in a clustered way.
Informatica: Requires a Server
Inaplex Inaport: Requires. NET 2.0

Speed:
Talend: Manual adjustments are required to optimize knowledge of specific data sources.
Kettle: Faster than Talend, but it also needs to be manually adjusted to optimize data sources such as Oracle and Postgre, and also depends on the design of the conversion task.
Informatica: is the fastest
Inaplex inaport: No optimization technology is used.

Data quality:
Talend: There are data quality features in the GUI, you can write SQL statements manually.
Kettle: Data quality features in the GUI, you can manually write SQL statements, Java scripts, regular expressions to complete the data cleansing.
Informatica: A product dedicated to Informatica data quality to ensure quality
Inaplex Inaport: Data cleansing is easier because only specific data is processed.

Monitoring:
Talend: There are monitoring and logging tools
Kettle: There are monitoring and logging tools
Informatica: Very detailed monitoring and logging tools
Inaplex Inaport: There are monitoring and logging tools

Connectivity:
Talend: Various common databases , files, Web service.
Kettle: A very extensive database, file, and also can be extended via plugins.
Informatica: Various data sources
Inaplex INAPORT:ODBC connection