Microsoft Data Quality Services vs Talend Data Quality comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
177 views|82 comparisons
100% willing to recommend
Talend Logo
1,486 views|696 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Data Quality Services and Talend Data Quality based on real PeerSpot user reviews.

Find out what your peers are saying about Informatica, SAP, Talend and others in Data Quality.
To learn more, read our detailed Data Quality Report (Updated: April 2024).
770,428 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
"This solution is particularly useful for data enrichment."

More Microsoft Data Quality Services Pros →

"The numerous components provided by Talend mean you’re able to create jobs quickly and efficiently.""The Studio is easy to understand.""The file fetch process is impeccable.""The most valuable feature lies in the capability to assign data quality issues to different stakeholders, facilitating the tracking and resolution of defective work.""It is saving a lot of time. Today, we can mask around a hundred million records in 10 minutes. Masking is one of the key pieces that is used heavily by the business and IT folks. Normally in the software development life cycle, before you project anything into the production environment, you have to test it in the test environment to make sure that when the data goes into production, it works, but these are all production files. For example, we acquired a new company or a new state for which we're going to do the entire back office, which is related to claims processing, payments, and member enrollment every year. If you get the production data and process it again, it becomes a compliance issue. Therefore, for any migrations that are happening, we have developed a new capability called pattern masking. This feature looks at those files, masks that information, and processes it through the system. With this, there is no PHI and PII element, and there is data integrity across different systems. It has seamless integration with different databases. It has components using which you can easily integrate with different databases on the cloud or on-premise. It is a drag and drop kind of tool. Instead of writing a lot of Java code or SQL queries, you can just drag and drop things. It is all very pictorial. It easily tells you where the job is failing. So, you can just go quickly and figure out why it is happening and then fix it.""It has definitely streamlined certain processes.​""I like idea of storing the results of Data Quality jobs in a DB and having the ability to run reports in the DB to show a dashboard of quality metrics.""​It lowers the amount of time in development from weeks to a day.​"

More Talend Data Quality Pros →

Cons
"I would rate my experience with the initial setup a six out of ten, with one being very easy and ten being extremely challenging. So, there is room for improvement in the setup process."

More Microsoft Data Quality Services Cons →

"In terms of the solution's technical support, the interactions were satisfactory, but there is room for improvement, especially in managing expectations.""Heap space issues plague us consistently. We maxed it out and it runs fine, then it doesn’t, then it does.""In redundancy analysis, the query is failing to bring non-matched records. This query is an internal script. There is no way (that I know of) to fix this syntax error for future runs.""They don't have any AI capabilities. Talend DQ is specifically for data quality, which only has data profiling. With Talend DQ, I cannot generate any reports today, so I need an ETL tool. It provides general Excel files, or I have to create some views. If instead of buying a new tool, Talend provides a reporting capability or solution, it would be great. It will reduce the development effort for creating these kinds of reports. We also manage the infrastructure for Talend. From the licensing perspective, for cloud, they only have seat licenses where one person is tied to one license, but for on-premise, they have concurrent licenses. It would be really awesome if they can provide concurrent licenses for the cloud so that if one person is not there, somebody else can use that license. Currently, it is not possible unless a person deactivates his or her license and moves the same seat license to someone else. We are one of the biggest customers in the central zone of the US for Talend, and this is the feedback that we have provided them again and again, but they come back and say that they aren't able to provide concurrent licenses on the cloud. In version 7.3, there is a feature for tokenization and de-tokenization of data. This is the feature that we are looking for. It is useful if somebody wants to see what we have masked and how do we demask it. This feature is not there in version 7.1. There are also a few other capabilities on the cloud, but we don't yet have a big footprint in the cloud.""Finding assistance with issues can be spotty. With Python, there are literally millions of open source answers which are recent and apply to the version that we are using.""It would be more helpful if it offered dynamic dashboards that could be directly used by clients for better analysis.""If the SQL input controls could dynamically determine the schema-based on the SQL alone, it would simplify the steps of having to use a manually created and saved schema for use in the TMap for the Postgres and Redshift components. This would make things even easier.""You can't join more than two tables for analysis."

More Talend Data Quality Cons →

Pricing and Cost Advice
  • "The pricing is in the midrange. It's not cheap, but it depends on the licenses you require."
  • More Microsoft Data Quality Services Pricing and Cost Advice →

  • "I would advise to first take a look and at the Open Studio edition. Figure out what you need and purchase the appropriate license."
  • "We did not purchase a separate license for DQ. It is part of our data platform suite, and I believe it is well-priced."
  • "It's a subscription-based platform, we renew it every year."
  • "It is cheaper than Informatica. Talend Data Quality costs somewhere between $10,000 to $12,000 per year for a seat license. It would cost around $20,000 per year for a concurrent license. It is the same for the whole big data solution, which comes with Talend DI, Talend DQ, and TDM."
  • "Moreover, the pricing structure stands out as highly competitive compared to other offerings in the market, making it a cost-effective choice for users."
  • More Talend Data Quality Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
    770,428 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:This solution is particularly useful for data enrichment.
    Top Answer:The pricing is in the midrange. It's not cheap, but it depends on the licenses you require. We are an enterprise partner and have an enterprise agreement, so we may not see it as a separate cost.
    Top Answer:It's actually typical of Microsoft products. It's not overly easy, but at the same time, it's not like trying to fix a pipe that's burst. You do need to configure a few things to tackle some issues… more »
    Top Answer:The most valuable feature lies in the capability to assign data quality issues to different stakeholders, facilitating the tracking and resolution of defective work.
    Top Answer:There are many data quality tools available, but some can be expensive. Talend Data Quality stands out because it is often provided for free if you already have Talend Data Integration, which means… more »
    Top Answer:Talend suite might have a missing product, particularly in the commercial master aspect. This would contribute to completing the overall picture, though the focus isn't necessarily on economic… more »
    Ranking
    14th
    out of 56 in Data Quality
    Views
    177
    Comparisons
    82
    Reviews
    1
    Average Words per Review
    535
    Rating
    8.0
    4th
    out of 56 in Data Quality
    Views
    1,486
    Comparisons
    696
    Reviews
    3
    Average Words per Review
    525
    Rating
    8.7
    Comparisons
    Also Known As
    MS Data Quality Services
    Learn More
    Overview

    SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data.

    The data quality tools in Talend Open Studio for Data Quality enable you to quickly take the first big step towards better data quality for your organization: getting a clear picture of your current data quality. Without having to write any code, you can perform data quality analysis tasks ranging from simple statistical profiling, to analysis of text fields and numeric fields, to validation against standard patterns (email address syntax, credit card number formats) or custom patterns of your own creation.
    Sample Customers
    Information Not Available
    Aliaxis, Electrocomponents, M¾NCHENER VEREIN, The Sunset Group
    Top Industries
    No Data Available
    REVIEWERS
    Insurance Company29%
    Pharma/Biotech Company14%
    Healthcare Company14%
    Marketing Services Firm14%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company13%
    Manufacturing Company9%
    Energy/Utilities Company7%
    Company Size
    No Data Available
    REVIEWERS
    Small Business56%
    Midsize Enterprise19%
    Large Enterprise25%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise12%
    Large Enterprise69%
    Buyer's Guide
    Data Quality
    April 2024
    Find out what your peers are saying about Informatica, SAP, Talend and others in Data Quality. Updated: April 2024.
    770,428 professionals have used our research since 2012.

    Microsoft Data Quality Services is ranked 14th in Data Quality with 1 review while Talend Data Quality is ranked 4th in Data Quality with 20 reviews. Microsoft Data Quality Services is rated 8.0, while Talend Data Quality is rated 8.0. The top reviewer of Microsoft Data Quality Services writes " Usefulness of data enrichment features, which can help improve data quality and accuracy". On the other hand, the top reviewer of Talend Data Quality writes "Saves a lot of time, good ROI, seamless integration with different databases, and stable". Microsoft Data Quality Services is most compared with Informatica Data Quality, whereas Talend Data Quality is most compared with Ataccama DQ Analyzer, Informatica Data Quality, Alteryx, Precisely Trillium and Informatica Cloud Data Quality.

    See our list of best Data Quality vendors.

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