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 solution is stable."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It's very easy to use it to develop mappings and workflows."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"The most valuable features are the monitoring tools and the reporting manager."
"It's a complete package, which is why we use this solution."
"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."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"The initial setup is easy."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"The installation of the client ODI Studio is easy."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"It's completely user-friendly."
"The most valuable feature that we use is the Knowledge Modules."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The product has an ELT approach."
"Good TIBCO BusinessWorks features are the admin console and the ability to roll back to the previous version."
"I work in operations, so I value BusinessWorks' performance the most."
"The most valuable feature is the low-code platform."
"Areas for improvement would be the cloud fitness of the product and the ease of migrating to newer versions."
"It is very stable. It is a market leader, and it has connectors to many of the legacy systems. It also has enterprise cloud connectors."
"The solution is very scalable. It can handle a lot. We have encryption plus integration servers running on that platform currently."
"It is user friendly, it's not complex."
"It is a very robust system."
"Its scalability can be improved. It is not scalable."
"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."
"The solution must improve the integration with new services."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"The solution does not scale."
"Integration with Artificial Intelligence would benefit this solution."
"There is some room for improvement in terms of pricing."
"It should be more cloud-centric than on-prem-centric."
"Reverse engineering is complicated and challenging to manage."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The price needs to be lowered. It's too expensive."
"Technical Support could be better."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"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."
"A possible improvement could be to give the capability to use different profiles for each AppNode when an application is deployed on an AppSpace."
"The Business Studio tool can be improved, which is the tool for designing the processes. Improving the Business Studio tool will make this solution more stable. It has a steep learning curve, and it is pretty tough to learn."
"They don't support out of the box - you have to buy adapters or you have to have the technology."
"I'd like to see a new cloud approach in the next release. They need to work on integrations, stability and management issues on their cloud platform."
"Improve Business Studio's stability to further minimize development time."
"Cloud fitness is lacking"
"TIBCO BusinessWorks could be improved with cloud support."