Boomi AtomSphere Integration vs Matillion ETL vs Talend Open Studio comparison

Cancel
You must select at least 2 products to compare!
Boomi Logo
2,246 views|1,564 comparisons
84% willing to recommend
Matillion Logo
3,350 views|2,263 comparisons
95% willing to recommend
Talend Logo
12,831 views|9,729 comparisons
97% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Boomi AtomSphere Integration, Matillion ETL, and Talend Open Studio based on real PeerSpot user reviews.

Find out what your peers are saying about MuleSoft, Microsoft, Oracle and others in Integration Platform as a Service (iPaaS).
To learn more, read our detailed Integration Platform as a Service (iPaaS) Report (Updated: April 2024).
768,924 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
"It's very user-friendly and designed to be easy to use for the end user.""The iPaaS functionality is very mature. The browser based IDE is also very mature and stable.""This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background.""It is a low-code and high-configuration platform, which is very valuable. Develop once and run anywhere is another useful feature. It also has connectors for more than 200 applications. It provides value for money. Our customers who have implemented this solution have a very high ROI.""It has been a stable product.""Low-code development is the most valuable feature.""This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently.""I like the tool's optimization feature."

More Boomi AtomSphere Integration Pros →

"It has improved the costs of managing my customer’s data.""It has helped us to get onto the cloud quickly.""Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.""It's been able to do everything we require.""The product's initial setup phase was easy.""Matillion ETL is one hundred percent stable.""The product has a good user interface.""It has good integrations with Amazon Redshift and other AWS services."

More Matillion ETL Pros →

"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement.""The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily.""We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate.""It has got so many connectors. It is intuitive and easy to use.""The most interesting aspect of the solution for us is that Talend Open Studio has a good balance between the features and the cost of the data management platform.""The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component.""It is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source is very good. They have the same commercials with additional connectors. The graphical design environment is also very easy.""The data integration aspect of the solution is excellent."

More Talend Open Studio Pros →

Cons
"We would like to see more involvement between Dell Boomi and the end-users to help improve the customer experience.""There are very few string handling functions and few mathematical functions are available.""Documentation could be improved.""There should be more scripting possibilities.""Have to create some of our own pre-built connectors.""It is a costly platform. Its pricing could be better.""It crashes if we run high-volume integration.""We encountered stability issues occasionally, one to two times a year."

More Boomi AtomSphere Integration Cons →

"Matillion’s on-premises capabilities don’t allow you to build something customized.""Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves.""I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.""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 cost of the solution is high and could be reduced.""Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more.""In the next release, we would like to have connections to more databases.""Ideally, I would like it to integrate with Secrets Manager as well as the AWS."

More Matillion ETL Cons →

"It gets the job done but it's a bit slow.""The solution should offer better integration with other products.""In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM.""If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface.""It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git.""We don't get continuous replication of the data.""The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it.""The product could be more intuitive."

More Talend Open Studio Cons →

Pricing and Cost Advice
  • "The Platinum package is good for licensing, but I’m not sure about the cost and improvements."
  • "They do not charge by the number of people using the software (client-server model), but rather they charge based on the number of connections used. This makes it very cost effective."
  • "The licensing model of Dell Boomi is based on a ‘pay-per-use’ model."
  • "This solution is very economical (based on the connections)."
  • "The pricing is a bit complex. While the entry fee may be lower than other solutions, it could be expensive depending on your usage."
  • "When it comes to pricing, it's not so much about being less expensive as it is about how they don't tie to the hardware on the underlined VMware that you run on, as other vendors do"
  • "The cost of the solution is in the neighborhood of $20,000 annually. There are no costs above the standard licensing fee."
  • "Approximately 20k annually."
  • More Boomi AtomSphere Integration 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 →

  • "Pricing and licensing are fairly straightforward. It is reasonably priced and managed."
  • "Talend is free and you can download it."
  • "The paid version of this solution has a very high price, but even with the limitations, the Community version works fine."
  • "Price could be lower. It is getting too expensive when compared to some other solutions, which is actually a little bit concerning."
  • "There are many versions available and one is open-sourced which is free."
  • "The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price."
  • "It does the job well for nothing — without cost. That's the advantage of this product."
  • "Talend Open Studio is priced too high."
  • More Talend Open Studio Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.
    768,924 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:I have worked as an Integration Architect/Developer for many years and have used Mulesoft, Boomi, Informatica, Workato… more »
    Top Answer:The tool's most valuable features I've found are related to debugging and testing. It makes it easy to track execution… more »
    Top Answer:Boomi AtomSphere Integration is a relatively cheap and cost-effective product compared to other products like SAP or… more »
    Top Answer:The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
    Top Answer:The pricing depends on what edition the customer opts for. For example, a standard edition and then business critical of… more »
    Top Answer:One of the features that's in development is data privacy in the cloud, along with further SAP integration. For… more »
    Top Answer:We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from… more »
    Top Answer:It is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source… more »
    Top Answer:The product’s pricing is reasonable. It has an annual subscription.
    Ranking
    Views
    2,246
    Comparisons
    1,564
    Reviews
    10
    Average Words per Review
    394
    Rating
    7.4
    4th
    Views
    3,350
    Comparisons
    2,263
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    5th
    out of 100 in Data Integration
    Views
    12,831
    Comparisons
    9,729
    Reviews
    15
    Average Words per Review
    559
    Rating
    7.9
    Comparisons
    Also Known As
    Boomi
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Open Studio
    Learn More
    Overview

    The Boomi AtomSphere integration platform as a service (iPaaS) supports all your application integration processes – between cloud platforms, software-as-a-service applications, and on-premises systems. Your entire team has online access to a powerful range of integration and data management capabilities, that can be realized in a fraction of the time of legacy middleware technologies.

    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.

    Talend Open Studio is a free, open source ETL tool for data integration and Big Data. The solution enables you to extract diverse datasets and normalize and transform them into a consistent format which can be loaded into a number of third-party databases and applications.

    Talend Open Studio Features

    Talend Open Studio has many valuable key features. Some of the most useful ones include:

    • Automatic identification of data types and potential errors
    • tMap module
    • Graphical conversion tools
    • Charts
    • Database SCD Tools
    • Business intelligence formats (Jasper, OLAP, SPSS, Splunk)
    • ETL and ELT support
    • Eclipse-based development tooling
    • Versioning
    • Large library of connectors
    • Data flow orchestration
    • File management without scripting
    • Data transformations

    Talend Open Studio Benefits

    There are several benefits to implementing Talend Open Studio. Some of the biggest advantages the solution offers include:

    • Reduces the time taken to develop the integration.
    • Provides a wide selection of source and target connectors.
    • Monitor and manage problematic deployments with ease.
    • Allows developers to have the lowest cost of ownership for any solution.
    • Improves collaboration between different teams who need access to data.
    • Automated data integration process synchronizes the data and eases real time and periodic reporting, which would be time-consuming if done manually.
    • Achieve better data quality because data matures and improves over time.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Talend Open Studio solution.

    Elio B., Data Integration Specialist/CTO at Asset messages, says, "The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."

    A Practice Head, Analytics at a tech services company mentions, “The data integration aspect of the solution is excellent. The product's data preparation features are very good. There's very useful data stewardship within the product. From a technical standpoint, the solution itself is pretty good. There are very good pre-built connectors in Talend, which is good for many clients or businesses, as, in most cases, companies are dealing with multiple data sources from multiple technologies. That is where a tool like Talend is extremely helpful.”

    Prerna T., Senior System Executive at a tech services company, comments, “The best thing I have found with Talend Open Studio is their major support for the lookups. With Salesforce, when we want to relate our child objects to their parent object, we need to create them via IDs. Then the upsert operation, which will allow you to relate a child object to the event, will have an external ID. That is the best thing which keeps it very sorted. I like that.”

    An Implementation Specialist, Individual Contributor at a computer software company, states, “I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields.” He also adds, “It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.”

    PeerSpot user Badrakh V., Information System Architect at Astvision, explains, "The most valuable features are the ETL tools."

    Sample Customers
    DocuSign Inc., Innotas, Certent, Renesas Electronics America (REA), Kelly-Moore Paints, Mindjet, City of McKinney, Ritchie Bros. Auctioneers (RBA), Daylight Transport, A10 Networks
    Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
    Almerys, BF&M, Findus
    Top Industries
    REVIEWERS
    Computer Software Company15%
    Outsourcing Company8%
    Manufacturing Company8%
    Healthcare Company8%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm8%
    Manufacturing Company8%
    Retailer6%
    REVIEWERS
    Manufacturing Company33%
    Financial Services Firm33%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company8%
    Government8%
    REVIEWERS
    Computer Software Company29%
    Insurance Company12%
    Financial Services Firm12%
    University12%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company7%
    Government6%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise13%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise15%
    Large Enterprise63%
    REVIEWERS
    Small Business22%
    Midsize Enterprise35%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise68%
    REVIEWERS
    Small Business42%
    Midsize Enterprise25%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise15%
    Large Enterprise66%
    Buyer's Guide
    Integration Platform as a Service (iPaaS)
    April 2024
    Find out what your peers are saying about MuleSoft, Microsoft, Oracle and others in Integration Platform as a Service (iPaaS). Updated: April 2024.
    768,924 professionals have used our research since 2012.