dbt vs. SolarWinds Task Factory

dbt

SolarWinds Task Factory

Overview
Product	Rating	Most Used By	Product Summary	Starting 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
SolarWinds Task Factory	Score 8.3 out of 10	N/A	According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been optimized to ensure fast performance of data-centric applications, and the user can run Task Factory…	N/A

Pricing

dbt

SolarWinds Task Factory

Editions & Modules

No answers on this topic

Task Factory: 1,245 (annual subscription license)
per server
Task Factory Azure Data Factory: 1,495 (annual subscription license)
per ADF node

Offerings

Pricing Offerings
dbt	SolarWinds Task Factory
Free Trial
Yes	Yes
Free/Freemium Version
Yes	Yes
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	dbt	SolarWinds Task Factory
Considered Both Products	dbt SI Sid Iyer BizOps 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.) Incentivized Helpful? 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. Incentivized Helpful? 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 … Incentivized Helpful? 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 … Incentivized Helpful? Verified User Anonymous Chose dbt I haven't come across anything like DBT before. Incentivized Helpful? 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 … Incentivized Helpful? 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 … Incentivized Helpful? Verified User Anonymous Chose dbt dbt is great because of its transformation capabilities Incentivized Helpful? DD Daniel Denunzio Data Architect Chose dbt dbt fits much better in our stack, where we're using specialized tools to support our ELT approach. Incentivized Helpful?	SolarWinds Task Factory Holly Couch Executive Administrator Chose SolarWinds Task Factory SolarWinds Task Factory has a lot of SQL integrated SSIS in one location that makes it easy to automate nearly every business procedure without integrating with external applications. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory We really did not look at any other products. We had already heard of SolarWinds Task Factory previously. We hired Pragmatic Works for a consulting project and they owned the product at that time and implemented it in-house. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory None Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory It was here from a prior manager, no reason to change to something else. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory ZappySys is an alternative provider that we tested. However, we found the ease of use, set up and installation to be much simplier and quicker using Task Factory. ZappySys has a number of the same connectors but are more difficult to setup and the GUI is not as intuitive and … Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Task Factory does a fair job in terms of address parsing compared to COZYROC and also other variable features in terms connecting to CRM and SharePoint site. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory We wanted more ways to connect with other sources and Task Factory offer the best suited solution. Task Factory was also easier to integrate with our actual code base and was cheaper than the alternative. We were very satisfied with our choice and we recommend Task Factory to … Incentivized Helpful? JS John Stuchly Data Developer Chose SolarWinds Task Factory Cozyroc has a few more connectors, but Task Factory's focus on tasks is a better overall fit for us. ZappySys had some compelling features around web services which seemed a bit more robust, but that was not our primary interest at the time of purchase. Basically, all of … Incentivized Helpful? JH John C Hill Business Intelligence Manager Chose SolarWinds Task Factory n/a Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Dell Boomi, Informatica, Data Stage. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Since I used Task Factory earlier, I went for it. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Haven't performed a competitor analysis in 6 years. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory When we were doing research on if Task Factory was a viable option for us, we found that the large array of tasks that it offers and the low cost of all of it was much better than the competition. We found that we would have to buy a culmination of tools just to pull together … Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Task Factory is more than just components. It is more than just monitoring. It is an entire suite of tools for SSIS package development. And this is not a case of someone going wide but not going deep. Task Factory by Sentry One (formerly of Pragmatic Works) goes wide and deep. … Incentivized Helpful? PB Peter Berrens BI consultant Chose SolarWinds Task Factory Task Factory just has more options and tasks needed to run a fully automatic ETL. Incentivized Helpful? AR Al Rubel System Architect Chose SolarWinds Task Factory Cheaper and more flexible. Incentivized Helpful? Ryan Lundahl Senior Business Intelligence Analyst Chose SolarWinds Task Factory I haven't participated in any other evaluations because we had Task Factory when I started here. Incentivized Helpful? Luca Campanelli Senior Betting & Online DB Administrator Development Chose SolarWinds Task Factory No other product was considered because we knew we were safe with this product even when it was still Pragmatic Works (now Sentry One). Before using this product, we downloaded additional third-party tasks, some freeware, but a complete package like the one offered by sentry … Incentivized Helpful? Mickeal Davis Enterprise Architect Chose SolarWinds Task Factory We've only compared it to standard Microsoft, and we selected Task Factory after the 30-day trial. Incentivized Helpful? KC Kang Chen Advanced Data Architect Chose SolarWinds Task Factory It did a better on parsing XML/JSON data. Incentivized Helpful? Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Chose SolarWinds Task Factory Honestly, I had seen Task Factory being used in a previous shop, and when the need came up I went straight to them. Incentivized Helpful? EC Edward Chow Software Developer Chose SolarWinds Task Factory We have not considered other products. Incentivized Helpful? Karl Wiggins Director, IT Infrastructure & Operations Chose SolarWinds Task Factory CData Software was evaluated initially, and while we chose to go with Task Factory initially due to cost and simplicity, in the end we had to purchase CData's product anyway when Task Factory was not updated to work with Microsoft Dynamics 365 v. 9 for months after it was … Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory In the arena of SSIS extension products and services, Task Factory is a strong competitor and checks all of the boxes we needed to have checked at a very reasonable cost. Incentivized Helpful? SM Steve Mayer Technical Project Manager Chose SolarWinds Task Factory No others. Incentivized Helpful?

Features

dbt

SolarWinds Task Factory

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	dbt 9.7 Ratings 18% above category average	SolarWinds Task Factory 9.2 Ratings 13% above category average
Simple transformations	10.00 Ratings	8.70 Ratings
Complex transformations	9.50 Ratings	9.60 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	dbt 9.1 Ratings 15% above category average	SolarWinds Task Factory - Ratings
Data model creation	9.70 Ratings	00 Ratings
Metadata management	8.70 Ratings	00 Ratings
Business rules and workflow	9.00 Ratings	00 Ratings
Collaboration	10.00 Ratings	00 Ratings
Testing and debugging	8.00 Ratings	00 Ratings

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	dbt - Ratings	SolarWinds Task Factory 9.4 Ratings 12% above category average
Connect to traditional data sources	00 Ratings	9.40 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	dbt - Ratings	SolarWinds Task Factory 9.4 Ratings 16% above category average
Integration with data quality tools	00 Ratings	9.20 Ratings
Integration with MDM tools	00 Ratings	9.60 Ratings

Best Alternatives
	dbt	SolarWinds Task Factory
Small Businesses	Skyvia Score 10.0 out of 10	Skyvia Score 10.0 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	dbt	SolarWinds Task Factory
Likelihood to Recommend	10.0 (0 ratings)	8.1 (0 ratings)
Likelihood to Renew	- (0 ratings)	8.2 (0 ratings)
Usability	9.7 (0 ratings)	9.1 (0 ratings)
Support Rating	- (0 ratings)	9.1 (0 ratings)
Implementation Rating	- (0 ratings)	8.2 (0 ratings)

User Testimonials
	dbt	SolarWinds Task Factory
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. Incentivized Sahil Khan Data Analyst Read full review	Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time. Incentivized Nancy Petrey Business Analyst 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 Senior Data Engineer Read full review	The Slowly Changing Dimension Component saves us a huge amount if time compared to the native SSIS component. JSON Transform is really useful to convert record and send it to rest API. The advanced derived columns allow us to use really cool functions that are not available in the regular transforms. Incentivized Karl Blacquière Bi Architect 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 Incentivized Verified User Anonymous Read full review	It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress. Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions. Occasional random failures observed with the Filter tranform. Incentivized Verified User Anonymous Read full review
Likelihood to Renew	No answers on this topic	Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business Incentivized Verified User Anonymous 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. Incentivized SI Sid Iyer BizOps Read full review	Compared to some of the other transformations I have worked with, it really is pretty simple for the type of functionality you get Incentivized Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Read full review
Support Rating	No answers on this topic	Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues. Incentivized Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Read full review
Implementation Rating	No answers on this topic	Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us. Incentivized Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Read full review
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. Incentivized Verified User Anonymous Read full review	I've not found too many tools to bolt onto SSIS that encompass what you get with Task Factory. I have used some Enterprise ETL tools like Dell's Boomi, but did not find it to be very intuitive. Task Factory does not leave you guessing how to use its components. Additionally, their support is very responsive and helpful. Incentivized FC Frank Coulter Database Operations Manager 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. Incentivized Judy Campion Data Architect Read full review	We were able to support our developers with Task Factory features and reduce the development time by 40%. Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward. Incentivized Verified User Anonymous Read full review
ScreenShots		SolarWinds Task Factory Screenshots