Jitterbit Harmony vs Matillion ETL vs Talend Open Studio comparison

Cancel
You must select at least 2 products to compare!
Jitterbit Logo
661 views|555 comparisons
100% 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 Jitterbit Harmony , Matillion ETL, and Talend Open Studio based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration.
To learn more, read our detailed Data Integration Report (Updated: April 2024).
768,857 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
"Easy integration with Salesforce""It runs like an appliance and has tremendous throughput.""The fluid user interface (probably the most user friendly interface, when compared to its competitors).""Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried.""It is a scalable solution.""We only use small parts of the solution, however, the parts that we use are quite adequate.""The Cloud Console for monitoring and troubleshooting data operations.""Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."

More Jitterbit Harmony Pros →

"It has improved the costs of managing my customer’s data.""It is pretty user-friendly, even for people who aren't super technical.""It has helped us to get onto the cloud quickly.""The product's initial setup phase was easy.""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.""We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL).""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."

More Matillion ETL Pros →

"The rapidity of integration with data may be one of the valuable features.""The solution's technical support is responsive and helpful.""The drag-and-drop feature in the interface is very good.""The standout feature for me is the user-friendly nature of the components.""Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good.""The initial setup of the product was very easy.""We're able to handle large amounts of data with ease.""This solution has improved our overall time to value for data ingestion."

More Talend Open Studio Pros →

Cons
"The initial setup can be a little bit difficult.""There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data.""I would like the ability to offer a dedicated cloud version for security.""Sometimes additional connectors are needed.""You need to have some development skills or hire a Jitterbit engineer to make changes.""Sometimes we experience disconnections and I have to close all Jitterbit programs.""Its API management capabilities need improvement.""In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."

More Jitterbit Harmony Cons →

"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.""To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful.""It needs integration with more data sources.""Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.""The cost of the solution is high and could be reduced.""The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine.""In the next release, we would like to have connections to more databases.""Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."

More Matillion ETL Cons →

"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 stability of the solution could improve when running jobs. There can be errors when running projects but in the end, it works well and the errors do not impact the result.""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.""It is not as visually appealing as some of the other tools.""The price for Talend Data Integration should be less expensive.""The server-side should be completely revamped.""The pricing could be lower. They should work to make it more affordable.""The security features could be improved."

More Talend Open Studio Cons →

Pricing and Cost Advice
  • "Each business needs to determine if it is a mission critical aspect."
  • "The added bonus is that Jitterbit doesn't charge for any data volume/traffic."
  • "I do believe Jitterbit has one of the better pricing and licensing options out there compared to its competitors."
  • "Jitterbit was extremely cost effective for us compared to other options."
  • "The Jitterbit price is based upon endpoints. They also offer ERP connectors with their Enterprise edition"
  • "The solution's cost is mid-ranged compared to other vendors."
  • More Jitterbit Harmony 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 Data Integration solutions are best for your needs.
    768,857 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The solution's cost is mid-ranged compared to other vendors. I rate its pricing a six out of ten.
    Top Answer:The solution's API management capabilities need improvement.
    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
    35th
    out of 100 in Data Integration
    Views
    661
    Comparisons
    555
    Reviews
    1
    Average Words per Review
    234
    Rating
    9.0
    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
    Jitterbit, Jitterbit Harmony
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Open Studio
    Learn More
    Overview

    Open source integration platform designed to handle the most complex integration challenges between legacy, enterprise and On-Demand applications. 

    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
    LA Metro, Mophie, Club Auto, University of Miami, Exostar, Dialog Direct, Avero, Greenpoint Technologies, Berklee Online, Odyssey, KeyedIn Solutions, Swish Maintenance, SPP Pumps Limited, Talent Plus, Ricoh Canada, Televerde, Reed Construction Data, Sika US, Sunkist Growers
    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
    VISITORS READING REVIEWS
    Computer Software Company17%
    Healthcare Company10%
    Financial Services Firm9%
    Manufacturing Company7%
    REVIEWERS
    Manufacturing Company33%
    Financial Services Firm33%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Government8%
    Manufacturing Company8%
    REVIEWERS
    Computer Software Company29%
    University12%
    Financial Services Firm12%
    Insurance Company12%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company7%
    Government6%
    Company Size
    REVIEWERS
    Small Business67%
    Midsize Enterprise25%
    Large Enterprise8%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise16%
    Large Enterprise57%
    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
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    768,857 professionals have used our research since 2012.