Boomi AtomSphere Integration vs Matillion ETL vs Talend Open Studio comparison

Cancel
You must select at least 2 products to compare!
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: March 2024).
765,386 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
"The platform is user-friendly.""It is easy to learn and implement.""Low-code development is the most valuable feature.""The best features are that it is a cloud-based and a multi-tenant tool.""I really appreciate the on-the-go access through the browser and the B2B integration.""The product's integration features are quite rich and low code. It is easy to use.""I like the tool's optimization feature.""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."

More Boomi AtomSphere Integration Pros →

"It is pretty user-friendly, even for people who aren't super technical.""It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth""Matillion ETL is one hundred percent stable.""The most valuable feature of Matillion ETL is its user-friendly graphical interface.""Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.""It has improved the costs of managing my customer’s data.""Matillion ETL has great Git integration that is perfect and convenient to use.""The product has a good user interface."

More Matillion ETL Pros →

"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB.""The best thing I have found with Talend Open Studio is their major support for the lookups.""It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading.""The most valuable features are the ETL tools.""Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement.""This is a user-friendly solution that is easy to use.""A very user friendly solution.""This product is very easy to use."

More Talend Open Studio Pros →

Cons
"The solution is complex. There's a few items and features that are hard to understand. They should work to simplify the functionality so new users don't struggle.""Boomi AtomSphere Integration is not yet exposed to the world as a good product owing to certain shortcomings in the area of marketing where improvements are required.""They need to introduce more configurable functions to remove scripting or coding. Scripting should be minimized. It should have exhaustive functions. Currently, it lacks in this aspect.""In day-to-day operations, tracking transactions is a major challenge. It takes hours to track a single transaction. It is not a straightforward process.""The deployment was simple, but the implementation is missing a lot of capabilities.""There are more mature (dedicated) API management and master data management (MDM) solutions available in the market.""Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc.""The product could be a little bit more user-friendly."

More Boomi AtomSphere Integration Cons →

"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful.""Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more.""The tool's lineage is very weak.""The product must enhance its near-real-time data capture feature.""Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level.""There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features.""In the next release, we would like to have connections to more databases.""The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."

More Matillion ETL Cons →

"In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot.""Talend Open Studio's interface does not provide a good experience...I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio.""I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes.""The price for Talend Data Integration should be less expensive.""It gets the job done but it's a bit slow.""There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources.""It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git.""In the next release, Open Studio should include cloud storage as an input."

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.
    765,386 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:Boomi AtomSphere Integration is a relatively cheap and cost-effective product compared to other products like SAP or… 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… more »
    Top Answer:There's room for improvement in how it handles data streaming capabilities. Our main challenge currently is that… 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:The product's initial setup phase was easy.
    Top Answer:For Talend Open Studio, there is a need to make yearly payments towards the licensing cost. Talend Open Studio is a bit… more »
    Ranking
    Views
    2,323
    Comparisons
    1,631
    Reviews
    10
    Average Words per Review
    394
    Rating
    7.4
    4th
    Views
    3,495
    Comparisons
    2,369
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    5th
    out of 94 in Data Integration
    Views
    13,379
    Comparisons
    10,123
    Reviews
    14
    Average Words per Review
    573
    Rating
    7.8
    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%
    Logistics Company8%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm8%
    Manufacturing Company8%
    Retailer6%
    REVIEWERS
    Manufacturing Company36%
    Financial Services Firm36%
    Healthcare Company9%
    Computer Software Company9%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Government8%
    Manufacturing Company8%
    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 Business23%
    Midsize Enterprise15%
    Large Enterprise62%
    REVIEWERS
    Small Business23%
    Midsize Enterprise36%
    Large Enterprise41%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise68%
    REVIEWERS
    Small Business42%
    Midsize Enterprise25%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise66%
    Buyer's Guide
    Integration Platform as a Service (iPaaS)
    March 2024
    Find out what your peers are saying about MuleSoft, Microsoft, Oracle and others in Integration Platform as a Service (iPaaS). Updated: March 2024.
    765,386 professionals have used our research since 2012.