dbt vs. Qlik Replicate

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
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
Qlik Replicate
Score 8.4 out of 10
N/A
Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.N/A
Pricing
dbtQlik Replicate
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
dbtQlik Replicate
Free Trial
YesYes
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
YesYes
Entry-level Setup FeeNo setup feeRequired
Additional Details
More Pricing Information
Features
dbtQlik Replicate
Data Transformations
Comparison of Data Transformations features of Product A and Product B
dbt
9.7
5 Ratings
14% above category average
Qlik Replicate
-
Ratings
Simple transformations9.55 Ratings00 Ratings
Complex transformations9.95 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
dbt
9.0
5 Ratings
10% above category average
Qlik Replicate
-
Ratings
Data model creation9.15 Ratings00 Ratings
Metadata management8.65 Ratings00 Ratings
Business rules and workflow8.05 Ratings00 Ratings
Collaboration9.83 Ratings00 Ratings
Testing and debugging9.55 Ratings00 Ratings
Best Alternatives
dbtQlik Replicate
Small Businesses
Skyvia
Skyvia
Score 9.6 out of 10
Hornetsecurity VM Backup
Hornetsecurity VM Backup
Score 8.6 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
Rubrik
Rubrik
Score 8.8 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
Rubrik
Rubrik
Score 8.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
dbtQlik Replicate
Likelihood to Recommend
9.6
(7 ratings)
8.5
(35 ratings)
Likelihood to Renew
-
(0 ratings)
7.1
(3 ratings)
Usability
-
(0 ratings)
8.4
(32 ratings)
Support Rating
-
(0 ratings)
7.1
(3 ratings)
Implementation Rating
-
(0 ratings)
7.2
(3 ratings)
User Testimonials
dbtQlik Replicate
Likelihood to Recommend
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
Qlik
Qlik Replicate works very well with relational data platforms, both on premise and in the cloud, for example Oracle, SQL Server, PostgreSQL, MySQL and others, it also works very well with DB2. If the data source is MongoDB, it is more complicated and currently there is no possibility of sending data to MongoDB.
Read full review
Pros
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
Qlik
  • Replicate is extremely stable and does not generate a lot of alerts/failures/issues that take up time to troubleshoot.
  • It is very easy to add new source tables to a Replicate task so that we're always in sync with new data available from the CRM.
  • It's nice that Qlik Replicate also allows you to create a job to stop and then restart your tasks during maintenance windows that occur on both the source and target systems.
Read full review
Cons
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
Qlik
  • The base Replicate web GUI is lacking. If you have dozens or more tasks, it's hard to get a sense of how they're performing. Enterprise Manager solves all of these problems but is a separate install.
  • The support portal is extremely difficult to navigate. It's hard to track down exactly what you're looking for.
  • It would be helpful to have better documentation and example queries for the tables in the Enterprise Manager analytics database.
  • Destination databases that don't support common DDL commands behave unpredictably. And the replication of schema changes isn't consistent.
Read full review
Likelihood to Renew
dbt Labs
No answers on this topic
Qlik
The availability of the replicated data in disparate environments has is now crucial. Replacing a product like Qlik Replicate would require significant time, investments, and work. In addition, Qlik Replicate is reasonably reliable with few failures.
Read full review
Usability
dbt Labs
No answers on this topic
Qlik
We now have greater business flexibility and scalability, and our big data integration projects have a quick rate of growth, which has been profitable for us. Independent of the sources involved, maintaining data consistency between sources is easy. One of my favorite features is the way it lets owners of the source system start and stop processes from updating their system windows.
Read full review
Support Rating
dbt Labs
No answers on this topic
Qlik
The issue I've had is that Qlik does an awful job of keeping their customers informed when new versions of the software are available. We found that we were using a version that was no longer supported and could never get help. When it came time to get us upgraded so that we were on a current version, no one knew how to help get us to where we needed to be. We had to purchased professional services time and even then I was basically on my own to get everything built out and set up. Qlik needs to be more proactive with communicating about new releases and how to get your version upgraded in the most secure, safe way possible.
Read full review
Implementation Rating
dbt Labs
No answers on this topic
Qlik
Follow the directions from the Qlik documentation. They are pretty straight forward and easy enough to follow. If you follow these, then you are not likely to have issues on implementation.
Read full review
Alternatives Considered
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
Qlik
Great tool for data replication solution for Oracle/SQLServers/etc. Real easy to get it set up and start realizing business value. Getting the PoC accomplished in a short window. Product costing and easy to start small and scale as needed. It helped cover most of our ask compared to other solutions.
Read full review
Return on Investment
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
Qlik
  • Prior to using Qlik Replicate, we used an ETL solution to copy data from the Oracle ERP system to the Microsoft SQL Server BI system at a 15-minute interval. It was very tedious to maintain. Qlik Replicate is much easier to use and we replicate data near real-time now.
Read full review
ScreenShots

Qlik Replicate Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of