Microsoft Data Quality Services vs Talend Data Quality comparison

"The primary advantage of Microsoft Data Quality Services is its capability to automate certain tasks, which are otherwise achieved through SQL queries."

"This solution is particularly useful for data enrichment."

"It reduces the QA effort immensely by handling most of the test scenarios in a reusable way."

"I really like the fact that there are no out-of-the-box solutions regarding the development of jobs. Other vendors may have modules which cleanse your addresses. In Talend, you have the freedom to completely develop the process yourself. This can be tricky, but it also makes it fun."

"We are able to get emails from URLs very easily using this function when others fail."

"It offers advanced features that allow you to create custom patterns and use regular expressions to identify data issues."

"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."

"Provides a flexible development environment to the coder.​"

"​This product speeds up the unit testing and QA for specific test scenarios. As a result, the development output quality can be evaluated and adjusted.​"

"The solution enables robust data matching, merging, survivorship, and Data Stewardship that can be a part of data quality workflows or true master data management."

"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."

"Technical support from Microsoft is poor, as they do not provide adequate assistance with issues encountered in integration or forming automation."

"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."

"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."

"Heap space issues plague us consistently. We maxed it out and it runs fine, then it doesn’t, then it does."

"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."

"It would be more helpful if it offered dynamic dashboards that could be directly used by clients for better analysis."

"The ability to change the code when debugging the JavaScript could be improved."

"SQL for displaying underlying data in non-match results does not work."

"I would say that some of the support elements need improvement."

"The pricing is in the midrange. It's not cheap, but it depends on the licenses you require."

"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."

"I would advise to first take a look and at the Open Studio edition. Figure out what you need and purchase the appropriate license."

"Moreover, the pricing structure stands out as highly competitive compared to other offerings in the market, making it a cost-effective choice for users."

"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."