SSIS vs dbt comparison

dbt Labs and Microsoft are both solutions in the Data Integration category. dbt Labs is ranked #45 with an average rating of 7.5, while Microsoft is ranked #4 with an average rating of 8.0. Additionally, 100% of dbt Labs users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.

dbt

Read 2 dbt reviews

247 Views
226 Comparison Views

100% willing to recommend

SSIS

Read 71 SSIS reviews

14,990 Views
12,034 Comparison Views

80% willing to recommend

dbt

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between dbt and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed SSIS vs. dbt Report (Updated: October 2024).

Buyer's Guide

SSIS vs. dbt

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

dbt

Ranking in Data Integration

45th

Average Rating

7.6

Number of Reviews

Ranking in other categories

No ranking in other categories

SSIS

Ranking in Data Integration

4th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

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

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Its ability to transform and transport data is extremely valuable

he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.

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."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

"SSIS' most valuable feature is its reporting services."

"It is easy to set up the solution."

"The UI is very user-friendly."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"It's a competent product."

More SSIS pros

Cons

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

"The solution could improve by having quicker release updates."

"I would like to see better technical documentation because many times information is missing."

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."

"The solution could improve on integrating with other types of data sources."

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

"We'd like them to develop data exploration more."

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

More SSIS cons

Pricing and Cost Advice

"The solution’s pricing is affordable."

"People have to opt for a perpetual-based licensing model."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"The solution is available at a lesser price than that of Informatica."

"This solution is included with the MSSQL server package."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

More SSIS 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

816,406 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

15%

Computer Software Company

Healthcare Company

Insurance Company

Financial Services Firm

17%

Computer Software Company

12%

Government

Healthcare Company

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....

See all answers

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...

See all answers

What is your primary use case for dbt?

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

See all answers

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

Informatica PowerCenter vs dbt

Compared 28% of the time

Rivery vs dbt

Compared 10% of the time

Tobiko vs dbt

Compared 8% of the time

Oracle Data Integrator (ODI) vs dbt

Compared 8% of the time

More dbt Competitors

Informatica PowerCenter vs SSIS

Compared 24% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

AWS Glue vs SSIS

Compared 5% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Data Integration

November 2024

Download dbt product report

Buyer's Guide

SSIS

October 2024

Download SSIS product report

Also Known As

No data available

SQL Server Integration Services

Learn More

dbt Labs

Microsoft

Overview

dbt™ is a SQL-first transformation workflow that lets teams quickly and collaboratively deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone on the data team can safely contribute to production-grade data pipelines.
Deploy safely using dev environments. Git-enabled version control enables collaboration and a return to previous states. Test every model prior to production, and share dynamically generated documentation with all data stakeholders. Write modular data transformations in .sql or .py files – dbt handles the chore of dependency management.

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Sample Customers

Information Not Available

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo

Buyer's Guide

SSIS vs. dbt

October 2024

Free Report: SSIS vs. dbt

Find out what your peers are saying about SSIS vs. dbt and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our SSIS vs. dbt report.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.