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
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
Oct 12, 2023
Provides an ease of access and an automated mapping feature
The product’s most valuable feature is ease of access. It allows any CSV files to import data and load it into Salesforce. There is an automatic mapping feature for transformation requirements. It requires minimum time to train any executive to use the tool. They need to watch some live demos, and…
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…

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."
"It is an excellent ETL tool."
"The ability to scale through partitions helped us to improve the performance."
"The setup is straightforward."
"It's a complete package, which is why we use this solution."
"It has very good monitoring and process monitoring."
"Informatica PowerCenter provides multiple transformations in one particular toolset. You don't need to apply any coding."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
 

Cons

"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"The solution does not scale."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"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."
 

Pricing and Cost Advice

"The product is inexpensive and economical."
"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."
"I am not sure about the most recent price, but I think it should be $100,000 or more."
"We are satisfied with the pricing."
"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."
"The price of this solution is high."
"The pricing for Informatica PowerCenter is expensive. Some clients have simple needs and only want to integrate and store data. Some clients have small needs, while some clients have bigger needs and focus more on performance and time. The licensing cost for Informatica PowerCenter isn't good. In my project, if I remember correctly, the company pays €20,000 per year for the Informatica PowerCenter license. I'm not aware of additional costs that you need to pay for some features of the solution. On a scale of one to five, I'm rating its price a three."
"Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
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
19%
Computer Software Company
19%
Manufacturing Company
9%
Educational Organization
8%
Financial Services Firm
18%
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: October 2024.
814,763 professionals have used our research since 2012.