We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and TIBCO BusinessWorks based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The interface is very clean and clear."
"It reduces a lot of legacy coding."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"It's very easy to use it to develop mappings and workflows."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"Informatica PowerCenter is a very good ETL tool."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"The initial setup is easy."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The scalability is great. It's one of the reasons we chose the solution."
"It is user friendly, it's not complex."
"The most important thing is that it is easy for developers to work with."
"The most valuable feature is the low-code platform."
"The solution is stable. We haven't had any serious technical issues."
"The most valuable part of the solution is the ease-of-use and ease of deployment."
"The most valuable feature is the integration."
"It is a seamless and sophisticated tool."
"BusinessWorks reduces development time, helping developers to focus on business logic."
"It should be more cloud-centric than on-prem-centric."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Lacks ability to calculate cost of the product."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The initial setup is complex, especially if you also have to install a console."
"If you have something like Cisco on top of it, you will have endless problems."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The initial setup is a bit complex compared to other tools."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"They don't support out of the box - you have to buy adapters or you have to have the technology."
"There are multiple plugins which increase the number of product installations."
"The communication protocols could be improved."
"This solution's cloud could be improved. I don't know whether it was because we didn't have the internal expertise or if it was the product itself, but since they came later—I think only two or three years into the cloud—after many other iPaaS that had been in the cloud for longer, I feel that maybe they haven't matured in terms of the cloud."
"Its price can be improved. For medium enterprises, it is a very expensive tool. In the market, you won't get many resources for this solution. You won't find many developers in the market very easily. The latest version of TIBCO (6.4 or 6.x) is not very stable. It has got many issues. We have raised this with TIBCO, and they are taking a lot of time to come up with a fix, which is making us move away from this product. Some of the performance-tuning aspects are also missing in version 6. They should provide performance-related fixes, which will be helpful for the customers. If you are migrating from the current version to the container-supported version, it is quite expensive. The product has evolved, but it is very pricey. That's one of the challenges. They have provided all the features that are there in other products, but this is a platform upgrade. The platform has completely been changed from 5.x to 6.x, and we can't use the same environment. We can't run both versions on the same server as VM. The development environment is entirely different. In version 5.x, there was a proprietary designer. Now, it has common plug-ins developed on top of Eclipse."
"The container-based image is too large and this makes auto-scaling difficult."
"I would like the solution to be integrated into the cloud."
"Though it is a stable product, if we have an issue with the product, it gets difficult, and it gets really difficult to explain the issue to the support team. Also, it takes a long time to get resolved."