Dataloader.io vs. DemandTools vs. Informatica Intelligent Data Management Cloud

Replacing data. If we've put something in a category or a bucket that is no longer named that anymore because we've evolved with the times and we want to rebrand everything, it makes it way easier to do a quick import with the new terms.

Incentivized

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.

Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.

Incentivized

• Extracting Salesforce attachments in original file format! I do not know of a tool that can do this better, or more efficiently! This is a huge benefit to companies that would like to extract attachments from Salesforce for tasks like data migrations.
• Cross-object data extract within one file. You can pull data from related objects as long as there is a populated lookup from the object you are extracting, to another object (Child or Parent).
• UI is simple and requires very little to no training. Given the acquisition of Mulesoft by Salesforce, I would not be surprised if DataLoader.IO is rolled out as the new global data loading tool for Salesforce.

Incentivized

• PowerGrid can review and make the updates simultaneously.
• Single Table Dedupe makes merg[ing] the records easy and can make updates at the same time.
• BulkBackup [is] just one click, majority data got updated.
• Scenarios save a lot of time for similar working load.

Incentivized

• Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
• The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
• The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.

Incentivized

• At the moment, I can't find a way to rename jobs. This would be useful to organize what was previously created hastily by techs in a rush.
• A preview of the job, especially upserts, would take a great deal of stress away from some of us (especially those who are not so confident in their ETL practice).
• A native vlookup equivalent may be a welcome addition.

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

Incentivized

• The User Interface can be a bit difficult to get in initial stages.
• Error messages are hard to understand which sometimes takes a lot of time for the resolution
• Cannot Implement complex SQL queries which should be fixed in future release.

Incentivized

It is easy to use and doesn't require a security token, so I enjoy using it. It also doesn't require any download or installation, which is sometimes a blocker to gettingthings done if the company has limits. also, the dataloader.io is easy for other people to pick up, so others can have visibility into the data jobs that have occurred

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.

Incentivized

Dataloader definitely skews towards a more technical userbase. Users should be adept at manipulating data in spreadsheets and decipher JSON formatted error messaging. Additionally, there is a good amount of time need to set up the environment to map to the pertinent fields we are trying to adjust. While I would not recommend the typical account manager to use Dataloader, a typical operations manager should have no issue.

Incentivized

Allows for control in uploading lists, saved processes for checking duplicate records.

Allows for backup files and quick reverts if something goes wrong.

Extends reporting when Salesforce.com cannot support specific pieces of info being put together in a report.

Automated processes for set and forget hygiene tasks

There has not been a time since I started 9 months ago that I've encountered any kind of downtime.

Incentivized

Dataloader is made for updating, inserting, and deleting of contacts. For these operations this tool is excellent.

Incentivized

DemandTools is a bit clunky and slow at times

Incentivized

The utility itself is very self-explanatory and has enough information to guide you through the process. It has an intuitive experience for those familiar with data loading/exporting utilities. Outside of this, they have a Zendesk help center to log support requests and provide documentation to help guide you troubleshoot any issues that may be occurring.

Incentivized

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.

I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.

Incentivized

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.

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.

I have used salesforce inspector also for operations like import and export of data from custom objects but it doesn't work well when you have data in huge numbers. Instead of using Salesforce Inspector, one should go for Dataloader.io if the number of records is huge to be dealt with.

Incentivized

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.

Incentivized

First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.

Incentivized

It's done everything we've needed it to do.

Incentivized

• HUGE time saving. When we need to clean or review data, we used to have to do it line by line. This can do the work within excel and make cleanup/management an afternoons work as opposed to a week.
• Rollback what you did/change/deleted is relatively simple if you remember to back up the data you are manipulating.

Incentivized

• It is a tremendous time saver. It does things Salesforce doesn't even have the capability to do. Tasks that would take hours to manually complete.
• We can process a tremendous amount of data daily through one person, vs. weeks for the data to be cleaned, reviewed, routed and input.
• Saves on headcount by allowing a dedicated user to set up batches and jobs for other teams to ensure their data integrity.
• The return on investment isn't easily quantifiable but it is FELT in our department.

Incentivized

• Cut costs on the number of staff we need for data import.
• Cut costs for automation that can be done for data that no longer has to be manually imported.
• We've saved countless dollars by eliminating duplicates in our system with this tool.

Incentivized