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."It's easy to build an integration and make changes to it."
"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 very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"Provides various ways to secure services as well as providing extensive support."
"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."
"OIC's accuracy is quite good."
"The most valuable feature of Oracle Integration Cloud Service is its performance."
"The solution is scalable."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"The amount of data that it loads and processes is good."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"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."
"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."
"The solution has a free to use community version."
"The solution is expensive."
"They need to make tools framework available for implementation partners"
"There are a few features that we noticed are not in the cloud. There are some improvements needed. One example is the graphical user interface that needs to improve, it could be easier to use."
"It has lengthy documentation, making the process of building applications more time-consuming."
"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."
"Configurable timeouts on each connection would be good."
"The logging capabilities could be enhanced. Currently, logs are only retained for a few days, which can be inconvenient for administrators. Ideally, we'd like the option to configure log retention periods, like a month or fifteen days, instead of the current one-week limit."
"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."
"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 product needs more plugins."
"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."
"One thing that I don't like, just a little, is the backward compatibility."
"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."
"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."
"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."
"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."
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.