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

Source: Internet
Author: User
Tags odbc connection

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


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.