We performed a comparison between Oracle Data Integrator (ODI), Pentaho Data Integration and Analytics, and TIBCO Cloud Integration based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Besides loading data, we do most of our transformations in ODI."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"It's scalable."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"It's very simple compared to other products out there."
"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."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"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."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."
"It's my understanding that the product can scale."
"The product's initial setup phase was easy."
"I like that it is a very good integration tool with many other things. TIBCO is very good for cloud integration"
"I am really impressed by TIBCO's integration of any level of complexity."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"Stability could be improved because some operators have issues."
"Reverse engineering is complicated and challenging to manage."
"It needs easier security."
"The initial setup is a bit complex compared to other tools."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The solution lacks some functions and features."
"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."
"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."
"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."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"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."
"If you develop it on MacBook, it'll be quite a hassle."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."
"TIBCO Cloud Integration is not a user-friendly tool when it comes to the installation phase or for maintaining the systems since its architecture is really complex."
"The deployment was rather complicated."
"Integrations could be better. Although integration is good, we have faced some block issues."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →