We performed a comparison between Informatica PowerExchange, Oracle Data Integrator (ODI), and SAS Data Management based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The user interface and user experience are perfectly all right."
"It is a scalable and versatile solution."
"The data transformation is the solution's most valuable feature."
"It is easy to integrate the solution with other tools."
"Mainstream integration and real-time integration are the best features."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The most valuable feature is connectivity to data sources."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"It's completely user-friendly."
"Oracle provides great documentation."
"Besides loading data, we do most of our transformations in ODI."
"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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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 Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"It has the ability to easily load slowly changing dimensions."
"The technical support is excellent."
"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"I am impressed with the tool's ability to customize."
"The tool is reliable, quick, and powerful."
"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."
"This is an established product with powerful data analysis and varied options for user entry points."
"The product offers very good flexibility."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"I would like the stability to improve."
"The product is not suitable for application integration."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Pushdown optimization could be improved."
"Should diversify more, maybe with a reporting and visualization utility,"
"I would like to have easier integration with cloud platforms."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"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 performance of the user interface is in need of improvement."
"Technical Support could be better."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"If you have something like Cisco on top of it, you will have endless problems."
"The solution could use better documentation."
"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."
"I would like the tool to include the ability to automate the modifications of the integrations."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"The solution is quite expensive and hard to install/configure."
"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."
"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."