

Informatica PowerCenter and SAS Visual Analytics are leading contenders in the data management and analytics sector. Informatica PowerCenter appears to have an edge due to its advanced data integration and stability as per various reviews.
Features: Informatica PowerCenter stands out with features such as the Mapping Analyst for Excel, robust data transformation capabilities, and scalable architecture. SAS Visual Analytics is noted for its user-friendly interface, advanced data visualization features, and seamless integration with other SAS tools.
Room for Improvement: Informatica PowerCenter users call for better cloud capabilities, a more modern interface design, and simplified integration processes with cloud applications. Licensing costs remain a high concern. SAS Visual Analytics could enhance performance, include richer statistical functions, and improve integration with external applications.
Ease of Deployment and Customer Service: Informatica PowerCenter primarily supports on-premises deployment with some hybrid and private cloud options. Technical support is generally rated highly though it can vary by location. SAS Visual Analytics provides mixed deployment options, yet user reviews mention a need for better service flexibility and support for integration.
Pricing and ROI: Informatica PowerCenter has a high pricing model but is often justified by significant ROI driven by its advanced capabilities and system robustness. SAS Visual Analytics is acknowledged for its analytical power, yet its premium pricing model, requiring additional purchases for full functionality, can deter smaller companies despite its potential benefits.
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 enterprise subscription offers more benefits, ensuring valuable outcomes.
I have seen a return on investment with SAS Visual Analytics, as it includes AI capabilities and automatic functions with scheduling, allowing reports to be made from live data, which contributes to a new vertical for revenue generation.
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.
They provide callbacks to ensure clarity and resolution of any queries.
They assist us when we encounter issues and provide help while we complete tasks.
In the cloud, scaling up and down becomes easy when working with cloud providers.
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.
We can easily scale the memory and also the workflows.
SAS Visual Analytics scalability is very good and positive.
We are getting 100% uptime every day.
Informatica PowerCenter is stable and can scale well.
The product is very stable with very few issues encountered in production.
SAS Visual Analytics is stable and manages data effectively without crashing.
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.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
Training on SAS Visual Analytics is required to help overcome these issues.
In terms of configuration, I would like to see AI capabilities since many applications are now integrating AI.
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.
The system supports real-time integration, which is essential for many of my tasks.
Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.
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.
After implementing SAS Visual Analytics, we have generated a new way to generate revenue by providing live data visuals to our clients and making our team aware of data in real time, which has had a significant positive impact.
The ability to query information from our Excel data into SAS to view specific data is invaluable.
| Product | Mindshare (%) |
|---|---|
| Informatica PowerCenter | 1.2% |
| SAS Visual Analytics | 1.7% |
| Other | 97.1% |


| Company Size | Count |
|---|---|
| Small Business | 14 |
| Midsize Enterprise | 11 |
| Large Enterprise | 76 |
| Company Size | Count |
|---|---|
| Small Business | 13 |
| Midsize Enterprise | 10 |
| Large Enterprise | 19 |
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 Visual Analytics offers rapid data processing and advanced forecasting with interactive reporting and visualization. It integrates with diverse data sources, enhancing scalability and automation, enabling data-driven decisions and extensive insight generation.
SAS Visual Analytics provides comprehensive data handling through its advanced reporting and visualization features. Businesses benefit from its ability to process data quickly and deliver insights via interactive dashboards and well-structured reports. Although it faces performance challenges with large datasets and has a complex installation process, it supports both cloud and on-premises deployments. Users can leverage its capabilities in data extraction, transformation, and loading, making it a valuable tool for finance, statistical analysis, and enterprise reporting. Despite some gaps in machine learning and integration with newer data stores, its scalability and flexibility in data management remain key advantages.
What are the most significant features of SAS Visual Analytics?SAS Visual Analytics is implemented across sectors such as insurance and education for tasks like building dashboards and performing business intelligence. It is extensively used in finance and statistical analysis, turning complex data sets into actionable insights, supporting both cloud and on-premises environments.
We monitor all Data Visualization 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.