Item: DbVisualizer
Rating: 10
Author: Verified User

Overall Satisfaction with DbVisualizer

Use Cases and Deployment Scope

The product I am in charge of requires data from 6 different sources across a handful of different driver types to run monthly processes. DbVis allows my analysts & me to have access to all sources in one convenient program.

Pros and Cons

Pros

Supports numerous drivers (Snowflake, SQL Server, Teradata, Hive, DB2, etc.)
Allows for full data set to be extracted (no forced row limits/"sample data" pull before the actual pull)
Customizable settings for font colors, processing capacity

Cons

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)

Return on Investment

The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"

Usability

DbVis has the right balance of user-friendly interface (that makes it easy to set up connections as a beginner) & customizable capabilities for more advanced purposes within the various Tools/Settings menus.

Alternatives Considered

DBeaver and SQL Server Management Studio (SSMS)

SSMS is fabulous for databases with an on-prem SQL Server driver, but not very helpful with anything else. I loathe DBeaver. It runs your query once for a "sample"... and even if that sample took 45 minutes to pull, it'll run the query AGAIN for 45 minutes to show you your full data set. Just infuriating. DbVis spares me from the horrors of DBeaver.

Key Insights

Do you think DbVisualizer delivers good value for the price?

Yes

Are you happy with DbVisualizer's feature set?

Yes

Did DbVisualizer live up to sales and marketing promises?

Yes

Did implementation of DbVisualizer go as expected?

Yes

Would you buy DbVisualizer again?

Yes

Other Software Used

SQL Server Management Studio (SSMS), SAS Enterprise Guide, DBeaver

Likelihood to Recommend

DbVisualizer is most helpful for our team because it allows us (under my Pro license) to have multiple tabs open running different code simultaneously from different platforms. Other than the lack of upload capability (or lack of knowledge of that capability on my part), there isn't much I'd choose other tools for over DbVis.

DbVisualizer Feature Ratings

Comments

Please log in to join the conversation

Ol' Reliable