Great tool to work with multiple DB engines
April 21, 2022

Great tool to work with multiple DB engines

Lisandro Fernigrini | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with DbVisualizer

Since we develop ETL from many different data sources, we use DbVisualizer to connect to different sources using Oracle, Informix, or DB2 as database engines. Having a single tool to access any of the different data sources allows us to quickly connect and query source systems, debug SQL sentences, or verify data without installing (and learning to use) multiple IDEs.
  • Ability to connect to MANY!!!!! different database engines on a single IDE
  • Create, alter or drop objects on any data source
  • Ability to export / import data to multiple formats
  • Reverse engineering / Data Model visualization
  • The free version only allows 1 SQL tab (could be a little more generous on that) opened at the same time
  • Unified IDE to access multiple data sources
  • Currently using free version for most users so no cost at all
  • Runs on any platform (Windows, Mac, Linux)
  • Maintaining multiple data sources using a single, unified IDE reduces learning time
  • Less time to develop and execute queries
Although it may not have engine-specific features that SQL Developer or Management Studio have (or any other specific client IDE), most regular tasks can be achieved from DbVisualizer no matter the database you are connecting to. This reduces the learning curve for most developers that need to work with multiple database engines.

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

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.

DbVisualizer Feature Ratings

Performance optimization tools
8
Schema maintenance
9
User management
8
Database security
8
Database status reporting
8

Using DbVisualizer

5 - Mostly ETL developers need to connect to multiple data sources. DBA teams also use them for simple tasks while using specific engine clients for more advanced tasks.
No need to provide any additional support. It is a client-side tool that is very easy to install and configure
  • Simplify access to multiple data sources from a single IDE
We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

Using DbVisualizer

Menus are simple and well organized. You can use the same shortcuts no matter which database engine you are connecting to. Configuration of data source connections is simple while keeping all required options.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • Data Model Visualization
  • Reviewing execution plan and other performance related tasks