DemandTools: For Data-Superheroes and Awesome Admins!
Andy Corbett | TrustRadius Reviewer
June 17, 2020

DemandTools: For Data-Superheroes and Awesome Admins!

Score 10 out of 10
Vetted Review
Verified User
Review Source

Modules Used

  • MassEffect
  • MassImpact
  • ReassignOwnership
  • Single Table Deduplicator
  • Find / Report ID's

Overall Satisfaction with DemandTools

I am using DemandTools to support our Salesforce implementation in Financial Services. It is being used as a data-analysis/manipulation tool to support our lead generation and sales activities. As well as generating leads in Salesforce, we also receive data from several other sources, and we use DemandTools to manipulate that data accordingly. This resolved duplication issues, as well as aligning data between systems.
  • Deduplication: complex scenarios can be created across multiple dimensions to remove duplicate records and maintain a clean database. Powerful engine.
  • Find/Report Ids: very useful for bringing in external data and comparing it to records already present in Salesforce. Records can then be updated or inserted accordingly.
  • MassEffect: let's call this "Data Loader on steroids"— a very powerful tool for inserts/deletes/updates/upserts/exports.
  • Some might say the interface is dated, but for me, having everything on one page is much better than constantly having to go backward and forward. They are working on a new interface, which is in beta.
  • The auto-login experience could be slightly improved, especially if you want to switch between orgs you have to log in to the previous org, deselect the auto-login option, logout, and restart the application. A 'switcher' would be nice.
  • Automation of routine tasks; once you have set up a scenario. e.g. importing and updating from a file. You can save that scenario. Future files of the same format can be placed in a folder, and the DemandTools JobBuilder can automatically run DemandTools, load your data file and your scenario, and output the results.
  • Although the manual import of data can be tedious in general, for smaller tasks where it would be costly to design and implement a connection between systems, DemandTools can semi-automate your processes at a fraction of the cost.
  • It empowers the System Administrator and can tell you a lot about your org just by using some of the modules to undertake analysis.
DemandTools has helped with the new GDPR legislation, especially in terms of data quality and de-duplication. As a 'solo admin' looking for time efficiencies, DataLoader has become my best friend. There have been numerous business requests where DataLoader has been the only tool I need to meet those requests.
Onboarding was excellent. From demos, through to support. I watched all of the pre-recorded webinars (they have at least one for every module). I have attended live training webinars, and also had a two-hour one-to-one session where they gave advice and guidance on our specific requirements. I have used support several times, as well as the Validity Community where you can ask questions and share experiences and best practice with other users. The documentation is excellent as well.
  • The user interface! I find it very efficient, and the concept of the 'single-table dedupe' is excellent.
  • MassEffect; my most-used tool. This is a data-loader superhero!
  • Single-table Dedupe; due to the non-standard way we collect Leads, this will prove invaluable due to the complex scenarios, matching rules, and merge instructions that can be specified.
  • Find/Report Ids; the multi-pass, multi-step features, as well as industry-standard matching algorithms, make this a must-have for identifying existing records and preventing further data duplication issues.
We looked at several similar, but DemandTools was the only one that met our strict security requirements and allowed us to connect via our company proxy server.
It is well suited to larger data sets and crucially can use Excel files as a source rather than CSV. This is important to me as converting Excel to CSV prior to imports can lose data formats; some of our data operations we couldn't do with DataLoader, for example, but are a breeze with DataLoader. Taking a file of data from another system and comparing it to Salesforce records is very slick. Most DemandTools modules come with multi-pass matching routines, which allow you to compare data, e.g. for de-duplication or import, and give you various levels of confidence that you have found a match.