

Informatica PowerCenter and SAS Data Management are key players in the data management space. SAS Data Management holds an advantage due to its extensive features and value, while Informatica PowerCenter is more favorable in pricing and customer support.
Features: Informatica PowerCenter offers strong data integration, scalability, and data quality features. It supports a wide range of data sources and provides robust error handling and debugging tools. SAS Data Management, on the other hand, excels with its comprehensive analytics capabilities, flexible data access from multiple sources, and robust data transformation features.
Room for Improvement: Informatica PowerCenter could enhance its data analytics capabilities, improve its user interface for beginners, and streamline complex transformations. SAS Data Management might improve ease of use for non-technical users, enhance integration with diverse databases, and provide more intuitive data visualization tools.
Ease of Deployment and Customer Service: Informatica PowerCenter is recognized for its easy deployment and superior customer support, making it user-friendly in terms of implementation. SAS Data Management is slightly more complex to deploy yet offers extensive documentation and resources to assist users.
Pricing and ROI: Informatica PowerCenter generally demands a lower initial investment, making it appealing to budget-conscious businesses. Although SAS Data Management involves a higher upfront cost, it provides a higher ROI through its advanced analytical and reporting capabilities, which justify the extra expenditure.
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.
The return on investment is very good, as I previously mentioned, because the development team has been reduced to half, and it has saved us around one hour per day since we switched to Informatica PowerCenter.
The documentation is thorough, and anyone with minimal knowledge of ETL can easily understand it and work through errors.
I like the technical support provided by Informatica.
I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.
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.
We can easily scale the memory and also the workflows.
The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly.
In the cloud, scaling up and down becomes easy when working with cloud providers.
We are getting 100% uptime every day.
The security is good because we have access level security to give only developer access or only read-only access to the user, ensuring that the workflows cannot be changed.
Informatica PowerCenter is stable and can scale well.
With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.
One limitation I can mention is that sometimes it crashes, and we need to reboot the server to get Informatica PowerCenter running again.
Informatica PowerCenter can be improved by integrating features that allow scheduling a workflow more easily on the main window itself.
There is significant room for improvement, especially with regard to using a hybrid approach that involves both CAS and persistent storage.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
We haven't paid for it; our client had paid for this tool.
From my experience, SAS Data Management is an expensive tool.
Informatica PowerCenter has various features, including a separate workflow monitor which we can use to monitor the tasks, whether they are scheduled or non-scheduled, if they are running or paused, and we can abort them if there is any kind of issue.
The system supports real-time integration, which is essential for many of my tasks.
Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload.
The best features I appreciate about SAS Data Management tool are that it's easy to create the flows and schedule data, and the tables are not too big, making it easy to control the ETL process, including user access which is also easy to manage in SAS.
SAS Data Management stands out because of its data standardization, transformation, and verification capabilities.
| Product | Mindshare (%) |
|---|---|
| Informatica PowerCenter | 3.2% |
| SAS Data Management | 1.3% |
| Other | 95.5% |

| Company Size | Count |
|---|---|
| Small Business | 15 |
| Midsize Enterprise | 11 |
| Large Enterprise | 74 |
| Company Size | Count |
|---|---|
| Small Business | 7 |
| Midsize Enterprise | 1 |
| Large Enterprise | 8 |
Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.
Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.
What are the key features of Informatica PowerCenter?Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.
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.