We performed a comparison between Informatica PowerExchange, SAS Data Management, and SSIS 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."
"Mainstream integration and real-time integration are the best features."
"It is a scalable and versatile solution."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The user interface and user experience are perfectly all right."
"The product’s flexibility is valuable."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"This product is easy to install and it can be done in a few hours."
"The product offers very good flexibility."
"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."
"This is an established product with powerful data analysis and varied options for user entry points."
"I am impressed with the tool's ability to customize."
"The technical support is excellent."
"If you compare it to SQL, the memory and development times are very quick."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"The tool is reliable, quick, and powerful."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It is easy to set up. The deployment is also very quick."
"The most important features are it works well and provides self-service BI."
"SSIS' best feature is SFTP connectivity."
"The performance is good."
"The technical support is very good."
"The data reader is the most valuable feature."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"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."
"Integration with the largest number of databases and other systems would be important."
"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."
"I would like to have easier integration with cloud platforms."
"The product's high costs can be an area of concern where improvements are required."
"The solution needs better integration with other tools."
"The solution is quite expensive and hard to install/configure."
"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."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"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."
"I would like the tool to include the ability to automate the modifications of the integrations."
"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."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"The creation of the measure in the DAC's model could be improved."
"It's a legacy tool, that is nearing the end of its useful life."
"The performance of SSIS could improve when comparing it to Oracle Database."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"We'd like them to develop data exploration more."
"I would like to see better technical documentation because many times information is missing."