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

Dataloader.io vs Informatica PowerCenter comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Dataloader.io
Ranking in Data Integration
41st
Average Rating
8.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Reviews Sentiment
6.5
Number of Reviews
80
Ranking in other categories
Data Visualization (8th)
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Dataloader.io is 0.1%, down from 0.1% compared to the previous year. The mindshare of Informatica PowerCenter is 10.9%, up from 10.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Aditi Bhardwaj - PeerSpot reviewer
Provides an ease of access and an automated mapping feature
We need help with large data migrations. It only works well for a few thousand records or less than a million records. Above that, we need to look for alternative solutions. They could provide automated transformation or mapping features around 10 to 15 independent data objects. We could have a default mark or limit of free usage for standard objects. It will be helpful. Additionally, we can have more integrations with large data volumes as we need a lot of exercises to handle the files in case of complex sites.
Lars Borchers - PeerSpot reviewer
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.

Quotes from Members

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

Pros

"he product’s most valuable feature is ease of access."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"It is UI friendly and has all the advantages of an ETL tool."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"I like the completeness of the way I can build ETL workflows."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Good product if you are trying implement data quality, data integration, and data management projects."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"The product's initial setup phase is very easy."
 

Cons

"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"The UI is a little outdated."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"It should be more cloud-centric than on-prem-centric."
"When I deal with very large amounts of data, there have been performance issues."
"The initial setup is not straightforward. You need expertise to do it."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"Integrating new tools can be tricky and challenging."
 

Pricing and Cost Advice

"The product is inexpensive and economical."
"Our customers pay a licensing fee yearly."
"A basic setup can be from $100,000 and up annually."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"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."
"It's much more expensive, almost three times more expensive than most other solutions."
"Its maintenance is expensive."
"Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support. If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it."
"Cost could be improved."
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.
 

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
19%
Computer Software Company
19%
Manufacturing Company
10%
Educational Organization
8%
Financial Services Firm
19%
Computer Software Company
13%
Manufacturing Company
7%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Dataloader.io?
he product’s most valuable feature is ease of access.
What needs improvement with Dataloader.io?
We need help with large data migrations. It only works well for a few thousand records or less than a million records. Above that, we need to look for alternative solutions. They could provide auto...
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...
 

Also Known As

No data available
PowerCenter
 

Overview

 

Sample Customers

UCSF, Box, CareFusion, Unilever, Hershey's
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: November 2024.
816,406 professionals have used our research since 2012.