Oracle Integration Cloud Service vs Pentaho Data Integration and Analytics comparison

The compared Oracle and Hitachi Vantara solutions aren't in the same category. Oracle is ranked #3 in PaaS , with an average rating of 8.2, and holds a 9.6% mindshare in the category. Hitachi Vantara is ranked #24 in DI , with an average rating of 7.6, and holds a 1.5% mindshare. Additionally, 87% of Oracle users are willing to recommend the solution, compared to 94% of Hitachi Vantara users who would recommend it.

Oracle Integration Cloud Se...

Read 36 Oracle Integration Cloud Service reviews

2,830 Views
1,843 Comparison Views

87% willing to recommend

Pentaho Data Integration an...

Read 52 Pentaho Data Integration and Analytics reviews

2,438 Views
1,080 Comparison Views

94% willing to recommend

Oracle Integration Cloud Se...

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

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.

To learn more, read our detailed Oracle Integration Cloud Service vs. Pentaho Data Integration and Analytics Report (Updated: July 2023).

Buyer's Guide

Oracle Integration Cloud Service vs. Pentaho Data Integration and Analytics

July 2023

Download the complete report

Helped 824,067 peers since 2012

Categories and Ranking

Oracle Integration Cloud Se...

Average Rating

7.8

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Integration Platform as a Service (iPaaS) (3rd)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (24th)

Mindshare comparison

Oracle Integration Cloud Service and Pentaho Data Integration and Analytics aren’t in the same category and serve different purposes. Oracle Integration Cloud Service is designed for Integration Platform as a Service (iPaaS) and holds a mindshare of 9.6%, down 11.3% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.5% mindshare, up 0.6% since last year.

Integration Platform as a Service (iPaaS)

Data Integration

Featured Reviews

Divya Prakash

Technical Architect at Hexaware Technologies Limited

An integration tool that is highly compatible and easy to maintain

Dealing with the large file sizes has occasionally been a challenge, though we have found workarounds. But dealing with large file sizes could be easy in integrations. I have also come across schema files where headers, footers, and bodies are there, but it's not a valid schema. None of the MSCAs are defined properly. In such cases, we have to think of multiple workarounds, such as splitting or merging. But this is a standard requirement for organizations, so custom solutions should be provided. There are cases when the systems don't expect additional MSCAs, or they expect headers, footers, or tags with different values. But this is not a proper XML. So if we are dealing with XML conversions, mapping, and integrations, we have to do some custom work. These are solutions that Oracle can provide.

Read full review

Ryan Ferdon

Senior Data Engineer at Burgiss

Low-code makes development faster than with Python, but there were caching issues

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. It was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.

Read full review

Quotes from Members

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

Pros

"Oracle Integration Cloud Service offers a lot of adaptors."

"Provides various ways to secure services as well as providing extensive support."

"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."

"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."

"It's easy to build an integration and make changes to it."

"It is a scalable solution."

"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."

More Oracle Integration Cloud Service pros

"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."

"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."

"It's my understanding that the product can scale."

"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."

"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."

"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."

"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."

"Provides a good open source option."

More Pentaho Data Integration and Analytics pros

Cons

"Now the platform is not built in a way that you can define."

"The solution's customer service could be better."

"If an inbound file is larger than one GB, it cannot be transformed within Oracle."

"Dealing with the large file size has occasionally been a challenge."

"I have faced situations where the solution has gone down for five to seven minutes, which is an issue if it happens in the live production environment."

"The solution is expensive."

"While most of the adapters are available through Oracle Integration Cloud Services, they do not have a lot of features. I would like to see some enrichment in this area and for the solution to go deeper into the applications and upgrade the adapters."

"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."

More Oracle Integration Cloud Service cons

"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."

"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..."

"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."

"One thing that I don't like, just a little, is the backward compatibility."

"I would like to see more improvements with AS400 DB2."

"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."

"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."

"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 Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

"The price of Oracle Integration Cloud Service is good. It is reasonable and is priced well for the market segment. The model they use is on a per-package unit and we have a two-year subscription."

"The solution is less expensive than other products."

"The price is cheaper than all other cloud integration providers."

"Oracle uses a universal credit model for OCI. Clients commit to an annual budget and can choose which products to use and build during their contract period. Billing is based on consumption - you're only billed for the products you use."

"Its pricing is relatively lower than other vendors."

"The price of Oracle Integration Cloud Service is reasonable to start with, but when you scale it becomes expensive."

"It specifies how much data you use and how much storage you require, among other things."

"The price is fair."

More Oracle Integration Cloud Service pricing and cost advice

"It does seem a bit expensive compared to the serverless product offering. Tools, such as Server Integration Services, are "almost" free with a database engine. It is comparable to products like Alteryx, which is also very expensive."

"I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

"There is a good open source option (Community Edition)."

"The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

"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 and Analytics pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.

See recommendations

824,067 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

43%

Computer Software Company

Financial Services Firm

Manufacturing Company

Financial Services Firm

23%

Computer Software Company

15%

Government

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?

Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...

See all answers

What do you like most about Oracle Integration Cloud Service?

Oracle Integration Cloud Service offers a lot of adaptors.

See all answers

What is your experience regarding pricing and costs for Oracle Integration Cloud Service?

It is not really a high price for the value it gives. However, when you start doing the customization, it’s a bit expensive because I need to start provisioning other services before deployment. So...

See all answers

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

See all answers

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

See all answers

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

See all answers

Comparisons

Oracle Data Integrator (ODI) vs Oracle Integration Cloud Service

Compared 28% of the time

Microsoft Azure Logic Apps vs Oracle Integration Cloud Service

Compared 9% of the time

AWS Glue vs Oracle Integration Cloud Service

Compared 9% of the time

SAP Cloud Platform vs Oracle Integration Cloud Service

Compared 8% of the time

Azure Data Factory vs Oracle Integration Cloud Service

Compared 7% of the time

More Oracle Integration Cloud Service Competitors

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 15% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 14% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 10% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 10% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

Oracle Integration Cloud Service

November 2024

Download Oracle Integration Cloud Service product report

Buyer's Guide

Pentaho Data Integration and Analytics

December 2024

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Also Known As

Oracle ICS

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Learn More

Oracle

Hitachi Vantara

Overview

Oracle Integration Cloud Service is a cloud-based integration tool that seamlessly integrates on-premise applications with Oracle Cloud (SaaS) or other cloud apps (for example, Workday, Salesforce, etc.) to other cloud apps. Oracle’s solution combines all the capabilities of application integration, process automation, visual application building, and integration analytics into a single unified cloud service. The solution offers real-time and batch-based integration, structured and unstructured processes, case management, stream analytics, and integration insight. All of these capabilities together allow users to service all their end-to-end integration needs in one cohesive platform.

Oracle Integration Cloud Service Features

Oracle Integration Cloud Service has many valuable key features. Some of the most useful ones include:

Visual application builder service
Integration insight
Process automation
Visual application design
SaaS and on-premises integration
Stream analytics
Easy setup

Oracle Integration Cloud Service Benefits

There are many benefits to implementing Oracle Integration Cloud Service. Some of the biggest advantages the solution offers include:

Powerful dashboards: The solution provides users with all the information they need via powerful dashboards that require no coding, configuration, or modification.

Agility: Oracle Integration Cloud Service brings agility to organizations with an easy, visual, low-code platform that simplifies day-to-day tasks by getting employees, customers, and partners the services they need to work anywhere, anytime, on any device.

Visual development environment: With the solution’s visual development environment, users can rapidly create and host engaging business applications.

Top-tier security: With Oracle Integration Cloud Service, users are protected with various forms of top-tier security, including physical protection, OS security, and virtualization layer security, as well as tenant isolation for devoting more resources towards a specific user or customer.

More than 50 native app adapters: Because the solution has more than 50 native app adapters, users can quickly connect to thousands of SaaS or on-premises applications seamlessly.

Reviews from Real Users

Oracle Integration Cloud Service is a solution that stands out when compared to many of its competitors. Some of its major advantages are that it has good adapters, is user friendly, and produces a solid ROI.

Rishabh S., Business and Technology Delivery Associate Manager at Accenture, says, “It has good performance, easy integration, is user-friendly, and also has helpful technical support. The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive. You do not need a third-party dashboard or logging framework when you initiate the integration. There are a lot of adapters, which is what I like the most.”

“The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects,” says PeerSpot user Arun N., Technical Manager at a financial services firm.

Kanhaiya C., Solution Architect at Tata Consultancy, explains, "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."

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Sample Customers

Calix, Avaya, Land Lakes, Leader, PWC, Vale

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

Buyer's Guide

Oracle Integration Cloud Service vs. Pentaho Data Integration and Analytics

July 2023

Free Report: Oracle Integration Cloud Service vs. Pentaho Data Integration and Analytics

Find out what your peers are saying about Oracle Integration Cloud Service vs. Pentaho Data Integration and Analytics and other solutions. Updated: July 2023.

DOWNLOAD NOW

824,067 professionals have used our research since 2012.

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.