Try our new research platform with insights from 80,000+ expert users

Alteryx Designer vs Informatica Intelligent Data Management Cloud (IDMC) comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Alteryx Designer
Ranking in Data Integration
11th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
30
Ranking in other categories
No ranking in other categories
Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
181
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), API Management (7th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (4th), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Featured Reviews

Ajay Nayak - PeerSpot reviewer
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.
Raj Sethupathi - PeerSpot reviewer
Offers profiling and address standardization but can be complicated
Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.

Quotes from Members

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

Pros

"The solution is user-friendly."
"I believe in the ability to connect to multiple data sources, as well as the ease of use to transform data and output data in a variety of formats."
"Alteryx Designer's user interface is great, as it is very user-friendly."
"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."
"Alteryx Designer is a tool that is pretty much easy to install."
"Alteryx Designer offers a drag-and-drop interface, making it highly user-friendly. Unlike Python and Apache Airflow, which require coding, Alteryx allows users to accomplish tasks without any programming knowledge. Its simplicity makes it accessible to anyone, even those without coding experience, and this ease of use is one of Alteryx's key advantages."
"One of the things I like about Alteryx Designer is how easy it is to connect numerous data inputs, including API connectors. This helps tremendously in reducing the time required to extract data from systems like SAP that don't have straightforward connectivity options."
"The most valuable feature of Alteryx Designer is its ability to select all the inputs and formulas."
"Address Doctor gives an accurate combination of information provided with a level of returned threshold value."
"There are a couple of valuable features. One is that it is very quick on the profiling. So, you get a very fast snapshot of the type of data that you're looking at from the profiling perspective. It can highlight anomalies in the data."
"It comes with lot of features and is a one-stop-shop solution for integration, data modeling, and data governance. Everything can be built under one particular umbrella. If any issues come up, then there won't be any blame game saying that it could be an integration issue or an MDM hub issue because it's wholly owned by Informatica. That's the biggest advantage of Informatica MDM over that of any other tools that are available on the market."
"This is where I think MDM shines - with its strong fuzzy matching algorithm. This is the essence of Informatica MDM. Based on these results, I can write our match conditions and then perform the corresponding data management activities."
"The solution's initial setup is quite straightforward."
"Informatica MDM stands out as a tool that can give you the flexibility needed for doing channel-specific data quality or business validation."
"The advanced features like task flow and conditional integration are particularly useful."
"Axon has a marketplace that allows you to showcase all the assets the data owner has, so they can request access. That's one feature we use extensively. Axon also offers great visibility and intuitive searchability, allowing you to easily search data assets. You can check the lineage and see the work EDC does. EDC handles all the classification, cataloging, and lineage. It's integrated with Axon, and anyone can see that."
 

Cons

"An improvement for Alteryx Designer would be faster bug fixes and updates."
"Alteryx Designer's cost should be improved."
"The price of the product is an area with certain shortcomings where improvements are required."
"If the price were reduced then it would be more competitive."
"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."
"When it comes to the pivoting part, the drill-through option is not there in Alteryx."
"Alteryx needs to improve its web governance. The gallery you use to filter the data is something else that could use some work. For instance, if you have a report connected to a database and want to filter a specific user, you should be able to suggest a specific region or a particular year. I know that the Alteryx isn't designed for data governance, but that would be great to think about."
"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."
"Informatica Axon's response times and certain aspects of the admin panel could be enhanced for better usability."
"The tools required to migrate existing mappings and server rules through cloud data quality are not available."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"We would like to have accessibility to the repository."
"There's certainly room for improvement. One crucial area is generating detailed reports on file statuses. Presently, this is represented visually, often as graphs or charts. Such reporting could offer comprehensive insights into the areas that demand attention and further scrutiny."
"The GUI needs to be a little more user-friendly and appealing."
"It is complicated to establish the lineage in EDC using PowerCenter mappings."
"They need more feature flexibility, as it is not fully developed."
 

Pricing and Cost Advice

"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."
"The pricing is bit expensive."
"I rate the price of Alteryx Designer as a five on a scale of one to ten, where one is extremely expensive, and ten is a highly cheap product."
"Each license is something like $4,000."
"I rate Alteryx Designer a six out of ten for pricing."
"Alteryx Designer is a very expensive solution."
"The licenses are expensive, making it difficult to consider acquiring additional licenses to the existing ones."
"So, there are plans for licensing. There are subscription-based and usage-based licenses. Also, there are licenses for exceptional analytics, etc. In short, there are different models of licensing for every enterprise."
"I rate the product's price a seven on a scale of one to ten, where one is the cheapest and ten is the most expensive. The product is a bit expensive."
"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."
"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."
"Informatica MDM's pricetag should come down. They have to cut some costs."
"The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives."
"Informatica Axon is expensive."
"We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
24%
Financial Services Firm
16%
Manufacturing Company
8%
Computer Software Company
6%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
 

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.
What is your experience regarding pricing and costs for Alteryx Designer?
The solution is expensive. It has license fees, which are renewable every year.
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.
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
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...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
 

Also Known As

No data available
ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
 

Overview

Information not available
 

Sample Customers

Information Not Available
The Travel Company, Carbonite
Find out what your peers are saying about Alteryx Designer vs. Informatica Intelligent Data Management Cloud (IDMC) and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.