Aqua Data Studio is a database integrated development environment supporting multiple types of databases, such as relational, noSQL and cloud databases. Just in the case of relational databases, there is a wide array of supported types, including, but not limited to, MySQL, Oracle, Microsoft SQL Server, Sybase, DB2, Informix, Apache Cassandra, PostgreSQL, Derby and Hive, MongoDB, and SQLite. It has the main advantage of being scalable and having no limitations as to the number of databases it can connect to.
The application's interface is modern and conveniently lets you organize all your database servers and schemas in a tree view. Thus, it facilitates navigating through all the assets. However, there are times I wished there were more wizards, because the tool has some many features that it is quite easy to get lost.
It is great that Aqua Data Studio lets you explore and analyze data through various types of visual representations and dashboards. These items can easily be exported as worksheets, which allows sharing them with other users.
If you do not feel comfortable writing SQL statements, you will probably find very convenient that Aqua Data Studio comes with a built-in visual query builder. This way, you just need to drag and drop the items without writing a single line of code. Likewise, there is a query analyzer, which can insert SQL statements in the code automatically. The application also comes in very handy for debugging SQL. In this respect, it comes with built-in debuggers that support Oracle, Microsoft SQL Server, Sybase ASE and IBM.
Aqua Data Studio helps you reverse engineer existing database thanks to its Entity Relationship Modeler. This tool allows building and managing entity relationship diagrams as well as physical database models. This way, you can reconstruct the database structure through its graphical representation. Again, most relational database types are supported.
All in all, Aqua Data Studio is definitely one of the most versatile database integrated development environments around. It supports connecting to practically any type of database to perform administration, comparison, synchronization and design tasks. The product is actually not very affordable, so you may want to really know if it works for you before spending your money on it. Luckily, it can be tried at no cost.
- Extremely versatile and scalable
- Supports practically all types of databases
- No limits as to the number of databases you can connect to
- Organizes database servers and schemas in a tree view
- Visual representations and dashboards
- Helps you write and debug SQL
- Powerful entity relationship modeler
- Difficult to navigate through all its features at times
- It is Java-based, which may affect performance