Likelihood to Recommend Dataloader is an incredible asset for a large organization or an organization that has a robust Salesforce environment. Specifically, Dataloader has allowed our sales team to focus on driving sales while our operations team can load the data they need in a manner that allows for robust reporting and tracking on our sales process. Organizations with less robust Salesforce environments or Salesforce environments in which many people are expected to maintain their own information likely do not need Dataloader.
Read full review Helps to increase productivity, optimize costs, and democratize data across multiple cloud environments with cloud ETL and ELT. Capacity to integrate data sources at scale and with ease. Has cloud data integration capabilities that cover diverse sets of patterns, use cases, and users ensuring we have well-architected and seamless automated data pipelines.
Read full review Pros 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. Read full review 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. Read full review Cons 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. Read full review Several partnerships diminishing the value of technologies Unable to get list of objects from Repository (like sources & targets) that don't have any dependency Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this. Read full review Likelihood to Renew 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
Read full review 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.
Read full review Usability It is an intuitive application to use. Within a few clicks, you can be signed in to your org and ready to perform tasks. Data imports/exports/updates are streamlined so you can quickly start and configure your jobs. These can run in the background while you set up new tasks. Job history and tasks currently running on are on your home screen.
Read full review Easy to use not only for developers but also business users
Read full review Reliability and Availability The application works well except an occasional error out while using the system. It usually gets fixed when restarting the Infa server
Read full review Performance Dataloader is made for updating, inserting, and deleting of contacts. For these operations this tool is excellent.
Read full review Performance works just fine. It was able to load 200+ business terms, 150+ DQ automation, etc. very well.
Read full review Support Rating Customer support might be where Dataloader.io saves money. Most of the competitors offer 24/7 live support but Dataloader.io only offers support via email and the community. Those types of support work fine until you need an answer right away. Some questions can't wait until the next business day or business hours for a reply.
Read full review Alternatives Considered 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.
Read full review Informatica Data Quality has a wide range of cleansing features, that are detailed, professional, and accurate in scaling down the required database. Further, Informatica Data Quality ensures there is proper collaboration, and this fosters businesses to have the freedom of working closely with several programs. Finally, Informatica Data Quality design is authentic and allows personalization.
Read full review Scalability Scalability works as expected and it is truly an enterprise system.
Read full review Return on Investment 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. Read full review Integration with tools like PowerCenter helped faster delivery of product, and at the same time conversion Reduce overall project cost due to bad data , bad quality, exceptions identified nearing go-live and post production Employee efficiency is increased exponentially due to more automated, customized tool Read full review ScreenShots