Advanced Query Tool Reviews & Product Details

In AQT the best thing is it is easily integrated with many database mangement systems with out much trouble and has good support from their support team Review collected by and hosted on G2.com.

Could you not find any major hicupps for my use cases Review collected by and hosted on G2.com.

Advanced Query Tool can be used to connect to any ODBC Database which are commonely used now a days example oracle, mysql, postgrey. It provide 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 complete package for my uses. Review collected by and hosted on G2.com.

It has lot of user-friendly options,where in easily one can edit the data with edit option and while writing the query it shows some smart options where in column name pops-up, which makes the work easier,and there is 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 enviroments. 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 to for easy viewing of wide result sets, copy any row or rows to excel or other tool 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.