DbVisualizer vs. SolarWinds Task Factory

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
DbVisualizer
Score 8.9 out of 10
N/A
DbVisualizer is a multi-database tool for developers, analysts and database administrators, providing a single interface across a wide variety of operating systems. Boasting an easy-to-use and clean interface, DbVisualizer runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
$0
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
DbVisualizerSolarWinds Task Factory
Editions & Modules
DbVisualizer Free
$0
DbVisualizer Pro with Basic support - Renewal
$89
per year per user
DbVisualizer Pro with Premium support - Renewal
$119
per year per user
DbVisualizer Pro with Basic support
$199
per year per user
DbVisualizer Pro with Premium support
$229
per year per user
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
DbVisualizerSolarWinds Task Factory
Free Trial
YesYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeOptionalNo setup fee
Additional DetailsNew license cost includes a perpetual license, software upgrades and support for the length of the term. 1, 2 & 3 year terms are offered. Once license expires the user may access all Pro versions released before the license expiry indefinitely. To gain access to Pro versions released after the license expired, license renewal is offered. Volume discounts apply to both new and renewal licenses.
More Pricing Information
Community Pulse
DbVisualizerSolarWinds Task Factory
Features
DbVisualizerSolarWinds Task Factory
Database Development
Comparison of Database Development features of Product A and Product B
DbVisualizer
7.8
47 Ratings
8% below category average
SolarWinds Task Factory
-
Ratings
Performance optimization tools7.542 Ratings00 Ratings
Schema maintenance8.144 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
DbVisualizer
7.4
34 Ratings
8% below category average
SolarWinds Task Factory
-
Ratings
User management7.931 Ratings00 Ratings
Database security7.325 Ratings00 Ratings
Database status reporting7.125 Ratings00 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
DbVisualizer
-
Ratings
SolarWinds Task Factory
9.4
40 Ratings
14% above category average
Connect to traditional data sources00 Ratings9.440 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
DbVisualizer
-
Ratings
SolarWinds Task Factory
9.2
39 Ratings
14% above category average
Simple transformations00 Ratings8.739 Ratings
Complex transformations00 Ratings9.635 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
DbVisualizer
-
Ratings
SolarWinds Task Factory
9.4
3 Ratings
17% above category average
Integration with data quality tools00 Ratings9.22 Ratings
Integration with MDM tools00 Ratings9.63 Ratings
Best Alternatives
DbVisualizerSolarWinds Task Factory
Small Businesses
DBeaver
DBeaver
Score 8.4 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 8.4 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
DBeaver
DBeaver
Score 8.4 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
DbVisualizerSolarWinds Task Factory
Likelihood to Recommend
8.8
(53 ratings)
8.1
(40 ratings)
Likelihood to Renew
9.1
(3 ratings)
8.2
(3 ratings)
Usability
8.3
(23 ratings)
9.1
(1 ratings)
Support Rating
9.1
(2 ratings)
9.1
(1 ratings)
Implementation Rating
8.6
(2 ratings)
8.2
(1 ratings)
User Testimonials
DbVisualizerSolarWinds Task Factory
Likelihood to Recommend
DbVis Software AB
Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.
Read full review
SolarWinds
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
DbVis Software AB
  • Out-of-the-box support for many different databases.
  • Intuitive UI for interacting with data.
  • Flexibility of SQL Commander for writing scripts.
  • Great support for working with JSON data in recent updates.
  • Database connections over SSH.
  • Table relationship visualization is very helpful.
  • The tree view is well organized in how it splits out schemas.
Read full review
SolarWinds
  • The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities.
  • Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components.
  • The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.
Read full review
Cons
DbVis Software AB
  • Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
  • Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
  • (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)
Read full review
SolarWinds
  • 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
DbVis Software AB
We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.
Read full review
SolarWinds
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
DbVis Software AB
I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.
Read full review
SolarWinds
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
DbVis Software AB
Never used
Read full review
SolarWinds
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
DbVis Software AB
No answers on this topic
SolarWinds
Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us.
Read full review
Alternatives Considered
DbVis Software AB
[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.
Read full review
SolarWinds
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 simple to use.
Read full review
Return on Investment
DbVis Software AB
  • Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
  • Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
  • Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily
Read full review
SolarWinds
  • 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

DbVisualizer Screenshots

Screenshot of Screenshot of SQL formattingScreenshot of ERD diagramScreenshot of Auto completeScreenshot of Database connectionScreenshot of Database connection

SolarWinds Task Factory Screenshots

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