SQLAlchemy vs. SolarWinds Task Factory

SQLAlchemy

SolarWinds Task Factory

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
SQLAlchemy	Score 0.0 out of 10	N/A	SQLAlchemy is a Python SQL Toolkit and Object Relational Mapper that gives application developers the power and flexibility of SQL. It provides a suite of enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. SQLAlchemy is available free and open source under the MIT License.	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

SQLAlchemy

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
SQLAlchemy	SolarWinds Task Factory
Free Trial
No	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
	SQLAlchemy	SolarWinds Task Factory
Considered Both Products	SQLAlchemy No answer on this topic	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

SQLAlchemy

SolarWinds Task Factory

Data Source Connection

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

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	SQLAlchemy - Ratings	SolarWinds Task Factory 9.2 Ratings 13% above category average
Simple transformations	00 Ratings	8.70 Ratings
Complex transformations	00 Ratings	9.60 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	SQLAlchemy - 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
	SQLAlchemy	SolarWinds Task Factory
Small Businesses	DBeaver Score 8.5 out of 10	Skyvia Score 10.0 out of 10
Medium-sized Companies	DBeaver Score 8.5 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
Enterprises	DBeaver Score 8.5 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
All Alternatives	View all alternatives	View all alternatives

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

User Testimonials
	SQLAlchemy	SolarWinds Task Factory
Likelihood to Recommend	No answers on this topic	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	No answers on this topic	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	No answers on this topic	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	No answers on this topic	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	No answers on this topic	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	No answers on this topic	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