DbSchema vs. SolarWinds Task Factory

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
DbSchema
Score 8.0 out of 10
N/A
N/AN/A
SolarWinds Task Factory
Score 8.2 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
DbSchemaSolarWinds 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
DbSchemaSolarWinds Task Factory
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
DbSchemaSolarWinds Task Factory
Considered Both Products
DbSchema
SolarWinds Task Factory
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.
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.
Chose SolarWinds Task Factory
It was here from a prior manager, no reason to change to something else.
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 …
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.
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 …
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 …
Chose SolarWinds Task Factory
Dell Boomi, Informatica, Data Stage.
Chose SolarWinds Task Factory
Since I used Task Factory earlier, I went for it.
Chose SolarWinds Task Factory
Haven't performed a competitor analysis in 6 years.
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 …
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. …
Chose SolarWinds Task Factory
I haven't participated in any other evaluations because we had Task Factory when I started here.
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 …
Chose SolarWinds Task Factory
We've only compared it to standard Microsoft, and we selected Task Factory after the 30-day trial.
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 …
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.
Features
DbSchemaSolarWinds Task Factory
Database Development
Comparison of Database Development features of Product A and Product B
DbSchema
7.0
Ratings
20% below category average
SolarWinds Task Factory
-
Ratings
Version control tools7.00 Ratings00 Ratings
Test data generation10.00 Ratings00 Ratings
Performance optimization tools3.00 Ratings00 Ratings
Schema maintenance9.00 Ratings00 Ratings
Database change management6.00 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
DbSchema
5.0
Ratings
51% below category average
SolarWinds Task Factory
-
Ratings
User management5.00 Ratings00 Ratings
Database security5.00 Ratings00 Ratings
Change management5.00 Ratings00 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
DbSchema
-
Ratings
SolarWinds Task Factory
9.4
Ratings
11% above category average
Connect to traditional data sources00 Ratings9.40 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
DbSchema
-
Ratings
SolarWinds Task Factory
9.2
Ratings
12% above category average
Simple transformations00 Ratings8.70 Ratings
Complex transformations00 Ratings9.60 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
DbSchema
-
Ratings
SolarWinds Task Factory
9.4
Ratings
15% above category average
Integration with data quality tools00 Ratings9.20 Ratings
Integration with MDM tools00 Ratings9.60 Ratings
Best Alternatives
DbSchemaSolarWinds Task Factory
Small Businesses
DBeaver
DBeaver
Score 9.2 out of 10
Skyvia
Skyvia
Score 9.9 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 9.2 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
DBeaver
DBeaver
Score 9.2 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
DbSchemaSolarWinds Task Factory
Likelihood to Recommend
8.0
(0 ratings)
8.1
(0 ratings)
Likelihood to Renew
-
(0 ratings)
8.2
(0 ratings)
Usability
8.0
(0 ratings)
9.1
(0 ratings)
Support Rating
-
(0 ratings)
9.1
(0 ratings)
Implementation Rating
-
(0 ratings)
8.2
(0 ratings)
User Testimonials
DbSchemaSolarWinds Task Factory
Likelihood to Recommend
Well suited to a team working directly in the physical modeling space.
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.
Read full review
Pros
  • Many database platforms supported
  • Direct database integration - option to have model actions reflected immediately in database.
  • Test data generation with Groovy scripting for control over specific profiles
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.
Read full review
Cons
  • Logical data model integration is weak. Need way to update existing models with changes
  • Conceptual data modeling is missing
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.
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
Read full review
Usability
DbSchema does a number of things very well, but is not as full featured as many customers will want
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
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.
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.
Read full review
Alternatives Considered
Some of the other Tools are no longer supported, and DbSchema is much less expensive than most of them.
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.
Read full review
Return on Investment
  • DbSchema is very inexpensive, and functional, so easy to get a team started
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.
Read full review
ScreenShots

SolarWinds Task Factory Screenshots

Screenshot of Salesforce.com SourceScreenshot of Dimension Merge SCD TransformScreenshot of Upsert DestinationScreenshot of REST Source