Alteryx Designer vs Informatica PowerCenter comparison

Alteryx and Informatica are both solutions in the Data Integration category. Alteryx is ranked #11 with an average rating of 7.6, while Informatica is ranked #2 with an average rating of 8.0. Alteryx holds a 3.2% mindshare in DI, compared to Informatica’s 11.0% 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 30 Alteryx Designer reviews

5,863 Views
4,848 Comparison Views

89% willing to recommend

Informatica PowerCenter

Read 80 Informatica PowerCenter reviews

19,173 Views
16,406 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: December 2024).

Buyer's Guide

Alteryx Designer vs. Informatica PowerCenter

December 2024

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

Alteryx Designer

Ranking in Data Integration

11th

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 December 2024, in the Data Integration category, the mindshare of Alteryx Designer is 3.2%, down from 4.3% compared to the previous year. The mindshare of Informatica PowerCenter is 11.0%, up from 10.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 stable."

"The tool's most valuable feature is its API connections. Its predictive analytics feature has helped us pass some ETL processes to analysts rather than developers."

"The product is intuitive and easy to use."

"It has great UI."

"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."

"The product is very stable. The performance is reliable."

"It helps them to create customized workflows, transform data, perform calculations, and consolidate multiple data sources into a target database."

"I have been using Alteryx Designer only for data modeling and data structuring."

More Alteryx Designer pros

"It has good standard features for ETL development."

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

"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."

"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."

"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."

"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."

"We have found the PowerCenter and B2B data transformation most valuable."

"It's a complete package, which is why we use this solution."

More Informatica PowerCenter pros

Cons

"Improving the key-based sign-on process and making it more user-friendly would be a benefit."

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

"When it comes to the pivoting part, the drill-through option is not there in Alteryx."

"When configuring the Logix, the UA could be improved."

"We discontinued using Alteryx's data science studio because it was not very user-friendly."

"Optimizing processing times is one area I would like to see improved in Alteryx Designer. Sometimes, the workflows take an extremely long time to run. There are days when I have had to wait two to three hours for a single process to complete. There needs to be a functionality to split the processes."

"It is challenging to view the data using Alteryx Designer."

"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."

More Alteryx Designer cons

"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."

"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."

"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."

"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."

"The solution could have better documentation on basic steps or blocks that specify what to do."

"Support could be better."

"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."

"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."

More Informatica PowerCenter cons

Pricing and Cost Advice

"The tool is priced high."

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

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

"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 product is a bit expensive, it should be looked into."

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

"Alteryx Designer is an expensive solution."

"I rate Alteryx Designer a six out of ten for pricing."

More Alteryx Designer pricing and cost advice

"The price is mostly reasonable."

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

"According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."

"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."

"A basic setup can be from $100,000 and up annually."

"I am not sure about the most recent price, but I think it should be $100,000 or more."

"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."

"Its maintenance is expensive."

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

824,053 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

24%

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?

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

See all answers

What needs improvement with Alteryx Designer?

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.

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 33% 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 7% 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

Azure Data Factory vs Informatica PowerCenter

Compared 14% of the time

Databricks vs Informatica PowerCenter

Compared 13% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerCenter

Compared 9% of the time

WhereScape RED vs Informatica PowerCenter

Compared 1% of the time

More Informatica PowerCenter Competitors

Product Reports

Buyer's Guide

Alteryx Designer

December 2024

Download Alteryx Designer product report

Buyer's Guide

Informatica PowerCenter

December 2024

Download Informatica PowerCenter product report

Also Known As

No data available

PowerCenter

Learn More

Alteryx

Informatica

Overview

Information not available

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.

Sample Customers

Information Not Available

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

Buyer's Guide

Alteryx Designer vs. Informatica PowerCenter

December 2024

Free Report: Alteryx Designer vs. Informatica PowerCenter

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

DOWNLOAD NOW

824,053 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.