We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and SAS Data Integration Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"Good interface, reasonable documentation."
"It is an excellent ETL tool."
"It's a complete package, which is why we use this solution."
"It has good standard features for ETL development."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Once you have learned Informatica, it is very easy to use."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The CAEM is very useful in its modularity and portability."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"The scalability is great. It's one of the reasons we chose the solution."
"Besides loading data, we do most of our transformations in ODI."
"Oracle provides great documentation."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The solution offers very good data manipulation and loading."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"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."
"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."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"Integrating new tools can be tricky and challenging."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"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."
"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."
"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."
"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."
"The initial setup is complex, especially if you also have to install a console."
"The performance of the user interface is in need of improvement."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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 transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."