SAS Data Management vs Talend Data Quality comparison

"If you compare it to SQL, the memory and development times are very quick."

"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."

"The technical support is excellent."

"The tool is reliable, quick, and powerful."

"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."

"The product offers very good flexibility."

"I am impressed with the tool's ability to customize."

"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."

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

"The jobs are visual and this has improved collaboration between colleagues. It’s much easier to understand a visual job than a piece of Java code."

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

"The file fetch process is impeccable."

"The numerous components provided by Talend mean you’re able to create jobs quickly and efficiently."

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

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

"We have used value frequency and patterns. We have been it impressed with these functions as they have helped us in making decisions in transformation work."

"Integration and cloud migration are areas where we see potential for improvement."

"The pricing of the solution needs to be improved. They need to work to make it more affordable."

"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."

"The solution is quite expensive and hard to install/configure."

"The solution could use better documentation."

"I would like the tool to include the ability to automate the modifications of the integrations."

"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."

"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."

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

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

"Needs integrated data governance in terms of dictionaries, glossaries, data lineage, and impact analysis. It also needs operationalization of meta-data."

"There are more functions in a non-streamlined manner, which could be refined to arrive at a better off-the-shelf functions."

"The performance is one area that Talend Data Quality could improve in because large volumes take a lot of time."

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

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

"The licensing model for vCenter is a perpetual license with yearly payments."

"The tool is a bit expensive."

"The solution is expensive."

"While it is even free for personal use on the cloud, it can be expensive for desktop installations and enterprise use."

"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's a subscription-based platform, we renew it every year."

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

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