Data Quality : Pentaho vs Informatica
Informatica: Does not have that many DQ features, but there is another product called Informatica Data Quality which has many DQ features.
Pentaho: Has practical monitoring tools and logging.
Informatica: Has extensive monitoring tools and logging.
Pentaho: Can connect to a very wide variety of databases, flat files, xml files, excel files and web services.
Informatica: Can connect to a huge number of databases, mainframes, flat files, excel files and web services. It can also export as a web service.
Pentaho: The Java-connector slows it down somewhat. Also requires manual tweaking like Talend. Can be clustered by placed on many machines to reduce network traffic.
Informatica: Is the fastest tool. It has an advanced “Pushdown” option that localizes transformation tasks depending on how busy the machine is.
Data Quality : Pentaho vs Informatica[/signinlocker]