CData DBAmp vs. dbt

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
CData DBAmp
Score 9.0 out of 10
N/A
DBAmp is a Salesforce integration solution for any SQL DBA. With DBAmp, users can access Salesforce data in real-time using standard SQL. For many organizations, SQL Server plays a critical role in BI and operational reporting. Using DBAmp, users can extend the same SQL Server integrations they've built for BI, analytics, and reporting to Salesforce data.
$2,495
per user
dbt
Score 9.4 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.
$0
per month per seat
Pricing
CData DBAmpdbt
Editions & Modules
Single Server License One-year Subscription
$2,495
per user
No answers on this topic
Offerings
Pricing Offerings
CData DBAmpdbt
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Features
CData DBAmpdbt
Data Transformations
Comparison of Data Transformations features of Product A and Product B
CData DBAmp
-
Ratings
dbt
9.7
5 Ratings
14% above category average
Simple transformations00 Ratings9.55 Ratings
Complex transformations00 Ratings9.95 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
CData DBAmp
-
Ratings
dbt
9.0
5 Ratings
10% above category average
Data model creation00 Ratings9.15 Ratings
Metadata management00 Ratings8.65 Ratings
Business rules and workflow00 Ratings8.05 Ratings
Collaboration00 Ratings9.83 Ratings
Testing and debugging00 Ratings9.55 Ratings
Best Alternatives
CData DBAmpdbt
Small Businesses
Skyvia
Skyvia
Score 9.6 out of 10
Skyvia
Skyvia
Score 9.6 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
CData DBAmpdbt
Likelihood to Recommend
9.0
(1 ratings)
9.6
(7 ratings)
User Testimonials
CData DBAmpdbt
Likelihood to Recommend
CData Software
Well suited as an inexpensive tool as "middleware" between your on-prem or hosted SQL Server. Not sure how well it will translate to cloud-based SQL as a platform (Azure SQL) as it relies on linked servers. This tool only applies to Salesforce CRM - not Marketing Cloud. For writing back to Salesforce we did run into Salesforce resource limitations when extensive triggers existed on the objects.
Read full review
dbt Labs
If you can load your data first into your warehouse, dbt is excellent. It does the T(ransformation) part of ELT brilliantly but does not do the E(xtract) or L(oad) part. If you know SQL or your development team knows SQL, it's a framework and extension around that. So, it's easy to learn and easy to hire people with that technical skill (as opposed to specific Informatica, SnapLogic, etc. experience). dbt uses plain text files and integrates with GitHub. You can easily see the changes made between versions. In GUI-based UIs it was always hard to tell what someone had changed. Each "model" is essentially a "SELECT" statement. You never need to do a "CREATE TABLE" or "CREATE VIEW" - it's all done for you, leaving you to work on the business logic. Instead of saying "FROM specific_db.schema.table" you indicate "FROM ref('my_other_model')". It creates an internal dependency diagram you can view in a DAG. When you deploy, the dependencies work like magic in your various environments. They also have great documentation, an active slack community, training, and support. I like the enhancements they have been making and I believe they are headed in a good direction.
Read full review
Pros
CData Software
  • Connects & Links to Salesforce CRM databases - including custom objects.
  • Built in procedures to create copies of the database on SQL Server.
  • Built in procedures to Add, Update, and Delete data within Salesforce CRM.
  • Great Technical Support.
Read full review
dbt Labs
  • user experience makes it easy to work with SQL and version control
  • customer success team and the dbt (data build tool) community help establish best practices
  • thorough and clear documentation
Read full review
Cons
CData Software
  • Because it uses Linked Servers, not sure how this will work in Azure SQL.
  • Replicated tables are based on user security - this means you have to pay for a license to set this up.
  • There is no built-in function to skip tables or fields on secured tables. This has to be done on the CRM side for fields and we built a function to skip tables in the replication logic.
Read full review
dbt Labs
  • 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
Read full review
Alternatives Considered
CData Software
No answers on this topic
dbt Labs
Most ETL pipeline products have a T layer, but dbt just does it better. The transformation is on steroids compared to the others. Also, just allows much more Adhoc solutions for very specific projects. Those ETL tools are probably better on the T part if you don't need too many transforms - also dbt is pretty much free dependent on how you work it, also extremely scalable.
Read full review
Return on Investment
CData Software
  • Enabled automated marketing segments which enabled automated email series.
  • Helped us solicit donations for the right amount at the right time.
  • Helped us take on new marketing and fundraising campaigns without adding staff.
Read full review
dbt Labs
  • Simplified our BI layer for faster load times
  • Increased the quality of data reaching our end users
  • Makes complex transformations manageable
Read full review
ScreenShots

CData DBAmp Screenshots

Screenshot of Screenshot of