Dataloader.io delivers a cloud based solution to import and export information from Salesforce.
$99
per month
dbt
Score 9.0 out of 10
N/A
dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.
N/A
Pricing
Dataloader.io
dbt
Editions & Modules
Professional
$99.00
per month
Enterprise
$299.00
per month
No answers on this topic
Offerings
Pricing Offerings
Dataloader.io
dbt
Free Trial
No
Yes
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Dataloader.io
dbt
Features
Dataloader.io
dbt
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Dataloader.io
-
Ratings
dbt
9.5
Ratings
15% above category average
Simple transformations
00 Ratings
10.00 Ratings
Complex transformations
00 Ratings
9.00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
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.
dbt (Data Build Tool) is best suited for doing the data transformation. dbt is just a transformation tool and it is not suitable for building a data pipeline which requires extraction of data and loading. dbt is well suited for SQL based transformation logic and it is less appropriate when transformation logic requires python.
The selection of objects is much better and more extensive than the Salesforce built in data loader.
Cross referencing of fields for record IDs is easy to use. I can work through this so much more quickly than using the built in Salesforce data loader.
Success and error files are easy to identify what needs to be fixed (errors) and identification of records created (successes), so you can quickly do spot checks in your Salesforce org after doing a data load.
The number of rows per month for a basic package, 100,000, is great for our business.
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.
Slow load times of the dbt cloud environment (they're working on it via a new UI though)
More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros
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 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.
dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.
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.
The UI of Dataloader.IO is far more advanced, user-friendly, and current, than any of the options above. The ability to several tasks (Imports/Exports) at one time. Cloud-based with very easy access to current Imports or Exports, as well previous versions that had previously been run. You can see Imports or Exports across all time, even if you change filter criteria.
Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.
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.
