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 features of Oracle Integration Cloud Service are the seeded integrations with many communication platforms, such as Slack and emails. It works best for the historical communication methods. Those are still prevalent with all the other clients. When we are doing the integrations, it makes it a little bit easier for us to communicate the same output over Slack, rather than sending out an email and downloading the report. The number of seeded functionalities within the Oracle Integration Cloud Service platform is better."
"It's easy to build an integration and make changes to it."
"It is a scalable solution."
"Oracle Integration Cloud Service integrates well and is user-friendly. If you are not a developer or ops engineer you can still use the solution with ease. You do not need to have developers' knowledge, you can easily adapt and learn quickly to integrate the services. They have good documentation."
"The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding."
"OIC offers a number of pre-built technology and SaaS adapters for high productivity for a wide range of target systems, both in-house via agents and cloud/SaaS, via a very flexible range of interfaces."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The solution is scalable."
"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."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"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."
"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."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"It's my understanding that the product can scale."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"It has lengthy documentation, making the process of building applications more time-consuming."
"Configurable timeouts on each connection would be good."
"Oracle Integration Cloud Service can improve file handling. Currently, our real-time file polling limitation is 10 MB, if that size can be increased it would be helpful. For example, increasing the size from 10 MB to 1 GB."
"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release."
"The bulk processing needs improvement."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"They need to make tools framework available for implementation partners"
"If you develop it on MacBook, it'll be quite a hassle."
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."
"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."
"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."
"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."
"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."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
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 16th 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), Mule Anypoint Platform, AWS Glue, Oracle GoldenGate and Azure Data Factory, whereas Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, 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.