Informatica PowerCenter and Alteryx Designer compete in data integration and preparation. While PowerCenter offers robust enterprise solutions, Designer is preferred for its intuitive functionality and ease of use.
Features: Informatica PowerCenter offers vast connectivity options, data governance, and scalability, suitable for large, complex environments. It provides various transformations and debugging tools that are easy to understand, especially for beginners. Alteryx Designer provides a user-friendly drag-and-drop interface, advanced analytics, and seamless data blending capabilities. It includes workflow automation and strong data transformation features, making it suitable for users without technical background.
Room for Improvement: Informatica PowerCenter could enhance its deployment complexity, as it often requires significant IT involvement. Improving ease of use for non-technical users and reducing initial setup time could make it more appealing. Alteryx Designer can improve on handling extremely large datasets and expanding machine learning capabilities. Integrating more advanced analytics tools and improving API connectivity could further enhance its offerings.
Ease of Deployment and Customer Service: Informatica PowerCenter follows a traditional deployment approach, often requiring substantial IT resources. It excels in support for enterprise environments with extensive documentation. Alteryx Designer simplifies deployment with intuitive setup procedures, appealing to a broader demographic beyond IT specialists. Its support emphasizes accessibility, facilitating quicker adoption compared to the complex setup of PowerCenter.
Pricing and ROI: Informatica PowerCenter involves higher initial setup costs typical of enterprise solutions, offering significant ROI through its comprehensive feature set in complex environments. Alteryx Designer provides a cost-effective entry point with rapid deployment, delivering strong ROI due to versatile data manipulation capabilities.
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
There are areas where they need to improve response time and overall competence.
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.
In the cloud, scaling up and down becomes easy when working with cloud providers.
For scalability, I would rate Informatica PowerCenter between eight to nine.
Informatica PowerCenter is stable and can scale well.
The product is very stable with very few issues encountered in production.
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.
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
It's cheaper than Palantir, but even Alteryx is too much for small clients.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
The main valuable aspect is the simplicity of use across all features.
The system supports real-time integration, which is essential for many of my tasks.
The functions in Informatica PowerCenter that I have found most valuable are the way it manages the volume of data, the push down optimization, and the performance aspects of it, mostly related to parallelism techniques.
The most valuable features of Informatica PowerCenter that I have found so far include transformations, the ease of connectivity with different source systems, and the parameter files.
| Product | Market Share (%) |
|---|---|
| Informatica PowerCenter | 3.7% |
| Alteryx Designer | 1.5% |
| Other | 94.8% |
| Company Size | Count |
|---|---|
| Small Business | 12 |
| Midsize Enterprise | 3 |
| Large Enterprise | 17 |
| Company Size | Count |
|---|---|
| Small Business | 15 |
| Midsize Enterprise | 10 |
| Large Enterprise | 72 |
Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of months.
The Advanced edition of the product provides an additional real-time engine which allows companies to have always-on enterprise data integration. This ensures seamless collaboration and increment of data lineage visibility and impacts analysis.
The Premium edition of the solution offers an early warning system that detects unexpected behaviors or incorrect utilization of resources in the workflows and alerts companies in the case that these occur. This version of the product also offers automatic data validation, which ensures data accuracy and reduces testing time and expenditure of resources for by up to 90%.
Informatica PowerCenter Features
The product provides users with various features which allow them to execute data integration initiatives such as analytics, data warehousing, data governance, consolidation, and application migration. The features of the solution include:
Informatica PowerCenter Benefits
The benefits of using Informatica PowerCenter include:
Reviews from Real Users
Yahya T., a developer and architect at L'Oreal, says the product is stable, provides good support, and integrating it with other systems is very fast.
Mohamed E., a senior manager for Data management and data governance at a tech company, says PowerCenter is stable, mature, and offers flexibility in building the pipeline and has a drag-and-drop mode because it's GUI-based; technical support is brilliant.
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.
