![Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_64/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACAGSGT)

Informatica PowerExchange and SAS Data Management compete in the data integration and management software category. Informatica PowerExchange seems to have the upper hand due to its robust integration capabilities and real-time features.
Features: Informatica PowerExchange offers high-performing integration with tools like Teradata and excels in Change Data Capture (CDC). It supports non-Oracle systems such as SAP and Hana and integrates comprehensively with Hadoop. SAS Data Management provides excellent data governance and metadata management features, with easy data mart and data lake creation, along with robust data standardization and transformation capabilities.
Room for Improvement: Informatica PowerExchange could improve in pricing competitiveness and real-time data processing, and it faces challenges with newer Oracle features and connectivity. Users also seek easier democratization for data integration. SAS Data Management could simplify non-ETL use cases and connectivity, and address its steep learning curve and expensive licensing.
Ease of Deployment and Customer Service: Both products are primarily deployed on-premises, with SAS offering hybrid cloud options. Informatica users have mixed experiences with customer support, citing issues with response times, while some report timely assistance. SAS support is generally reliable but occasionally unavailable.
Pricing and ROI: Both solutions are expensive, with Informatica known for high licensing costs that deliver significant value through integration and real-time capabilities. SAS faces scrutiny for its price but offers strong multifunctional value. Users of both products experience tangible ROI through better data decisions.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
Reliable data plus less human intervention and less error result in a strong return on investment.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
The support for SAS in Brazil is not the best one, but the support in Sweden is really good, as they visit the company and work to solve the issues.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
SAS Data Management can be improved in terms of the learning curve.
There is significant room for improvement, especially with regard to using a hybrid approach that involves both CAS and persistent storage.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
From my experience, SAS Data Management is an expensive tool.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
SAS Data Management's best feature is first, data reliability because SAS Data Management is a very trusted platform.
SAS Data Management stands out because of its data standardization, transformation, and verification capabilities.
The metadata management feature of SAS Data Management helps a lot; creating your data marts or data lake with good naming conventions, library conventions, and so on is very important because it allows easy queries to find the whole structure, though I think metadata governance also depends on first definitions, not only on the tool.

| Company Size | Count |
|---|---|
| Small Business | 8 |
| Midsize Enterprise | 3 |
| Large Enterprise | 12 |
| Company Size | Count |
|---|---|
| Small Business | 8 |
| Midsize Enterprise | 2 |
| Large Enterprise | 8 |
Informatica PowerExchange [EOL] offers advanced data integration capabilities, emphasizing data transformation, real-time integration, and connectivity to diverse data sources, ensuring seamless access and management of big data in complex environments.
Informatica PowerExchange [EOL] is a robust tool for managing data integration and transformation processes. It supports connectivity to numerous sources, enabling real-time data capture and transformation. With native connectors and APIs, it allows seamless integration, ensuring data mapping across data formats. While strong at data handling and integration, improvements in pricing, real-time processing, and enhanced technical support are necessary. Expanded cloud integration and improved high availability will further bolster its efficiency in managing extensive datasets, supporting ETL, and integrating systems like SAP.
What are the most important features of Informatica PowerExchange?Informatica PowerExchange [EOL] is implemented widely in sectors requiring robust data integration solutions. It serves industries such as finance, healthcare, and retail, facilitating the creation of data warehouses and lakes. Used for ETL processes and operational analytics, it integrates systems like Hadoop, Oracle, and legacy environments, driving efficient communication and information sharing.
SAS Data Management provides data integration, governance, and robust reporting tools. It connects to diverse data sources, ensuring quality management and enabling data analysis for technical and non-technical users.
SAS Data Management features flexible data flow creation, scheduling, and ETL control. It enhances data integration and metadata management with tools that support data standardization. Users benefit from its importing and exporting capabilities, connecting to multiple sources. It facilitates improved data quality management and offers a flexible language for diverse needs. Data visualization capabilities further support decision-making across industries, automating reports and data warehouses.
What are the key features of SAS Data Management?SAS Data Management helps industries like finance integrate diverse data sources for analytics and reporting. It is used for tasks such as financial reporting, credit risk analysis, and data cleansing. Through user-driven automation, it aids in aligning data warehouses and generating insightful visual outputs, making it ideal for analyzing structured data from sources like Excel and CSV files.
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.