Comparison between kettle and several other ETL tools (including Informatica)

Cost:
Software costs include software products, pre-sales training, after-sales consulting, and technical support.
Open-source products are free of charge and the cost is mainly training and consulting, so the cost will remain at a low level.
Commercial Products are expensive, but generally offer free consultation or support several times. Therefore, the initial cost of using commercial software is very high, but it is gradually decreasing.
Manual coding is not costly at first, mainly because of the labor cost, but the workload for later maintenance will increase.

Risks:
Projects are risky, especially large projects.
Project risks mainly include: exceeding the budget, project extension, failing to meet user satisfaction and expectations
Because of its price advantages, open-source products can greatly reduce project risks.

Ease of use:
Talend: provides GUI but Eclipse plug-ins.
Kettle: There is a very easy-to-use GUI and problems can occurCommunityConsultation.
Informatica: provides easy-to-use GUI, but requires specialized training.
Inaplex inaport: no GUI

Technical support:
Talend: mainly in the United States
Kettle: technical support personnel can be found in the United States, Europe (Belgium, Germany, France, UK), Asia (China, Japan, and South Korea.
Informatica: all over the world
Inaplex inaport: mainly in UK

Deployment:
Talend: Create a Java or perl file and run it using the Operating System Scheduling Tool.
Kettle: You can use job or operating system scheduling to execute a conversion file or job file, or deploy it on multiple machines in a cluster.
Informatica: Server required
Inaplex inaport: requires. NET 2.0

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

Data quality:
Talend: provides data quality features in the GUI. You can manually write SQL statements.
Kettle: provides data quality features in the GUI. You can manually write SQL statements, java scripts, and regular expressions to clean data.
Informatica: A specialized product, Informatica data quality, to ensure data quality.
Inaplex inaport: data cleansing is easier because only specific data is processed.

Monitoring:
Talend: provides monitoring and log tools.
Kettle: Monitoring and logging tools
Informatica: provides detailed monitoring and log tools.
Inaplex inaport: provides monitoring and log tools.

Connectivity:
Talend: common databases, files, and Web services.
Kettle: a wide range of databases, files, and extensions.
Informatica: various data sources
Inaplex inaport: ODBC connection

Original article connection http://www.pentaho.com/docs/informatica_pentaho_etl_tools_comparison.pdf