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 agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The user interface and user experience are perfectly all right."
"Mainstream integration and real-time integration are the best features."
"The most valuable feature is connectivity to data sources."
"It is a scalable and versatile solution."
"The scalability is excellent."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"It is easy to integrate the solution with other tools."
"Besides loading data, we do most of our transformations in ODI."
"Oracle provides great documentation."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"The initial setup is easy."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The tool is reliable, quick, and powerful."
"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 technical support is excellent."
"If you compare it to SQL, the memory and development times are very quick."
"I am impressed with the tool's ability to customize."
"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."
"Pushdown optimization could be improved."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"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 solution could be made more user-friendly. The configurations are also quite difficult."
"Integration with the largest number of databases and other systems would be important."
"Technical support can be improved with respect to delays in ticket response time."
"I would like the stability to improve."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"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."
"The performance of the user interface is in need of improvement."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"We used a third party to do the implementation of ODI."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"Stability could be improved because some operators have issues."
"If you have something like Cisco on top of it, you will have endless problems."
"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."
"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."
"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."
"I would like the tool to include the ability to automate the modifications of the integrations."
"The solution is quite expensive and hard to install/configure."
"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."