Alation offers enterprise data intelligence solutions, including data search & discovery, data governance, data stewardship, analytics, and digital transformation. Alation operates in thethe data catalog market. With its Behavioral Analysis Engine, inbuilt collaboration capabilities, and open interfaces, Alation combines machine learning with human insight with the goal of tackle the most demanding challenges in data and metadata management.
N/A
DemandTools
Score 9.8 out of 10
N/A
DemandTools for AppExchange is a data quality toolset for Salesforce.com CRM centric customers.
The product comprises 11 individual modules to control, standardize, verify, deduplicate, import and manipulate Salesforce and/or Force.com data.
N/A
Informatica Cloud Data Quality
Score 6.8 out of 10
N/A
The vendor states that Informatica Data Quality empowers companies to take a holistic approach to managing data quality across the entire organization, and that with Informatica Data Quality, users are able to ensure the success of data-driven digital transformation initiatives and projects across users, types, and scale, while also automating mission-critical tasks.
Alation is well suited to helping a user find a column or even a query using a business term search. In this regard Alation is excellent because it's easy to not only associate these items with each other, but there are also many ways to link the column and/or query to that business term/concept
DemandTools is perfect for any system that constantly adds new records to its database. For example, in higher education, we are constantly purchasing search names from various vendors and DemandTools allows us to make sure we are not doubling up on the same records. It saves us money in the long run as we are not mailing out multiple copies of our brochures to the same person.
For effective data collaboration, systematic verification of customer information, and address, among others, Informatica Data Quality is a fruitful application to consider. Besides, Informatica Data Quality controls quality through a cleansing process, giving the company a professional outline of candid data profiling and reputable analytics. Finally, Informatica Data Quality allows the simplistic navigation of content, with a dashboard that supports predictability.
Ability to link objects using the @ symbol. It allows us to easily provide a way to get more information or context. So if the business concept is part of a hierarchy, we can link to the other terms in that hierarchy.
The customization is really helpful. Most object types have robust customization options. Others are less so, but it is improving. We've created multiple custom fields to support our data governance framework.
The search feature with filtering is helpful in narrowing down what you're looking for.
The matching algorithms in IDQ are very powerful if you understand the different types that they offer (e.g., Hamming Distance, Jaro, Bigram, etc..). We had to play around with it to see which best suit our own needs of identifying and eliminating duplicate customers. Setting up the whole process (e.g., creating the KeyGenerator Transformation, setting up the matching threshold, etc..) can be somewhat time consuming and a challenge if you don't first standardize your data.
The integration with PowerCenter is great if you have both. You can either import your mappings directly to PowerCenter or to an XML file. The only downside is that some of the transformations are unique to IDQ, so you are not really able to edit them once in PowerCenter.
The standardizer transformation was key in helping us standardize our customer data (e.g., names, addresses, etc..). It was helpful due to having create a reference table containing the standardized value and the associated unstandardized values. What was great was that if you used Informatica Analyst, a business analyst could login and correct any of the values.
The lineage UI is not ready for primetime. I would not recommend this feature for my users at this time because it's too complex to understand and is visually difficult to track down specific paths.
The underlying infrastructure of the on-premise version of the software is fragile and unnecessarily complicated, using too many modules and technologies.
The license model of the on-premise version contains too many add-ons. I would like to pay one price and get all of the features.
I wish I could make changes to my existing scenarios using save rather than having to create a whole new scenario. Maybe you can, I just haven't been able to.
Some features aren't user intuitive and it takes a while to learn.
Overall, we are happy with the functionality of the platform. While there are are areas that we would like to see further improvement in, the tooling is highly configurable and aligns well with our use case. A mature API layer makes it straightforward to integrate with other data tooling. Alation stands out for its pro-active engagement with their customers, both to resolve issues and in communicating their feature roadmap
It's a great product. The only thing that holds us back is it was frustrating working with their sales team. We also don't like that when Validity purchased DemandTools they immediately started charging us quite a bit while it had been free for non-profit users when CRMFusion owned it. They also don't let you buy it for just 1 or 2 seats, you have to pay, I believe, in batches of 100 seats.
As pointed out earlier, due all the robust features IDQ has, our use f the product is successful and stable. IDQ is being used in multiple sources (from CRM application and in batch mode). As this is an iterative process, we are looking to improve our system efficiency using IDQ.
Mostly because the search feature is case sensitive. This causes issues when users are searching for an industry standard acronym. These acronyms exist as attributes in thousands of places across our data ecosystem. Alation allows stewards to endorse attributes so that these endorsed items rise to the top of search results. The problem is no one types acronyms in caps in a search field. Alation returns results matching the case (lower-case) and in several instances the endorsed attributes don't even appear on the first page of results
The account management and technical support teams are both excellent. There is regular account manager engagement, and technical issues are generally resolved very quickly. The vendor engages us in product development through regular updates on the product strategy & feature roadmap.
Support can be slow so do not expect quick turn for urgent issues. Help for specific queries not not there. Product tech support is offered. It would be great if query support, even if paid, was offered The training webinars help with the basics but not much if you need advanced functionality.
The trainings are free live webinars that give you a solid base for getting started with the program. The only weakness is they don't have any advanced classes.
Key insight from implementing Alation is that, as a cloud-based SaaS product, the majority of effort is not infrastructure-related but instead focused on security configuration and integration with existing platforms, including identity management, access controls, and metadata connectivity to core data systems. Because of its data profiling functionality, careful consideration had to be given to data security and data sovereignty.
I had just started using Salesforce about 3 months before I did the implementation myself, and it was easy to do just following their step-by-step instructions.
Alation provided the right balance of connection with systems in use, trusted reputation and affordability. The product integrates with current ways of working and does not require reorganisation within other lines of business.
Though RingLead has much more to offer in terms of automation (and it is in Salesforce rather than a separate program), DemandTools still has our heart. DemandTools is very cost-friendly and we were able to increase the value of DemandTools by programming in additional saved scenarios. I decreased admin time in the DemandTools suite by approximately 25% after implementing saved scenarios for every reoccurring update or list upload.
IDQ is used by a department at my organisation to ensure and enhance the data quality. The usage was started with address standardization and now it had been brought to altogether a next level of quality check where it fixes duplicates, junk characters, standardize the names, streets, product descriptions. In the past we had issues mainly with duplicate customers and products and this were affecting the sales projection and estimates.
Provides a place where people can go to find things
When we first implemented, someone was concerned that people would now see what a mess our data environment was. I consider that a feature. We can't clean up if we can't see what we have.
