DbVisualizer

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.

• Faster access to more typically “web-based” data, like BigQuery, for more rapid prototyping and exploration.
• Parameterized queries in SQL Commander have become our go-to for getting fast answers to common questions about our data.

SQL Server Management Studio (SSMS)

Google BigQuery, PostgreSQL, Apache Hadoop, MySQL, Db2

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.

• Saves me time every day
• Presents complex data tasks in a way the give me certainty that I am handling it in the correct way, not missing essential details.

Oracle SQL Developer, MySQL Workbench and DBeaver

Eclipse, LibreOffice, Fedora Linux

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.

• Faster analytics
• Faster data engineering development

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.

• It allows us to query databases without paying extra for proprietary tools or worrying about licensing.
• It is one tool that replaced several others.
• We need to build know-how for only one tool, not several, so developers can spend their time working rather than figuring out other tools.
• We need more licenses than we have developers. A 'per person' licence or a 'per install' licence would be great.

DBeaver and Toad Database Developer Tools

pgAdmin, IntelliJ IDEA, Eclipse, Apache Tomcat

I need to routintely check data in Oracle, DB2, Cassandra databases

• I am a developer so cannot really comment on specific ROI. But my general consensus is that the licence is worth the money I pay for as a freelancer to provide a more efficient and useful service to my clients

Oracle SQL Developer

IDEA, Postman, Docker