You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time. In my experience, it is able to transform a large amount of data within a few seconds.

If you have one environment that is for some application and it has a lot of data, and you need this information not only for the application but also for a warehouse - to do some analytics later - you just transform all that data to the... more»

Brazil IT Coordinator at a transportation company with 1,001-5,000 employees

Aug 24 2017

What do you think of Pentaho Data Integration?

Valuable Features:
Data transformation within Pentaho is a nice feature that they have and that I value.
• Improvements to My Organization:
Integration between databases and data import for a BI solution.
• Room for Improvement:
I would like to see more improvements with AS400 DB2. I journalled the tables/instance and the data migration is too slow if I compare it with other databases.
• Deployment Issues:
There were no issues with the deployment.
• Stability Issues:
Until now, the stability of Pentaho is great. I've already tested various scenarios and I didn't feel a loss of performance.
• Scalability Issues:
There have been no issues so far in scaling the product.
• Initial Setup:
I used self-learning to implement it and found that the tool is very...

The core replication and its performance. Performance was crucial and, as such, SharePlex is by far the fastest. However, replication to multiple targets as well as from multiple sources to a single target, along with basic filtering and the... more»

For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison. Queue manipulation as well. It lacks functionality for refining data during the... more»