We just raised a $30M Series A: Read our story

Compare Oracle Integration Cloud Service vs. Pentaho Data Integration

Cancel
You must select at least 2 products to compare!
Top Review
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: September 2021.
541,462 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors.""The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value.""The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us""The most valuable feature is the ease of customization.""The out-of-box integration between Oracle and SAP is really beneficial""It has a number of pre-built connectors. Its flow designer is also valuable. It provides the ease of promotion between environments and the ease of connection management. It is also stable and easy to scale and deploy.""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.""In general, there were a lot of great utilities for working with files."

More Oracle Integration Cloud Service Pros »

"The solution has a free to use community version.""The amount of data that it loads and processes is good.""Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.""It's my understanding that the product can scale."

More Pentaho Data Integration Pros »

Cons
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release.""Now the platform is not built in a way that you can define.""They need to make tools framework available for implementation partners""Our client was quite concerned about the cost, which is something that could be reduced.""The solution doesn't currently have a fully fledged workflow feature like they have in OIM.""It lacks configurable time-outs on connections. Configurable time-outs is an important nonfunctional property that it is currently missing. I have also written about it in an article, and I have also submitted some enhancement requests. Its visual designer could be a bit more responsive. It would also be good to get more XSLT editing capabilities.""Configurable timeouts on each connection would be good.""The support and resources were lacking — they weren't there."

More Oracle Integration Cloud Service Cons »

"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.""I would like to see improvements made for real-time data processing.""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.""The product needs more plugins."

More Pentaho Data Integration Cons »

Pricing and Cost Advice
"It has different licensing models. The most upfront and most transparent is the pay-as-you-go model. It also has a certain messages-per-hour limit. There is a certain amount that is charged per hour, and a certain number of messages are included in it, which you can scale up as you go. Its licensing is very competent and easy.""In the case of Oracle Integration Cloud, costs can be "predictable" as far as the platform and infrastructure are concerned."

More Oracle Integration Cloud Service Pricing and Cost Advice »

"The price of the regular version is not reasonable and it should be lower.""Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

More Pentaho Data Integration Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
541,462 professionals have used our research since 2012.
Questions from the Community
Top Answer: In general, there were a lot of great utilities for working with files.
Top Answer: Many open-source products can offer a high level of customizability and no upfront licensing cost. However, there can be a high cost involved in provisioning infrastructure, expertise, and other… more »
Top Answer: Improvements can be made in several areas, as follows: * Configurable timeouts on each connection would be better than a single global timeout that applies to all. The rationale for why timeouts are… more »
Top Answer: Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition :… more »
Top Answer: What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
Top Answer: It's my understanding that the product can scale.
Ranking
Views
8,083
Comparisons
6,479
Reviews
9
Average Words per Review
740
Rating
7.6
17th
Views
8,130
Comparisons
6,804
Reviews
4
Average Words per Review
624
Rating
7.8
Comparisons
Also Known As
Oracle ICS
Kettle
Learn More
Overview

Oracle Integration Cloud Service (ICS) delivers best in class “Hybrid” Integration. ICS is a simple and powerful integration platform in the cloud to maximize the value of your investments in SaaS and on-premises applications. It includes an intuitive web based integration designer for point and click integration between applications and a rich monitoring dashboard that provides real-time insight into the transactions, all running on a mature runtime platform on Oracle Public Cloud. ICS will help accelerate integration projects and significantly shorten the time-to-market through it's intuitive and simplified designer, an intelligent data mapper, and a library of adapters to connect to various applications.

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Offer
Learn more about Oracle Integration Cloud Service
Learn more about Pentaho Data Integration
Sample Customers
Calix, Avaya, Land Lakes, Leader, PWC, Vale
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Top Industries
VISITORS READING REVIEWS
Computer Software Company47%
Comms Service Provider11%
Energy/Utilities Company6%
Financial Services Firm5%
REVIEWERS
Government15%
Comms Service Provider15%
Healthcare Company15%
Financial Services Firm15%
VISITORS READING REVIEWS
Computer Software Company27%
Comms Service Provider21%
Financial Services Firm8%
Government8%
Company Size
REVIEWERS
Small Business36%
Midsize Enterprise29%
Large Enterprise36%
REVIEWERS
Small Business28%
Midsize Enterprise24%
Large Enterprise48%
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: September 2021.
541,462 professionals have used our research since 2012.

Oracle Integration Cloud Service is ranked 6th in Integration Platform as a Service (iPaaS) with 9 reviews while Pentaho Data Integration is ranked 17th in Data Integration Tools with 4 reviews. Oracle Integration Cloud Service is rated 7.6, while Pentaho Data Integration is rated 7.8. The top reviewer of Oracle Integration Cloud Service writes "Good flow design interface, scalable, and provides a good variety of connectors". On the other hand, the top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". Oracle Integration Cloud Service is most compared with Oracle Data Integrator (ODI), Mule Anypoint Platform, Boomi AtomSphere Integration, Azure Data Factory and Informatica Cloud Data Integration, whereas Pentaho Data Integration is most compared with Talend Open Studio, SSIS, Informatica PowerCenter, Oracle Data Integrator (ODI) and AWS Database Migration Service.

See our list of best Data Integration Tools vendors.

We monitor all Data Integration Tools 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.