We performed a comparison between Informatica PowerExchange 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."From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"Mainstream integration and real-time integration are the best features."
"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."
"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."
"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."
"This product is easy to install and it can be done in a few hours."
"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."
"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."
"This is an established product with powerful data analysis and varied options for user entry points."
"The technical support is excellent."
"The product offers very good flexibility."
"I am impressed with the tool's ability to customize."
"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 product's high costs can be an area of concern where improvements are required."
"Should diversify more, maybe with a reporting and visualization utility,"
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"I would like to have easier integration with cloud platforms."
"The product is not suitable for application integration."
"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."
"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."
"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."
"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."
"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."
"I would like the tool to include the ability to automate the modifications of the integrations."
"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."
"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."
"The solution could use better documentation."
Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews while SAS Data Management is ranked 43rd in Data Integration with 15 reviews. Informatica PowerExchange is rated 7.8, while SAS Data Management is rated 8.4. The top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". On the other hand, the top reviewer of SAS Data Management writes "A scalable solution with customer support that is responsive and diligent". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Azure Data Factory, SSIS and Qlik Replicate, whereas SAS Data Management is most compared with Informatica PowerCenter, Tungsten RPA, Microsoft Purview, Palantir Foundry and IBM InfoSphere DataStage.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.