Advanced Query Tool Reviews & Product Details

Advanced Query Tool can be used to connect to any ODBC Database which are commonly used nowadays example oracle, mysql, postgre. It provides a very interactive UI to work with database DML, DDL operations, data and objects compare etc. Review collected by and hosted on G2.com.

Nothing I can think of now. I think it has a complete package for my uses. Review collected by and hosted on G2.com.

The best thing about AQT is that it allows me to search for columns and contents of the database, which makes it much easier to find the right tables and views. Review collected by and hosted on G2.com.

There's not much not to like here. The tool works fine, sometimes it takes a while to load information but that's just because our data warehouse is that big and sometimes the connection is slow. Review collected by and hosted on G2.com.

It has a lot of user-friendly options, where one can easily edit the data with the edit option, and while writing the query, it shows some smart options where the column name pops up, which makes the work easier, and there is an option to retrieve your old queries. Review collected by and hosted on G2.com.

When you fetch more than 5000 rows...if you press a cancel option while displaying, AQT hangs completely and you need to start from the beginning. Review collected by and hosted on G2.com.

I've been using AQT for over 15 years and found it to be the best tool for my role as a data warehouse architect and data analyst in multiple database environments. There are many capabilities for point and click data analysis, queries creation, loading and exporting data. My favorites include 1) a point and click data loader that generates your create table statement when creating a new table and includes the ability to add column expressions to alter/clean your source data during the load, 2) a visual data explorer to view your SQL result set and easily total, sort, format, and group it (grouping is done by dragging columns to the header and groups can easily be collapsed/expanded and show column subtotals); You can also freeze columns on the left for easy viewing of wide result sets, copy any row or rows to Excel or other tools including column headings and get totals by highlighting adjacent columns, 3) a robust visual query builder that has the ability to easily create SQL including complex sub-queries, supports with clauses and can save your table relationships for re-use and 4) built-in scripting to easily automate repetitive processes like regression testing. An advanced version also includes a base set of database administration tools. Review collected by and hosted on G2.com.

The only thing that I dislike is the limits on identification of SQL errors because of ODBC limitations. Query tools that use native drivers instead of ODBC, for example SQL Developer, can identify more detail about SQL syntax errors. Review collected by and hosted on G2.com.

We have been using AQT at my company for many years, mainly with DB2 z/OS - but with many other databases as well. Hands down it beats all other SQL tools, and its abilities to manage tables, views, table spaces, indexes and other objects in DB2 REALLY put it a cut above. Search around for SQL/database Tools for DB2 z/OS ans see what you find from anyone other than IBM - you wont find much at all. And IBM itself has nothing to compare. Even if used as a pure SQL query tool, its abilities to manipulate the data AFTER you retrieve it from the database are amazing. It also has one fo thebest interfaces with Excel, to output the data, that I have seen.

No, I am not being paid to write this! We have over 300 people using AQT and wouldn't trade it for anything. Review collected by and hosted on G2.com.

Sometimes the licensing, particularly the "registering" of the license with the vendor can be a little bit clunky. Review collected by and hosted on G2.com.

The user interface makes it easy and quick to see all the most relevant information. I can filter the lists of tables/views/schemas, quickly see indexes, keys, constraints, columns, and data without wasting time. It performs all the tasks I need day to day without a lot of hassle and is very configurable. The author is quick to respond to and correct issues. Review collected by and hosted on G2.com.

I wish it could save all open query windows with a single mouse click and then reopen all of them upon reopening the program. The data import can be slow for large datasets, so I often resort to BCP to perform those imports. Review collected by and hosted on G2.com.

I use the tool mainly for administration of DB2 z/OS and LUW installations of various release levels. Navigation is very intuitive and super fast. Best I ever experienced with DB2. The many text and SQL generation tools are a great help. The Compare feature is amazingly flexible. Apart from the task of setting Automatic Maintenance (like maintenance window, task scheduler) or extensive mainframe schema change, the tool brings all what I need for my day-to-day tasks, and that has been true for the last 15 years. And if you miss something, or if you spot a flaw in the display or catalog queries, you simply write a mail to the AQT team and they fix it within a few days, or you fix it yourself in the configuration file (which is open and easy to understand). I love the feature that opens a session with the database host to run DB2 commands. Review collected by and hosted on G2.com.

Sometimes - especially after DBMS release changes - the DDL generator is not able to resolve new default values. But as mentioned, you can address it and it gets fixed quickly. I would love to have the DB2 Visual Explain graphical representation integrated into the tool. The existing Explain feature works fine, but with more complex SQL the many lines of output are hard to read. A picture would help. What I would like to have is a generator that generates text based on the result of an SQL. Of course, you can write this SQL yourself, but it would be nice to have a screen for it, like the Generate Text Screen. This one only allows generating text based on listing in the middle grid, which you can easily filter. But, generating text based on self-written, more complex SQL is currently not available in the tool (to my knowledge). For heavy Stored Procedure development the tool is not sophisticated enough when it comes to bind parameters, environment settings etc. If you develop light-weight SPs for administration or simple applications, the tool provides all you need. Review collected by and hosted on G2.com.

I have been using AQT for over 10 years now, and I prefer it over the other bloated tools on the market, including IBM's and Oracle's own products to connect to their own databases. AQT can connect to most of the RDBMS's and presents a familiar interface, so you don't have to worry about losing functionality between databases. Their customer service is also fast and reliable. Review collected by and hosted on G2.com.

Nothing that I can think of apart from some minor things which I think could use improvement in a future release. Review collected by and hosted on G2.com.