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

Informatica PowerCenter vs SnapLogic comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 4, 2024
 

Categories and Ranking

Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Number of Reviews
80
Ranking in other categories
Data Visualization (8th)
SnapLogic
Ranking in Data Integration
24th
Average Rating
7.8
Number of Reviews
22
Ranking in other categories
Process Automation (16th), Cloud Data Integration (13th), Integration Platform as a Service (iPaaS) (10th)
 

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…
Selva Dhoom - PeerSpot reviewer
Jun 30, 2022
Automates manual activities and has helpful documentation that allows users to self-study
What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools.

Quotes from Members

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

Pros

"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"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."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"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."
"I like the automated scheduling feature."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"The ability to scale through partitions helped us to improve the performance."
"It is a scalable solution."
"The API architecture makes it easy for orchestration."
"The product is easy to use and has many connectivity options."
"SnapLogic is an IPA tool that leverages a low code environment to connect to multiple sources, extract data, and store it in Azure data lake."
"You can use other languages, such as Python, and easily connect to other systems."
"The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy."
"The vendor handles the maintenance of the solution"
"The connection with SOAP is the best feature."
 

Cons

"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"This product is going to decommission in the next couple of years."
"When I deal with very large amounts of data, there have been performance issues."
"The UI is a little outdated."
"The reputation of Informatica is that it is expensive."
"The documentation could be improved."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"One area for improvement in SnapLogic is the transparency in the flow of data. It needs to have more transparency. Right now, users only have a preview option at the end of any job flow, so at the end of any Snap Pack, there is a data preview option that lets you review the data and see how it's moving. What would make the solution better is more debugging and more access to change data from the preview panel or more functionality in terms of the preview option."
"The biggest issue we have faced in our company with SnapLogic is regarding the EDI format"
"They should expand in terms of features for SaaS-based market requirements in different sectors."
"One of the areas for improvement in SnapLogic is that the connectors for some of the applications should be more available in terms of testing in the dev environment. Another area for improvement is that the logging should be standardized, for example, the integration with an ELK stack should be required out-of-the-box, so you can ship the log and have it in the ELK stack. There should be integration with ELK stack for the log shipping."
"Ultra Pipelines provides real-time ingestion but it needs some adjustment."
"I am looking for more scheduling options. When it comes to scheduling, there are different tools in the market."
"SnapLogic sits somewhere in the middle. It doesn’t offer enough easy canned integrations for its users like some of the easier to use integration apps."
"The solution isn't ideal for complex processing or logic. We use another solution for that."
 

Pricing and Cost Advice

"The price of Informatica PowerCenter is expensive, but it does give value."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"The licensing fees are paid on a yearly basis."
"Our client has purchased the license, and we are using it."
"We are using an annual license for Informatica PowerCenter."
"We are satisfied with the pricing."
"The price is mostly reasonable."
"The solution is in the middle price range compared to other solutions."
"When comparing it with solutions like Apigee or MuleSoft, it still offers better value."
"SnapLogic's price is high compared to the other tools available in the market."
"The pricing is okay."
"They have pricing/usage tiers that are easy to move up or down."
"I used the free trial."
"The license model is based on consumption."
"SnapLogic is not expensive. It's reasonably priced."
"From the ROI perspective, the price is extremely high"
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
814,649 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%
Financial Services Firm
23%
Manufacturing Company
11%
Computer Software Company
10%
Real Estate/Law Firm
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 SnapLogic?
Despite having no prior experience in SnapLogic, we managed to build, test, and prepare it for release in just three hours, handling heavy data efficiently.
What needs improvement with SnapLogic?
The biggest issue we have faced in our company with SnapLogic is regarding the EDI format. For instance, suppose if 20 EDIs are shortlisted then SnapLogic will convert and provide only those specif...
What is your primary use case for SnapLogic?
In our company, we used the solution to build a SnapLogic pipeline in a non-production environment. Presently, our company is releasing it to the production environment. We have used SnapLogic in o...
 

Also Known As

PowerCenter
DataFlow
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Adobe, ADP, BlackBerry, Bonobos, Box, Capital One, Dannon, Eero, Endo, Gensler, HCL, HP, Grovo, HIS, iRobot, Leica, Merck, Sans, Target, Verizon, Vodafone, Yelp, Yahoo!
Find out what your peers are saying about Informatica PowerCenter vs. SnapLogic and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.