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

Informatica PowerCenter vs Workato comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica PowerCenter
Average Rating
8.0
Number of Reviews
80
Ranking in other categories
Data Integration (2nd), Data Visualization (8th)
Workato
Average Rating
8.4
Number of Reviews
9
Ranking in other categories
Integration Platform as a Service (iPaaS) (9th)
 

Mindshare comparison

Informatica PowerCenter and Workato aren’t in the same category and serve different purposes. Informatica PowerCenter is designed for Data Integration and holds a mindshare of 10.9%, up 10.1% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 4.0% mindshare, down 5.0% since last year.
Data Integration
Integration Platform as a Service (iPaaS)
 

Featured Reviews

Lars Borchers - PeerSpot reviewer
Jul 4, 2023
A stable and reliable product that provides a variety of features for data integration
We use the product for everything that's possible in data integration. We have a data warehouse, and we load each stage. We use the product for data exchange and API services. We also use it to load data into cloud platforms and generate Customer Letters The reliability of the product and the way…
Rohit Sircar - PeerSpot reviewer
Nov 7, 2022
Great automation and strong workflows useful for integration
The initial setup is quite straightforward. When connecting Workato with your on-premises system, you have to install the Workato agent on your network. It was not complex but a long process to configure and settle. Workato has not gone live for us yet, so only the developers are currently using it. But in terms of users, we will have close to 250 and maybe 30 additional direct users. We are seeing a lot of different use cases where we can add new recipes because we started small, and there are many different areas where we can implement Workato for automation.

Quotes from Members

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

Pros

"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"Once you have learned Informatica, it is very easy to use."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"What I like the most is that we have to deal with less while writing the queries."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"It's very easy to use it to develop mappings and workflows."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"Stability-wise, I rate the solution a ten out of ten."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"Workato is low code, intuitive, and easy to use."
"It's easy to understand, makes flows and is efficient."
"It is easier to use than other technical open-source technologies."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
 

Cons

"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"Integration with Artificial Intelligence would benefit this solution."
"The performance of Informatica PowerCenter could improve."
"The solution does not scale."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"The UI is a little outdated."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"It is tedious to make a tailor-fit function."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
"I would like to see the dashboarding and reporting processes improved."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"A limitation is that their cloud presence is only in North America and Europe."
 

Pricing and Cost Advice

"We have a site license, but we do pay by the division."
"I consider this to be an expensive product."
"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."
"We have found the pricing very cost-effective. The licensing is CPU and data source-based."
"The price could be better. It's very expensive. On a scale from one to five, I would give Informatica PowerCenter's price a one."
"The solution is in the middle price range compared to other solutions."
"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."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"On a scale of one to ten, the pricing is around a six. We have a consumption model and the pricing is higher. If you are using any kind of ML-based approach, machine learning, or some advanced analytics, you may have to pay more."
"Workato is an expensive solution."
"Speaking about price, I would say that it's market-related. Also, there are costs in addition to the standard license fees since different add-ons depend on what you require."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
814,763 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
13%
Manufacturing Company
7%
Insurance Company
7%
Educational Organization
41%
Computer Software Company
10%
Financial Services Firm
7%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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...
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...
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 do you like most about Workato?
Workato is low code, intuitive, and easy to use.
What needs improvement with Workato?
Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations. Workato's licensing model is a bit co...
What is your primary use case for Workato?
We use Workato for iPaaS, which is like a middleware enterprise service bus. We use it for transformation, quick data migrations from one platform to another, and building connectivity. It's got ov...
 

Also Known As

PowerCenter
No data available
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Panera Bread, Berkshire Hathaway, Salesforce, Box, Splunk, ComScore, IBM, Complex Media, Microsoft, Home Depot, Cisco, News Corp, Braille Institute
Find out what your peers are saying about Informatica PowerCenter vs. Workato and other solutions. Updated: May 2023.
814,763 professionals have used our research since 2012.