TrustRadius Insights for DbVisualizer are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Business Problems Solved
DbVisualizer is a powerful tool that users rely on for a wide range of data management and analysis tasks. With its ability to connect to various data sources, such as Oracle, Informix, and DB2, DbVisualizer eliminates the need for multiple IDEs, providing a seamless experience for users. The software's easy and presentable ER diagram generation has been highly regarded by users, making it an invaluable tool for technical documentation.
DbVisualizer supports a wide range of databases, including Postgres, SQLite, MySQL, and Oracle, making it a versatile choice for users. Its cross-platform compatibility allows for seamless usage on different operating systems like MAC. Users express satisfaction with DbVisualizer as it meets their requirements and expectations after years of research. They appreciate its all-in-one nature, as it allows them to write queries, manage databases, and perform initial data loads.
DbVisualizer's ability to query databases and analyze SQL costs, regardless of the brand of the database, is also praised by users. It has proven to be an indispensable tool for developers, data engineers, data scientists, and data analysts alike. With its simple interface, DbVisualizer enables users to view data subsets efficiently, analyze data structures effectively, and track down issues seamlessly. Furthermore, the software's wide support for different database systems like MySQL, Postgres, and SQLite contributes to its popularity among users.
Overall, DbVisualizer is widely used across various industries and departments for tasks ranging from query development to data analysis and visualization. Users value its reliability and performance in accessing databases and performing crucial data-related tasks. With its extensive features and capability to handle structured data tasks across a variety of databases, DbVisualizer has solidified its position as a go-to tool for managing and administering databases in production environments.
We use dbvis to test database connections during the installation of our product on customers' servers. This lets us verify that a connection is not 'lost' on the way to the database. As we use JDBC as our primary connection method, DBIS provides an easy, additional, and independent way to test the connection. We use dbvis to check stored data, review table structures and metadata (e.g., when selects or inserts fail), and verify table permissions for the user who is having connection issues. We love the in-cell data editing feature, which is much easier than building SQL queries for every entry. This also allows a quick manual review of the stored data, even with large tables, and fixes the most obvious errors instantly. We test, build, and also 'deconstruct' SQL queries when there is a need to check on long-running queries. This helps us identify, for example, misused indices and other issues. We use it to easily export complete tables and data for a wide variety of DBMS for our customers and ourselves. It helps us visualize relationships and identify faults that are often not obvious within our codebase.
Pros
Easy visualize Db-data.
Connect to a wide range of Dbms.
Ease of data manipulation.
Managing a great number of different Db-connections.
Work with big queries.
Cons
Support for troubleshooting on a Dbms level.
Automatically suggest syntax differences with different Dbms.
Sharing of Db connections.
Startup time.
Likelihood to Recommend
DbVis is our tool of choice when we need to work with a wide variety of Db vendors and versions. It allows us to replace several proprietary tools for accessing and, in part, managing database systems. It gives our customers and us a single base to work on databases. No need for us or them to install, learn, and pay for multiple solutions. If one would, for example, use ONLY one dbms, e.g., PostgreSQL, then DBVis could be a bit of an overkill.
VU
Verified User
Employee in Information Technology (1-10 employees)
I have installed DbVisualizer and used it first time. It is a great experience. All type of databases you can connect. Like if you have SQL Server. Informix, Vertica. You name the database. You can connect it in DbVisualizer. That is why i have purchased it and using its pro license. Thanks for such an application.
Pros
Every database connector
visually appealling
SQL History
Cons
you should allow more tabs in free license.
auto commit option should not be there
Likelihood to Recommend
DbVisualizer is best when you are working with multiple databases. And you need to connect all the databases parallely same time.
VU
Verified User
Employee in Information Technology (201-500 employees)
We’re a digital marketing agency with a large data warehouse that uses multiple databases, and we interact with many database types and integrations for our own needs as well as those of our clients. DbVisualizer makes this very simple with easy integrations to every type of database we’ve needed to connect to, with a fantastic UI that makes working across databases easy and all in one spot.
Pros
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.
Cons
Would be great if we could update individual JSONB properties directly in the JSON viewer window.
Sometimes, when a table structure is changed (e.g., adding columns), the changes are not reflected when viewing the table because the old structure is still cached.
Likelihood to Recommend
It has been immensely helpful for data exploration in relational databases. SQL Commander is very capable (and scriptable) for quickly investigating data and testing queries.
I perform Data Engineering with DbVisualizer to power our the analytics of our entire company. The product is great for not only that, but also writing ad hoc queries and doing deep analytics. Its easy to export data into Excel and also add/update rows or values within the tool without needing to write the UPDATE statement yourself. Its easy to use and I recommend it to anyone looking for a nice IDE.
Pros
Export to Excel
Object navigation
DDL viewing
Cons
The Excel export sometimes bugs out
Likelihood to Recommend
Anyone who needs to connect to a database to either run queries or perform data engineering can benefit from DbVisualizer. The only time someone wouldn't benefit is if they're working from a canned Excel or Tableau workbook with an embedded data source they can't change.
I need to routintely check data in Oracle, DB2, Cassandra databases
Pros
love the ability to edit data in cells like a spreadsheet
organising all my connections in to folders and marking them as prod with yellow and black stripes
the filters so I can hide database objects that I am not interested in
Cons
I would like to see the "References" tab and its functionality expanded to allow it become even more powerful to support documentation requirements
Likelihood to Recommend
In my organisation people use SQL Developer but I prefer DbVisualizer because it is DB agnostic and therefore all of my DB work can be centralised in one GUI.
As a software developer I build and support products with many different types of database connections. DbVisualizer gives me one coherent workspace to work with a wide variety of data sources that support SQL. And it runs in exactly the same way across different operating systems.
Pros
SQL intellisense
Exports to spreadsheets
Data editing in tables
Graphical table altering
Remote connections via SSH
Cons
Nothing
Likelihood to Recommend
If the colleague works with SQL I will recommend DbVisualizer anytime. For colleagues who are not comfortable working with SQL I am not so sure.
@ TECASSURED we are a software plateform provider - our ADMIN system solution provides each client with 2 database priority to their instance. We manage 1000's of database with this DbVisualizer - awesome solution - happy customer for over 20 years. ;)
Pros
Manage multi database connection
drag and drop SQL statements
reporting
Cons
Quicker start up
scheduler to run Monitors/Files
Email from application
Likelihood to Recommend
With my knowledge and needs it is best solution I have found - very robust may be to confusing for general needs I.E. phpAdmin
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.
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)
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.
VU
Verified User
Consultant in Finance and Accounting (10,001+ employees)
We use it to request our ERP, select and update, for reporting and error correction, daily with 11 users. As an insurance broker, our data are a critical thing, we also use DbVisualizer to planify requests during the night, we hope DbVisualizer will contain a scheduler in a later version.
Pros
batch
interactive
Cons
integrated scheduler
impossible to close other tabs in the actual version !!
Likelihood to Recommend
Good for editing datas in a grid Good for newbies and non-IT people
VU
Verified User
Project Manager in Information Technology (11-50 employees)