We performed a comparison between Alteryx Designer and Informatica PowerCenter based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The product is intuitive and easy to use."
"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."
"It has great UI."
"Alteryx Designer is stable."
"It has an easy setup process."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"The features I found most valuable are the preparation features – the Join and the Transform."
"The most valuable features are the integrated properties and integrated connectivity."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"PowerCenter performs well during data transformation and optimization."
"I found the map links, work links, and workflows valuable. They are important features."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"It is an excellent ETL tool."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"The setup is very simple."
"Good interface, reasonable documentation."
"Its price can be improved. It is too expensive for our country. Because of its high price, we can't sell Alteryx Designer in this region. We used to be their reseller partner. There is also an additional cost for automating the data and running the flows, which makes it even more expensive. It will be very good if they can let users automate the data for free. Other solutions like Tableau provide this feature for free."
"If the price were reduced then it would be more competitive."
"Alteryx's data science and machine learning capabilities are where it loses out to DataIQ."
"It would be simpler if they provided a component where you could simply enter some parameters and see the results."
"Alteryx Designer overall should be easier to use."
"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."
"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."
"Alteryx Designer's pricing and support could be improved."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"The documentation could be improved."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
Alteryx Designer is ranked 9th in Data Integration with 26 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Alteryx Designer is rated 8.0, while Informatica PowerCenter is rated 8.0. The top reviewer of Alteryx Designer writes "An easy-to-use automation solution with satisfying customer support". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". Alteryx Designer is most compared with Azure Data Factory, FME, SSIS, Palantir Foundry and SAP Data Services, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Matillion ETL. 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.