TrustRadius

dbt vs. Striim

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
dbt
Score 9.1 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
Striim
Score 8.3 out of 10
N/A
Striim is an enterprise-grade platform that offers continuous real-time data ingestion, high-speed in-flight stream processing, and sub-second delivery of data to cloud and on-premises endpoints.
$4,400
per month per 100 million Striim events
Pricing
dbtStriim
Editions & Modules
No answers on this topic
Striim Cloud Enterprise Platform
$4,400
per month per 100 million Striim events
Striim Platform
$20,000
per year per VCPU
Offerings
Pricing Offerings
dbtStriim
Free Trial
YesYes
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
dbtStriim
Considered Both Products
dbt
Chose dbt
dbt is very flexible and can fit into most data pipelines. This is a pro for most organizations that aren't fully bought into one platform (Google Cloud, etc.)
Verified User
Anonymous
Chose dbt
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.
Verified User
Anonymous
Chose dbt
I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT …
Judy Campion | TrustRadius Reviewer
Judy Campion
Data Architect
Chose dbt
Snaplogic is great at the Extraction and Load processes of ETL. It can pull data from anywhere, even behind firewalls. So if you need to get data from various APIs, databases, files, S3, SFTP, etc it is easy to do so. However, it requires special knowledge in order to build …
Verified User
Anonymous
Chose dbt
I haven't come across anything like DBT before.
YP
Yoshlin Pillay
Senior Data Entry
Chose dbt
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 …
Obed Espina | TrustRadius Reviewer
Obed Espina
Senior Data Engineer
Chose dbt
Airflow can accomplish the same work as dbt (data build tool), however, dbt's (data build tool) development workflow and UI can open up data transformation and modeling work to non-data engineering teams. Looker might also be able to define data models via LookML with a …
Verified User
Anonymous
Chose dbt
dbt is great because of its transformation capabilities
Striim
Chose Striim
Faster, checkpointing better. CDC works well. The loading is faster. Easy upgrade and installation. Uses less resource.
Features
dbtStriim
Data Transformations
Comparison of Data Transformations features of Product A and Product B
dbt
9.7
Ratings
18% above category average
Striim
8.9
Ratings
10% above category average
Simple transformations10.00 Ratings10.00 Ratings
Complex transformations9.50 Ratings7.80 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
dbt
9.1
Ratings
15% above category average
Striim
8.5
Ratings
8% above category average
Data model creation9.70 Ratings8.40 Ratings
Metadata management8.70 Ratings8.40 Ratings
Business rules and workflow9.00 Ratings9.00 Ratings
Collaboration10.00 Ratings7.80 Ratings
Testing and debugging8.00 Ratings7.20 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
dbt
-
Ratings
Striim
10.0
Ratings
19% above category average
Connect to traditional data sources00 Ratings10.00 Ratings
Connecto to Big Data and NoSQL00 Ratings10.00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
dbt
-
Ratings
Striim
9.5
Ratings
17% above category average
Integration with data quality tools00 Ratings9.00 Ratings
Integration with MDM tools00 Ratings10.00 Ratings
Best Alternatives
dbtStriim
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
dbtStriim
Likelihood to Recommend
10.0
(0 ratings)
8.8
(0 ratings)
Usability
9.7
(0 ratings)
-
(0 ratings)
User Testimonials
dbtStriim
Likelihood to Recommend
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.
Sahil Khan | TrustRadius Reviewer
Sahil Khan
Data Analyst
Read full review
Below samples are the well suited use cases; - Change data capture feature seamlessly works on popular RDMS. You can make enrichments on several data sources within the same Striim application. - You can install stand alone agents and start streaming log files to Striim servers. This is mainly useful for security operations or audit trail use cases.
Verified User
Anonymous
Read full review
Pros
  • 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
Obed Espina | TrustRadius Reviewer
Obed Espina
Senior Data Engineer
Read full review
  • GoldenGate Trail reader which iss faster than Oracle CDC. It does not used logminer, hence there is no load on source Oracle database.
  • Easy installation and upgrade in 5 minutes
  • Support is very good. Fast and user friendly.
RJ
Read full review
Cons
  • 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
Verified User
Anonymous
Read full review
  • License a bit expensive
RJ
Read full review
Usability
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.
SI
Sid Iyer
BizOps
Read full review
No answers on this topic
Alternatives Considered
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.
Verified User
Anonymous
Read full review
Faster, checkpointing better. CDC works well. The loading is faster. Easy upgrade and installation. Uses less resource.
RJ
Read full review
Return on Investment
  • In 3 months we re-wrote the data warehouse (15-20 sources) in dbt with 3 developers.
  • We are using it continually for the past year with no issues.
  • Sorry, I don't have ROI numbers but the impact was huge.
Judy Campion | TrustRadius Reviewer
Judy Campion
Data Architect
Read full review
  • We got the license at a discount price
RJ
Read full review
ScreenShots