What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
145 Ratings

Alteryx Platform

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
145 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100
74 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Likelihood to Recommend

Alteryx Platform

I wish I had found and used Alteryx Analytics years ago. Having multiple data sources with a variety of naming conventions for our businesses we spent WEEKS cleaning/reorganizing/renaming fields in our data to be able to consolidate. We did this on one set of reports for one use. Each time we wanted an update this process would need to be repeated. This took tons of useless admin time. Had we had Alteryx we could have created 1 identifier, noted all the different naming conventions or issues, selected the ones we wanted and created the workflow to use it over and over and over again on any data we wanted. Build once - use multiple times. It would have been (and now is) a HUGE time saver. Plus any new anomalies are identified by the program as errors so you can "autocorrect" them in the same workflow. Alteryx is a miracle in my opinion.
Susan Knolla profile photo

Informatica PowerCenter

PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).
Jody Gitchel profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Platform
5.3
Informatica PowerCenter
Pixel Perfect reports
Alteryx Platform
5.0
Informatica PowerCenter
Customizable dashboards
Alteryx Platform
5.8
Informatica PowerCenter
Report Formatting Templates
Alteryx Platform
5.0
Informatica PowerCenter

Ad-hoc Reporting

Alteryx Platform
7.6
Informatica PowerCenter
Drill-down analysis
Alteryx Platform
7.1
Informatica PowerCenter
Formatting capabilities
Alteryx Platform
7.5
Informatica PowerCenter
Integration with R or other statistical packages
Alteryx Platform
8.5
Informatica PowerCenter
Report sharing and collaboration
Alteryx Platform
7.5
Informatica PowerCenter

Report Output and Scheduling

Alteryx Platform
7.1
Informatica PowerCenter
Publish to Web
Alteryx Platform
7.6
Informatica PowerCenter
Publish to PDF
Alteryx Platform
6.9
Informatica PowerCenter
Report Versioning
Alteryx Platform
4.0
Informatica PowerCenter
Report Delivery Scheduling
Alteryx Platform
7.9
Informatica PowerCenter
Delivery to Remote Servers
Alteryx Platform
9.0
Informatica PowerCenter

Data Discovery and Visualization

Alteryx Platform
7.1
Informatica PowerCenter
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Platform
6.0
Informatica PowerCenter
Location Analytics / Geographic Visualization
Alteryx Platform
7.5
Informatica PowerCenter
Predictive Analytics
Alteryx Platform
7.9
Informatica PowerCenter

Access Control and Security

Alteryx Platform
8.0
Informatica PowerCenter
Multi-User Support (named login)
Alteryx Platform
8.0
Informatica PowerCenter
Role-Based Security Model
Alteryx Platform
8.0
Informatica PowerCenter
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Platform
8.0
Informatica PowerCenter
Single Sign-On (SSO)
Alteryx Platform
8.0
Informatica PowerCenter

Mobile Capabilities

Alteryx Platform
4.0
Informatica PowerCenter
Responsive Design for Web Access
Alteryx Platform
4.0
Informatica PowerCenter

Data Source Connection

Alteryx Platform
Informatica PowerCenter
8.9
Connect to traditional data sources
Alteryx Platform
Informatica PowerCenter
9.5
Connecto to Big Data and NoSQL
Alteryx Platform
Informatica PowerCenter
8.3

Data Transformations

Alteryx Platform
Informatica PowerCenter
8.7
Simple transformations
Alteryx Platform
Informatica PowerCenter
8.7
Complex transformations
Alteryx Platform
Informatica PowerCenter
8.6

Data Modeling

Alteryx Platform
Informatica PowerCenter
8.2
Data model creation
Alteryx Platform
Informatica PowerCenter
7.4
Metadata management
Alteryx Platform
Informatica PowerCenter
8.9
Business rules and workflow
Alteryx Platform
Informatica PowerCenter
8.4
Collaboration
Alteryx Platform
Informatica PowerCenter
8.7
Testing and debugging
Alteryx Platform
Informatica PowerCenter
7.8

Data Governance

Alteryx Platform
Informatica PowerCenter
8.1
Integration with data quality tools
Alteryx Platform
Informatica PowerCenter
8.1
Integration with MDM tools
Alteryx Platform
Informatica PowerCenter
8.0

Pros

Alteryx Platform

  • Alteryx does a great job of allowing more beginner Analysts to automate many of their routine process but also allowing advanced Analysts to ability to leverage deep statistical modelling for predictive analytics.
  • Given the visual workflow nature of Alteyrx, the learning curve is not steep.
  • The Alteryx Gallery allows non-technical consumers to execute complex workflows by leveraging an intuitive web interface.
  • Alteryx allows data scientists to bring their own programming language to Altyerx, such as R or Python.
No photo available

Informatica PowerCenter

  • Informatica has a wide range of support for databases. Pretty much every mainstream DBMS is compatible here.
  • Designing ETL mappings and workflows is a very intuitive process, and takes minimal learning time and effort even for a beginner.
  • Informatica's biggest strength is its sheer performance. It is unmatched in terms of handling large volumes of data.
No photo available

Cons

Alteryx Platform

  • Sometimes the desktop version of authoring tool crashes! It's been unstable in the previous versions but gets better. Even if it doesn't crash, it used to be slow or not responding.
  • When running several version of database drivers in local machine or server, it is tricky to set up database connections. Often you have to figure out it by googling the problem and solution. There are not many knowledge bases from Alteryx.
  • Alteryx project file creates .bak file automatically. It is useful to prevent for the purpose of back up, sometimes it's not necessary. But it is not changeable for some reason. By default, it always creates backups.
No photo available

Informatica PowerCenter

  • One of the challenges of PowerCenter is the lack of integration between the components and functionality provided by PowerCenter. PowerCenter consists of multiple components such has the repository service, integration service, metadata service. Considerable time and resources were required to install and configure these components before PowerCenter was available for use.
  • In order to connect to various data sources such as Netezza database or SAS datasets, PowerCenter requires the installation and configuration of separate plug-ins. We spent considerable time trouble-shooting and debugging problems while trying to get the various plug-ins integrated with PowerCenter and get them up and running as described in the documentation.
  • PowerCenter works well with structured data. That is, it is easy to work with input and output data that is pre-defined, fixed, and unchanging. It is much more difficult to work with dynamic data in which new fields are added or removed ad-hoc or if data format changes during the data ingest process. We have not been as successful in using PowerCenter for dynamic data.
  • One of the challenges of learning PowerCenter is that it is difficult to find documentation or publications that help you learn the various details about PowerCenter software. Unlike SAS Institute, Informatica does not publish books about PowerCenter. The documentation available with PowerCenter is sparse; we have learned many aspects of this technology through trial and error.
No photo available

Likelihood to Renew

Alteryx Platform

Alteryx Platform 6.5
Based on 14 answers
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
Mark Frisch profile photo

Informatica PowerCenter

Informatica PowerCenter 10.0
Based on 4 answers
Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
Robert Goodman profile photo

Usability

Alteryx Platform

Alteryx Platform 10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Nick Lensing profile photo

Informatica PowerCenter

Informatica PowerCenter 9.5
Based on 2 answers
Positives;- Multi User Development Environment- Speed of transformation- Seamless integration between other Informatica products.Negatives;- There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center.- Oracle Analytical functions should be natively used.- E-LT support as well as ETL support.
Gurcan Orhan profile photo

Reliability and Availability

Alteryx Platform

Alteryx Platform 10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman profile photo

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Performance

Alteryx Platform

No score
No answers yet
No answers on this topic

Informatica PowerCenter

Informatica PowerCenter 9.5
Based on 2 answers
PowerCenter is robust and fast, and it does a great job meeting all the needs, not just the most commercially vocal needs. In the hands of an expert power user, you can accomplish almost anything with your data. It is not for new users or intermittent users-- for that the Cloud version is a better fit. Be prepared for costly connectors (priced differently for each source or destination you are working with), and just be planful of your projects so you are not paying for connectors you no longer need or want
No photo available

Support

Alteryx Platform

Alteryx Platform 9.9
Based on 2 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Nick Lensing profile photo

Informatica PowerCenter

Informatica PowerCenter 8.0
Based on 1 answer
Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
No photo available

Implementation

Alteryx Platform

Alteryx Platform 10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman profile photo

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Alternatives Considered

Alteryx Platform

Talend is primarily for data integration and has quite advanced capabilities. But the user has to be more technical. Alteryx makes the process simple and any user can make use of its features.Tableau was a good choice for data visualization. We needed beautiful charts and ways to represent data. Alteryx falls short in this aspect.
Sanket Bharaswadkar profile photo

Informatica PowerCenter

PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar capabilities, but lack the range and depth when compared with the PowerCenter platform.
Brian Randolph profile photo

Return on Investment

Alteryx Platform

  • Alteryx does an excellent job of integrating consumer and spatial data to calculate and visualize things like locations within a certain drive-time radius.
  • For visualization purposes I had to move the data to excel for some decent graphs.
  • It can become very expensive.
No photo available

Informatica PowerCenter

  • Positive - Easy to maintain processes built in Informatica Power Center.
  • Positive - Rapidly build and deploy ETL data mappings.
  • Positive - Develop the overall workflow process to run all ETL processes for the project.
  • Negative - Informatica Power Center can be a bit expensive, so your application needs to warrant the enterprise support.
No photo available

Pricing Details

Alteryx Platform

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Alteryx Platform Editions & Modules

On-premise Edition
Alteryx Designer$3,9951
Alteryx Designer with Spatial$12,9951
Alteryx Designer with Data$29,9951
Alteryx Server$45,0002
  1. per user, per year
  2. per server, per year
SaaS Edition
Alteryx Analytics Gallery$1,5001
  1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

Informatica PowerCenter

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Informatica PowerCenter Editions & Modules

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Alteryx Platform
8.5
Informatica PowerCenter
8.6

Likelihood to Renew

Alteryx Platform
6.5
Informatica PowerCenter
10.0

Usability

Alteryx Platform
10.0
Informatica PowerCenter
9.5

Reliability and Availability

Alteryx Platform
10.0
Informatica PowerCenter

Performance

Alteryx Platform
Informatica PowerCenter
9.5

Support

Alteryx Platform
9.9
Informatica PowerCenter
8.0

Implementation

Alteryx Platform
10.0
Informatica PowerCenter

Add comparison