Alteryx Designer vs Informatica PowerCenter comparison

Alteryx and Informatica are both solutions in the Data Integration category. Alteryx is ranked #12 with an average rating of 7.6, while Informatica is ranked #2 with an average rating of 7.9. Alteryx holds a 2.8% mindshare in DI, compared to Informatica’s 10.3% mindshare. Additionally, 89% of Alteryx users are willing to recommend the solution, compared to 91% of Informatica users who would recommend it.

Alteryx Designer

Read 31 Alteryx Designer reviews

5,287 Views
4,303 Comparison Views

89% willing to recommend

Informatica PowerCenter

Read 80 Informatica PowerCenter reviews

17,150 Views
14,650 Comparison Views

91% willing to recommend

Alteryx Designer

Informatica PowerCenter

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

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.

To learn more, read our detailed Alteryx Designer vs. Informatica PowerCenter Report (Updated: January 2025).

Buyer's Guide

Alteryx Designer vs. Informatica PowerCenter

January 2025

Download the complete report

Helped 838,640 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Alteryx Designer

Ranking in Data Integration

12th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

Informatica PowerCenter

Ranking in Data Integration

2nd

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Visualization (8th)

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Alteryx Designer is 2.8%, down from 3.6% compared to the previous year. The mindshare of Informatica PowerCenter is 10.3%, down from 12.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Ajay Nayak

Senior Data Engineer at Baxter International Inc.

An easy-to-use automation solution with satisfying customer support

Sometimes, while getting data from a third-party product, like data sources that are not present in your system, Alteryx works a bit slowly. Even if you have a good configuration and you are pulling data from an SQL server like SAP, then the solution also has a slow work process. It shouldn't be that much slow if you are pulling ten thousand records, it should not take thirty minutes.

Read full review

Lars Borchers

Senior BI Backend Developer at ALD Automotive Portugal

A stable and reliable product that provides a variety of features for data integration

The solution is not for newcomers. It has an old touch. The solution must improve the integration with new services. It was part of the program at Informatica when they moved to their cloud platform. It is integrated. However, from an on-premise perspective, we need to buy licenses for PowerExchange. If we want a native driver to access a special service, we need to extend our license to those services. It is expensive. I don't like that it's not all included in the solution.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Alteryx Designer is easier to use for machine learning models. However, I am not very good at Python scripts which you will need to make the machine learning scripts."

"I like Alteryx's browser tool because you can view how your data is handled live. There are many other valuable tools like transpose and the crosstab. You can quickly pivot your data, and there are connections throughout the database. It's so easy to create a connection. If you connect to sign apps or a more complex database, the tool contains all the tools you need."

"It has an easy setup process."

"The product is intuitive and easy to use."

"Alteryx Designer is a tool that is pretty much easy to install."

"When you open a raw Excel file, it can be hard to look at everything in detail. Alteryx makes it much easier to go through the data, summarize it, and use different tools for analysis."

"Alteryx Designer's user interface is great, as it is very user-friendly."

"The solution is easy to integrate and user-friendly."

More Alteryx Designer pros

"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."

"The most valuable features are the monitoring tools and the reporting manager."

"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."

"In the end, you have structured, proper data for use in an integrated BI solution."

"Deployment was simple and straightforward."

"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."

"Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors."

"It is an excellent ETL tool."

More Informatica PowerCenter pros

Cons

"The actual usage part of it needs to be explained more. It's too vague right now."

"Based on my experience, the tool could be improved by providing sample reports or pre-configured workflows tailored to specific industries, like finance. It needs to integrate an AI chatbot as well."

"Alteryx Designer's pricing and support could be improved."

"Alteryx Designer is not as fast as SSIS and is not good for large datasets. It also needs to improve database procedures. Though it is easy to use, it is limited in terms of technical aspects."

"It would be simpler if they provided a component where you could simply enter some parameters and see the results."

"We need more documentation."

"The major concern in Alteryx Designer stems from the high costs attached to the product."

"The price of the product is an area with certain shortcomings where improvements are required."

More Alteryx Designer cons

"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."

"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."

"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."

"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."

"Its scalability can be improved. It is not scalable."

"The UI is a little outdated."

"There can be scalability issues. Huge amounts of data ingestion will impact performance."

"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."

More Informatica PowerCenter cons

Pricing and Cost Advice

"The tool is priced high."

"The product is a bit expensive, it should be looked into."

"It is too expensive for our country. We are a small country, so it is too difficult to sell this solution. With Alteryx Designer, if you want to automate the data and run the flows, you have to pay more money. We were trying to automate the flows, and we found out that people have to pay 600 more for this feature, which makes it even more expensive. We are a partner for Tableau, and we are working with Tableau Prep, which is like a mini Alteryx. In Tableau Prep, you can drag and drop and make new connections with the different data sources. You can make all the connections. You can also publish a source. You don't have to pay more money with Tableau. You pay like $5 per user per month to access it."

"Alteryx is a little bit expensive compared to competing solutions."

"Alteryx Designer is an expensive solution."

"I rate the price of Alteryx Designer a ten on a scale of one to ten, where one is low price and ten is high price."

"The solution is expensive. It has license fees, which are renewable every year."

"The licenses are expensive, making it difficult to consider acquiring additional licenses to the existing ones."

More Alteryx Designer pricing and cost advice

"We have a site license, but we do pay by the division."

"Our client has purchased the license, and we are using it."

"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."

"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."

"It's much more expensive, almost three times more expensive than most other solutions."

"The price of Informatica PowerCenter is expensive, but it does give value."

"Informatica PowerCenter is reasonably priced. It is less expensive than Pentaho. There is a standard version fee in Taiwan. It is a one-time yearly subscription price that is approximately $3,010 US dollars for three users."

"Compared to other tools, I think PowerCenter is a bit expensive. When I compare it to Oracle, if you want to use Oracle databases, you can easily get an ODI tool, so it's easier to handle. Informatica is a standalone tool—it's an independent company—and there are no databases around them, so it's quite expensive to use. Generally, large companies use PowerCenter because of the price. If companies want to expand their usage areas, they try to consider if it's easy to implement and easy to understand the pricing. I think the pricing is a barrier for Informatica."

More Informatica PowerCenter pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

838,640 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

Educational Organization

26%

Financial Services Firm

16%

Manufacturing Company

Computer Software Company

Financial Services Firm

18%

Computer Software Company

12%

Manufacturing Company

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Alteryx Designer?

When you open a raw Excel file, it can be hard to look at everything in detail. Alteryx makes it much easier to go through the data, summarize it, and use different tools for analysis.

See all answers

What is your experience regarding pricing and costs for Alteryx Designer?

It's cheaper than Palantir, but even Alteryx is too much for small clients. It is expensive, considering the server capabilities.

See all answers

What needs improvement with Alteryx Designer?

For smaller clients with ten to 15 employees, Alteryx can be expensive. The server capabilities are costly too. The technical support could also improve by being quicker in response times.

See all answers

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

See all answers

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

See all answers

Which Informatica product would you choose - PowerCenter or Cloud Data Integration?

Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...

See all answers

Comparisons

Azure Data Factory vs Alteryx Designer

Compared 34% of the time

SSIS vs Alteryx Designer

Compared 10% of the time

FME vs Alteryx Designer

Compared 9% of the time

SnapLogic vs Alteryx Designer

Compared 6% of the time

SAP Data Services vs Alteryx Designer

Compared 5% of the time

More Alteryx Designer Competitors

SSIS vs Informatica PowerCenter

Compared 16% of the time

Databricks vs Informatica PowerCenter

Compared 14% of the time

Azure Data Factory vs Informatica PowerCenter

Compared 13% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerCenter

Compared 8% of the time

dbt vs Informatica PowerCenter

Compared 1% of the time

More Informatica PowerCenter Competitors

Product Reports

Buyer's Guide

Alteryx Designer

February 2025

Download Alteryx Designer product report

Buyer's Guide

Informatica PowerCenter

February 2025

Download Informatica PowerCenter product report

Also Known As

No data available

PowerCenter

Overview

Information not available

Alteryx

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:

Collaboration: Informatica PowerCenter offers role-based tools and processes which enable business self-service while benefiting from high-quality IT resources.
Automation: Through various automations and easy-to-use software, users can utilize graphical and codeless tools and initiate effective data integration without additional knowledge.
Scalability: The tool provides high scalability to users, which ensures seamless performance and minimum downtime. PowerCenter also has adaptive load balancing, pushdown optimization, and dynamic partitioning.
Monitoring: Through the extensive monitoring feature, the operations and governance of the solution are easily overseen by users. The tool also provides alerts that can prevent damage to the system.
Real-time data: Through real-time data, users can monitor applications and analytics, ensuring their efficient operation.
Prototyping: Informatica lets its users collaborate with information technology to prototype, profile, and validate results in a timely manner.
Connectivity: Users can access and integrate data from different types of sources through high-performance connectors.
Automated data validation testing: The product offers script-free automated and repeatable audit and validation of data.
Data transformation: This feature allows users to use comprehensive parsing of JSON, PDF, XML, Microsoft Office, and the Internet of Things (IoT) for non-relation data.
Cloud applications connectivity: The product allows for seamless connection to cloud application sources and targets.

Informatica PowerCenter Benefits

The benefits of using Informatica PowerCenter include:

The tool can work over a wide range of systems and platforms and also allows for lean integration.
It enhances the quality and speed of performance and optimizes the cost of the process for your organization.
PowerCenter supports multiple databases, including TPump, Parallel Transporter Fastload, and Teradata MLoad.
The tool is very easy to monitor and maintain, which simplifies the data integration process for companies.
The centralized error logging system allows users to locate errors in a timely manner and correct them.
The tool can convert data from an application to another format, as it serves as one of the most powerful data transformation solutions.
PowerCenter can also serve as middleware between two applications.
The solution offers both parallel processing and load balancing.
PowerCenter is a tool with a high level of security, which also minimizes essential administration activities.
The solution ensures the quality of information, as it does not allow invalid or unwanted data to be uploaded to the source.

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.

Informatica

Sample Customers

Information Not Available

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

Buyer's Guide

Alteryx Designer vs. Informatica PowerCenter

January 2025

Free Report: Alteryx Designer vs. Informatica PowerCenter

Find out what your peers are saying about Alteryx Designer vs. Informatica PowerCenter and other solutions. Updated: January 2025.

DOWNLOAD NOW

838,640 professionals have used our research since 2012.

See our Alteryx Designer vs. Informatica PowerCenter report.

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.