Informatica Data Integration Hub vs Matillion ETL comparison

Cancel
You must select at least 2 products to compare!
Informatica Logo
956 views|895 comparisons
100% willing to recommend
Matillion Logo
3,350 views|2,263 comparisons
95% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica Data Integration Hub and Matillion ETL based on real PeerSpot user reviews.

Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration.
To learn more, read our detailed Cloud Data Integration Report (Updated: March 2024).
767,667 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Performance and flexibility-wise, they're very user-friendly.""The technical support services are good.""The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data."

More Informatica Data Integration Hub Pros →

"Matillion ETL has great Git integration that is perfect and convenient to use.""The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources.""The technical support treats us well. They already have a support portal, and they are responsive, which helps.""The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.""The product has a good user interface.""The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool.""The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python.""The loading of data is the most valuable feature of Matillion ETL."

More Matillion ETL Pros →

Cons
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently.""When it comes to UI look and feel and user experience, Informatica is not as good as other solutions.""The initial setup was not very straightforward. Not complex, but not very simple either."

More Informatica Data Integration Hub Cons →

"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.""The tool's lineage is very weak.""When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience.""The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking.""One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.""Ideally, I would like it to integrate with Secrets Manager as well as the AWS.""While the UI is good, it could be improved in its efficiency and made easier to use.""The product must enhance its near-real-time data capture feature."

More Matillion ETL Cons →

Pricing and Cost Advice
  • "Comparatively, their prices are a little bit too high."
  • More Informatica Data Integration Hub Pricing and Cost Advice →

  • "I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."
  • "It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."
  • "The prices needs to be lower."
  • "It was very easy to purchase through the AWS Marketplace, but it was also expensive."
  • "Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."
  • "It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
  • "The AWS pricing and licensing are a cost-effective solution for data integration needs."
  • "It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
  • More Matillion ETL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    767,667 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently.
    Top Answer:Working with a healthcare client with diverse locations, we faced the challenge of analyzing data in isolation, making it difficult to generalize findings across different areas. With the help of… more »
    Top Answer:It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth
    Top Answer:We pay $5.40 per EC2 running hour, and we can reduce costs by stopping and starting the EC2 instances strategically. For instance, in our production environment, we run it for sixteen hours a day… more »
    Top Answer:There's room for improvement in how it handles data streaming capabilities. Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes… more »
    Ranking
    37th
    out of 100 in Data Integration
    Views
    956
    Comparisons
    895
    Reviews
    1
    Average Words per Review
    469
    Rating
    8.0
    4th
    Views
    3,350
    Comparisons
    2,263
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    Comparisons
    Also Known As
    Informatica Integration Hub, Integration Hub
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Learn More
    Overview

    Informatica Data Integration Hub empowers large organizations to embrace change and the opportunities of new applications and analytics systems, while managing storage in Hadoop as well as relational database and file store options. The centralized modern hubbased architecture is the foundation for agile and managed enterprise data integration. As the first to apply a publish/subscribe model to data integration linking big data, cloud, and traditional systems, Informatica delivers productivity and intelligent automation without compromising control.

    Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency. 

    The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

    Sample Customers
    Humana, Rabobank, State of Washington
    Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company10%
    Manufacturing Company10%
    Government9%
    REVIEWERS
    Manufacturing Company33%
    Financial Services Firm33%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Government8%
    Manufacturing Company8%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    REVIEWERS
    Small Business22%
    Midsize Enterprise35%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise68%
    Buyer's Guide
    Cloud Data Integration
    March 2024
    Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration. Updated: March 2024.
    767,667 professionals have used our research since 2012.

    Informatica Data Integration Hub is ranked 37th in Data Integration with 3 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Informatica Data Integration Hub is rated 8.0, while Matillion ETL is rated 8.6. The top reviewer of Informatica Data Integration Hub writes "Excellent at standardizing mass data and capable of integrating with multiple solutions ". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Informatica Data Integration Hub is most compared with Informatica PowerCenter, AWS Database Migration Service, Azure Data Factory, SAP Data Hub and Mule Anypoint Platform, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and SSIS.

    See our list of best Cloud Data Integration vendors.

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