We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Has a good visual tool for data mapping."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"It has good standard features for ETL development."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"The number of docs has been reduced drastically, which is very good."
"It is an ETL tool, which does the extract, transform, and load."
"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."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"The initial setup is easy."
"Besides loading data, we do most of our transformations in ODI."
"The scalability is great. It's one of the reasons we chose the solution."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It's saved time using visualization descriptions."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"The solution does not scale."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"The resource management aspect of the solution could be improved."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"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."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The initial setup is complex, especially if you also have to install a console."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"Tuning using this solution requires extensive expertise to improve performance."
"It hangs a lot of the time."
"I would like to see better technical documentation because many times information is missing."
"It's a legacy tool, that is nearing the end of its useful life."
"Improvement as per customer requirements."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"Performance could be better."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."