IT Central Station is now PeerSpot: Here's why

Informatica PowerCenter vs SnapLogic comparison

Cancel
You must select at least 2 products to compare!
StreamSets Logo
4,932 views|3,637 comparisons
Informatica Logo
33,386 views|28,840 comparisons
SnapLogic Logo
3,714 views|2,798 comparisons
Featured Review
Buyer's Guide
Data Integration Tools
June 2022
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: June 2022.
610,812 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved.""StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes.""It is really easy to set up and the interface is easy to use.""In StreamSets, everything is in one place."

More StreamSets Pros →

"The most valuable features are the metadata repository and the data warehouse application console.""The interface is very clean and clear.""The most valuable features are the monitoring tools and the reporting manager.""Good interface, reasonable documentation.""It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases.""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.""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 very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."

More Informatica PowerCenter Pros →

"The solution is easy to implement and easy to use. It's basically just drag and drop.""They are very good at building out new aspects according to customer requirements.""SnapLogic is a great platform for establishing integrations among various systems or patterns by using any kind of interface. If something is not supported by predefined snaps – snaps are connectors in SnapLogic – you can create them (custom snaps) or write a script.""It's more developer-friendly, and development can be done at a faster phase.""The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution.""The initial setup is very straightforward.""The most valuable feature of SnapLogic is the basic transformation of data. It handles basic and complex transformation of data very well.""SnapLogice is a low-code development tool."

More SnapLogic Pros →

Cons
"If you use JDBC Lookup, for example, it generally takes a long time to process data.""We've seen a couple of cases where it appears to have a memory leak or a similar problem.""Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful.""The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."

More StreamSets Cons →

"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.""Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version.""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.""Support could be better.""There is some room for improvement in terms of pricing.""It should be more cloud-centric than on-prem-centric.""This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources.""Its scalability can be improved. It is not scalable."

More Informatica PowerCenter Cons →

"We'd like there to be more ways for users to get more comfortable and have more experience with the solution to make it easier to use.""The dashboards regarding scheduled tasks need further improvement.""There is room for improvement with APM management and how task execution looks.""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.""The support is the most important improvement they could make.""We'd like zero downtime in the future.""The solution isn't ideal for complex processing or logic. We use another solution for that.""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."

More SnapLogic Cons →

Pricing and Cost Advice
  • "We are running the community version right now, which can be used free of charge."
  • "StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."
  • "It has a CPU core-based licensing, which works for us and is quite good."
  • More StreamSets Pricing and Cost Advice →

  • "It's much more expensive, almost three times more expensive than most other solutions."
  • "We are satisfied with the pricing."
  • "I consider this to be an expensive product."
  • "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."
  • "The price of this solution is high."
  • "Our client has purchased the license, and we are using it."
  • "The solution is in the middle price range compared to other solutions."
  • "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."
  • More Informatica PowerCenter Pricing and Cost Advice →

  • "SnapLogic is not expensive. It's reasonably priced."
  • More SnapLogic Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    610,812 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It is really easy to set up and the interface is easy to use.
    Top Answer:We've seen a couple of cases where it appears to have a memory leak or a similar problem. It grows for a bit and then… more »
    Top Answer:We typically use it to transport our Oracle raw datasets up to Microsoft Azure, and then into SQL databases there.
    Top Answer:Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called… more »
    Top Answer:Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a… more »
    Top Answer:The initial setup is very straightforward.
    Top Answer:The API monitoring could still be improved upon. The dashboards regarding scheduled tasks need further improvement. It's… more »
    Top Answer:It's primarily for cloud-to-cloud application integrations. We are moving the data in Redshift that is from Amazon. Our… more »
    Comparisons
    Also Known As
    PowerCenter
    DataFlow
    Learn More
    Overview

    StreamSets offers an end-to-end data integration platform to build, run, monitor and manage smart data pipelines that deliver continuous data for DataOps, and power the modern data ecosystem and hybrid integration.

    Only StreamSets provides a single design experience for all design patterns for 10x greater developer productivity; smart data pipelines that are resilient to change for 80% less breakages; and a single pane of glass for managing and monitoring all pipelines across hybrid and cloud architectures to eliminate blind spots and control gaps.

    With StreamSets, you can deliver the continuous data that drives the connected enterprise.

    Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

    The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.

    Offer
    Learn more about StreamSets
    Learn more about Informatica PowerCenter
    Learn more about SnapLogic
    Sample Customers
    Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
    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!
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider10%
    Financial Services Firm10%
    Insurance Company10%
    REVIEWERS
    Computer Software Company29%
    Financial Services Firm16%
    Retailer11%
    Healthcare Company5%
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider11%
    Financial Services Firm10%
    Insurance Company7%
    VISITORS READING REVIEWS
    Computer Software Company29%
    Comms Service Provider7%
    Insurance Company7%
    Financial Services Firm7%
    Company Size
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise14%
    Large Enterprise73%
    REVIEWERS
    Small Business19%
    Midsize Enterprise12%
    Large Enterprise69%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise12%
    Large Enterprise74%
    REVIEWERS
    Small Business38%
    Large Enterprise62%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    Buyer's Guide
    Data Integration Tools
    June 2022
    Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: June 2022.
    610,812 professionals have used our research since 2012.

    Informatica PowerCenter is ranked 1st in Data Integration Tools with 31 reviews while SnapLogic is ranked 6th in Integration Platform as a Service (iPaaS) with 9 reviews. Informatica PowerCenter is rated 8.0, while SnapLogic is rated 8.2. The top reviewer of Informatica PowerCenter writes "A stable, scalable, and mature solution for complex transformations and data integration". On the other hand, the top reviewer of SnapLogic writes "Easy to set up, easy to use, and is low-code". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, AWS Glue and Informatica PowerExchange, whereas SnapLogic is most compared with AWS Glue, Matillion ETL, Azure Data Factory, SSIS and TIBCO BusinessWorks.

    We monitor all Data Integration Tools 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.