We performed a comparison between Pentaho Data Integration and Analytics and Qlik Replicate based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."
"Provides a good open source option."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"The solution has a free to use community version."
"It enables us to transform data at the latest stage rather than in ETL loads, so it's more ELT which is one of the advantages. It is also in near real-time, which brings significant advantage for our embedded analytics approach."
"A valuable feature of Qlik Replicate is that you do not need ETL. It's easy to use—you choose two systems and it automatically replicates them. Even if there is no CDC available, if you insert it and update it, and there is nothing to find out, then you can use Qlik Replicate. It's a good product."
"We use Qlik Replicate to change data capture of databases in production environments."
"A pretty good series of connectors is one of the best features of Qlik Replicate."
"Low-priced reporting and analytics solution, with good scalability and stability. It has on-premises and cloud versions that are cohesive and can integrate well."
"The CDC and the flexibility to use QVD as a source are the most valuable features of Qlik Replicate."
"It's very user-friendly when it comes to settings and configuration. It also offers very detailed logging about warnings and errors."
"From a technical perspective, this is an excellent product."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"I would like to see more improvements with AS400 DB2."
"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."
"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking."
"In the next release, I would like to see closer integration with data catalyst."
"We'd like better connectivity."
"We would like to see more details in messages about errors with the system."
"It would be better if the solution’s pricing were more obvious."
"Support for this product is not great. It needs to be improved."
"When you remote into it the Qlik Replicate UI a lot of times it just freezes. We set up the EC2, to allow them to go to the server and click on the Replicate icon, it just opens up and just sits there. At that point, we have to go into the EC2 and then reboot the server. This should be fixed, it is frustrating."
"Support-wise, this solution is in need of improvement."
"This product could be improved by providing more insight regarding errors. One of our customers that uses Qlik Replicate has had an issue. We tried to debug it, but we could not trace the error message. The infrastructure site should give us more insight about errors. Qlik Replicate is not a business solution, it's an IT solution. The reporting tools and bug site should be improved."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews while Qlik Replicate is ranked 17th in Data Integration with 12 reviews. Pentaho Data Integration and Analytics is rated 8.0, while Qlik Replicate is rated 8.2. The top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". On the other hand, the top reviewer of Qlik Replicate writes "A highly stable solution that can be used to change data capture in legacy systems". Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue, whereas Qlik Replicate is most compared with Oracle GoldenGate, AWS Database Migration Service, Qlik Compose, Azure Data Factory and Fivetran. See our Pentaho Data Integration and Analytics vs. Qlik Replicate report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.