We performed a comparison between Oracle Integration Cloud Service and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Integration Platform as a Service (iPaaS) solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature of Oracle Integration Cloud Service is its performance."
"Oracle Integration Cloud Service is a really good product and the ROI is very good with it. It lowers development time. A development cycle that may have taken a year without Oracle Integration Cloud Service can drop down to three or four months with it."
"Oracle Integration Cloud Service offers a lot of adaptors."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"The most valuable feature is the ease of customization."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"The out-of-box integration between Oracle and SAP is really beneficial"
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"The amount of data that it loads and processes is good."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"It's my understanding that the product can scale."
"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"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."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"Lacks features for more complex integrations."
"The support and resources were lacking — they weren't there."
"The solution is expensive."
"We would love to have more and more ready-to-use interfaces from Oracle."
"The solution's customer service could be better."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"The product needs more plugins."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"I would like to see improvements made for real-time data processing."
"One thing that I don't like, just a little, is the backward compatibility."
"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."
"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."
More Oracle Integration Cloud Service Pricing and Cost Advice →
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Oracle Integration Cloud Service is ranked 3rd in Integration Platform as a Service (iPaaS) with 32 reviews while Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 48 reviews. Oracle Integration Cloud Service is rated 8.0, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Oracle Integration Cloud Service writes "An integration tool that is highly compatible and easy to maintain". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". Oracle Integration Cloud Service is most compared with Oracle Data Integrator (ODI), AWS Glue, Mule Anypoint Platform, Oracle GoldenGate and Azure Data Factory, whereas Pentaho Data Integration and Analytics is most compared with SSIS, Azure Data Factory, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue. See our Oracle Integration Cloud Service vs. Pentaho Data Integration and Analytics report.
We monitor all Integration Platform as a Service (iPaaS) 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.