SnapLogic vs dbt comparison

Read 24 SnapLogic reviews

2,461 Views
1,692 Comparison Views

87% willing to recommend

dbt

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SnapLogic and dbt are competing in the data integration and transformation category. SnapLogic stands out for its integration capabilities, while dbt has an advantage in transformation tools due to its detailed data processing features.

Features: SnapLogic offers pre-built connectors, a straightforward integration platform, and robust cloud integration features, making it a great fit for businesses needing efficient data movement. dbt provides strong transformation capabilities, focusing on data modeling and customization through SQL-based models, and benefits from its open-source transformation framework that supports detailed processing.

Ease of Deployment and Customer Service: SnapLogic offers faster deployment times and responsive customer service, aiding quick adoption. dbt deployment is efficient but requires more technical expertise. Its customer support is well-regarded but may involve more self-service to solve issues.

Pricing and ROI: SnapLogic has a higher initial setup cost due to its extensive integration features, but this is seen as reasonable given the efficiency and scalability it provides. dbt is more cost-effective initially, appealing to companies prioritizing detailed data transformation with the potential for enhancing long-term ROI.

To learn more, read our detailed SnapLogic vs. dbt Report (Updated: April 2025).

Download the complete report

SnapLogic vs. dbt

April 2025

Helped 848,253 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

dbt

Ranking in Data Integration

38th

Average Rating

7.6

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

SnapLogic

Ranking in Data Integration

21st

Average Rating

7.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Process Automation (15th), Cloud Data Integration (12th), Integration Platform as a Service (iPaaS) (10th)

Featured Reviews

Ninad Magdum

Senior Machine Learning Engineer at Happiest Minds Technologies

Developer-friendly and easy to use, but doesn't have many optimization options

We also use stored procedures and Talend. They are not replaced by dbt completely. We use dbt only for the transformation process. My recommendations would depend on an organization’s requirements and problems. I will recommend the tool to others. The product is developer-friendly. However, it is still dependent on the data warehouse for big data and optimization. It's just a SQL transformation tool. It doesn't have a lot of optimization options like Spark. It's a good tool for Snowflake. If it were only for Snowflake, I would have rated it an eight out of ten. However, there are other data platforms. Overall, I rate the tool a six and a half out of ten.

Read full review

VinethSuresh

Senior Data Analyst at a pharma/biotech company with 10,001+ employees

Achieves rapid results in data migration and has an intuitive user interface

I find SnapLogic to be user-friendly, especially for beginners with limited experience in data engineering or ETL. The interface is interactive, allowing me to quickly learn how to run pipelines and achieve production-ready results swiftly. This agility translates to cost savings, especially for smaller projects and proofs of concept, as less time and effort are needed to deliver results.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The product is developer-friendly."

"You can use other languages, such as Python, and easily connect to other systems."

"I found SnapLogic valuable and what I found most valuable about it was its ETL feature. I also found its automation feature valuable. It can be used for automating manual activities. It can be used as a middleware for certain transactional data processing and minimal datasets and ETL activities."

"They are very good at building out new aspects according to customer requirements."

"Overall product rating is nine out of ten."

"The connection with SOAP is the best feature."

"The API architecture makes it easy for orchestration."

"What I found most valuable in SnapLogic is the ETL feature, particularly the Transform Snap Pack, for example, any kind of reading or writing on Transform Snaps. Other than that, all the third-party connectivity tools such as the SAP Snap Pack, Salesforce Snap Pack, Workday Snap Pack, even the ServiceNow Snap Pack, I find all those are pretty useful in SnapLogic."

"The vendor handles the maintenance of the solution"

More SnapLogic pros

Cons

"The solution must add more Python-based implementations."

"I would like to see more performance-related dashboards, ones that display the cost of a pipeline, for instance. Also, it would be helpful to have management dashboards for overseeing pipelines and connections."

"SnapLogic should have some inbuilt protocol mechanism in order to speed up."

"They should expand in terms of features for SaaS-based market requirements in different sectors."

"Connecting to data behind enterprise firewalls has been tricky."

"If the AI capabilities and integrations were more intuitive and easy for new users to learn, it would be greatly beneficial."

"The support is the most important improvement they could make."

"The solution isn't ideal for complex processing or logic. We use another solution for that."

"What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools."

More SnapLogic cons

Pricing and Cost Advice

"The solution’s pricing is affordable."

"SnapLogic's price is high compared to the other tools available in the market."

"When comparing it with solutions like Apigee or MuleSoft, it still offers better value."

"From the ROI perspective, the price is extremely high"

"The pricing is okay."

"The cost with SnapLogic is an annual license and better than Informatica."

"I used the free trial."

"By scaling the solution incrementally the cost is controlled and more beneficial to the client."

"It is a higher initial cost than other easy-to-use integration apps."

More SnapLogic pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

848,253 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Insurance Company

12%

Computer Software Company

Healthcare Company

Financial Services Firm

25%

Manufacturing Company

10%

Computer Software Company

Real Estate/Law Firm

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What is your experience regarding pricing and costs for dbt?

It is cheap because dbt is open source. If you compare the pay-per-service of Dbt with the open source option you can manage. We are managing the solution, when we were acquiring service from them....

What needs improvement with dbt?

SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us. Another issue is the terms of data ingestion becau...

What is your primary use case for dbt?

We use the solution to deal with data transformations inside different organizations.

What do you like most about SnapLogic?

Despite having no prior experience in SnapLogic, we managed to build, test, and prepare it for release in just three hours, handling heavy data efficiently.

What needs improvement with SnapLogic?

I am quite happy with the solution and do not have specific requirements at the moment. I tend to frequently communicate with SnapLogic to ask for additional features, and they have been responsive...

What is your primary use case for SnapLogic?

I mainly use it for data integration and some API tasks.

Informatica PowerCenter vs dbt

Comparisons

SSIS vs dbt

Compared 30% of the time

Compared 15% of the time

Tobiko vs dbt

Compared 8% of the time

Palantir Foundry vs dbt

Compared 7% of the time

Azure Data Factory vs dbt

Compared 4% of the time

More dbt Competitors

AWS Glue vs SnapLogic

Compared 15% of the time

IBM InfoSphere DataStage vs SnapLogic

Compared 7% of the time

Alteryx Designer vs SnapLogic

Compared 6% of the time

Azure Data Factory vs SnapLogic

Compared 6% of the time

MuleSoft Anypoint Platform vs SnapLogic

Compared 5% of the time

More SnapLogic Competitors

Product Reports

Download dbt product report

Data Integration

March 2025

Download SnapLogic product report

March 2025

Also Known As

No data available

DataFlow

Overview

dbt is a transformational tool that empowers data teams to quickly build trusted data models, providing a shared language for analysts and engineering teams. Its flexibility and robust feature set make it a popular choice for modern data teams seeking efficiency.

Designed to integrate seamlessly with the data warehouse, dbt enables analytics engineers to transform raw data into reliable datasets for analysis. Its SQL-centric approach reduces the learning curve for users familiar with it, allowing powerful transformations and data modeling without needing a custom backend. While widely beneficial, dbt could improve in areas like version management and support for complex transformations out of the box.

What are the most valuable features of dbt?

SQL-Based Development: Facilitates transformations using SQL, streamlining the data modeling process.
Modularity: Encourages reusable components, making projects easier to manage and scale.
Version Control: Integrates with version control systems to track changes and collaborate effectively.
Testing Framework: Ensures data quality through automated tests, increasing trust in data outputs.

What benefits should you expect from using dbt?

Efficiency: Cuts down data processing times, allowing faster access to insights.
Collaboration: Promotes teamwork through shared data models and a common working language.
Scalability: Supports growing data demands by transforming complex data more flexibly and modularly.
Transparency: Provides clear documentation and lineage tracking, aiding in troubleshooting and understanding.

In the finance industry, dbt helps in cleansing and preparing transactional data for analysis, leading to more accurate financial reporting. In e-commerce, it empowers teams to rapidly integrate and analyze customer behavior data, optimizing marketing strategies and improving user experience.

dbt Labs

The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.

Sample Customers

Information Not Available

Adobe, ADP, BlackBerry, Bonobos, Box, Capital One, Dannon, Eero, Endo, Gensler, HCL, HP, Grovo, HIS, iRobot, Leica, Merck, Sans, Target, Verizon, Vodafone, Yelp, Yahoo!