We performed a comparison between SQL Power Data Quality and Talend Data Quality based on real PeerSpot user reviews.
Find out in this report how the two Data Scrubbing Software solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The Nomo, select form, and so on are the most valuable features."
"The solution is able to integrate with many systems and other products."
"It is a scalable solution. We have over 1,000 SQL Power Data Quality users in our organization."
"The file fetch process is impeccable."
"The Studio is easy to understand."
"The solution is customizable."
"It’s easy to monitor the processes. Every morning I’ll open the Talend Administration Center to check the status of the process. Within seconds I’m able to see which process ran successfully and which have failed and why they failed."
"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."
"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."
"It offers advanced features that allow you to create custom patterns and use regular expressions to identify data issues."
"We are able to get emails from URLs very easily using this function when others fail."
"The only area of improvement that we've come across within the solution was the portfolio roadmap creation. There's a bit of limitation there, but otherwise, the tool itself is very good."
"The normalization factor should be improved so that it is better scaled. It should be more user-friendly."
"Downtime issues should be improved."
"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."
"When we upgraded to Version 6.4.1, we tried using a GIT repository instead of a SVN repository. After a few incidents where things disappeared and changes were not saved, we decided to go back to a SVN repository."
"There are more functions in a non-streamlined manner, which could be refined to arrive at a better off-the-shelf functions."
"I would say that some of the support elements need improvement."
"If we encounter issues, it’s most likely when using the Talend Open Studio. The studio can be slow, get stuck, or crash. But again, it can be caused by the resources of your machine or your connection with the repository. If we encounter issues with the Studio we restart the Studio. In emergencies, we create and use a new workspace."
"There are too many functions which could be streamlined."
"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."
"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."
SQL Power Data Quality is ranked 6th in Data Scrubbing Software with 4 reviews while Talend Data Quality is ranked 1st in Data Scrubbing Software with 20 reviews. SQL Power Data Quality is rated 8.8, while Talend Data Quality is rated 8.0. The top reviewer of SQL Power Data Quality writes "Is easy to deploy and is stable and scalable". 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". SQL Power Data Quality is most compared with Alteryx, whereas Talend Data Quality is most compared with Ataccama DQ Analyzer, Informatica Data Quality, Alteryx, Precisely Trillium and Informatica Cloud Data Quality. See our SQL Power Data Quality vs. Talend Data Quality report.
See our list of best Data Scrubbing Software vendors.
We monitor all Data Scrubbing Software 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.