Average Ratings 0 Ratings
Average Ratings 2 Ratings
Description
AQT is a multi-database query and admin tool designed for DBAs, database developers and data analysts.
AQT uses a native ODBC interface that runs reliably and efficiently against databases of all sizes. It has been specifically customized for over 30 dufferent database types and displays more information about your database than any other product on the market.
It is in use in a large number of sites running DB2 z/OS and many customers have commented that it is by far the best product with that database. But not just DB2 z/OS, but also Oracle, SQL Server, MySQL, PostgreSQL and others.
Data analysts will enjoy the SQL editor, SQL history, graphical query builder, table editor, data export and charting features.
DBAs and developers will be delighted with generate DDL, object compare/resync, data compare/resync, data loader, create/alter/manage objects, visual explain and system monitor.
Description
Introducing DataGrip, a cutting-edge database integrated development environment designed specifically for the needs of SQL professionals. This tool allows for executing queries in various modes while maintaining a local history that safeguards your work by tracking all activities. Users can effortlessly navigate to any table, view, or procedure by name through specific actions or directly from their usages within SQL code. Additionally, DataGrip offers in-depth insights into the performance of your queries and the behavior of the database engine, enabling you to optimize your queries for better efficiency. With context-sensitive code completion, writing SQL becomes a faster process, as the feature is aware of the structure of tables, foreign keys, and database objects within the code you are currently working on. The IDE also identifies potential errors in your code and provides immediate suggestions for fixes, ensuring a smoother coding experience. Moreover, it promptly notifies you about any unresolved objects, utilizing keywords as identifiers while consistently offering solutions to rectify issues that arise. This combination of features makes DataGrip an invaluable tool for developers aiming to enhance their productivity and code quality.
API Access
Has API
No
API Access
Has API
No
Integrations
Greenplum
Yes
IBM Db2
Yes
MariaDB
Yes
MySQL
Yes
Oracle Database
Yes
PostgreSQL
Yes
SQL Server
Yes
SQLite
Yes
Snowflake
Yes
Apache Derby
No
Integrations
Greenplum
Yes
IBM Db2
Yes
MariaDB
Yes
MySQL
Yes
Oracle Database
Yes
PostgreSQL
Yes
SQL Server
Yes
SQLite
Yes
Snowflake
Yes
Apache Derby
Yes
Pricing Details
$210 one-time payment
$210 - Standard Edition
$420 - Extended Edition
$420 - Extended Edition
Free Trial
Yes
Free Version
No
Pricing Details
$199 per year
Free Trial
Yes
Free Version
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
Yes
Vendor Details
Company Name
Cardett Associates Ltd
Founded
1999
Country
New Zealand
Website
www.querytool.com/index.html
Vendor Details
Company Name
JetBrains
Founded
2000
Country
Czech Republic
Website
www.jetbrains.com/datagrip/
Product Features
Database
Backup and Recovery
No
Creation / Development
Yes
Data Migration
Yes
Data Replication
Yes
Data Search
Yes
Data Security
Yes
Database Conversion
Yes
Mobile Access
No
Monitoring
Yes
NOSQL
No
Performance Analysis
Yes
Queries
Yes
Relational Interface
Yes
Virtualization
No
Product Features
Code Editors
API
No
Auto-Complete
No
Code Folding
No
Column Editing
No
Customizable Themes
No
Debugging
No
Formatting / Table Editing
No
Keyboard Shortcuts
No
Multi-Monitor Editing
No
Syntax Highlighting
No
WYSIWYG
No
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No
IDE
Code Completion
No
Compiler
No
Cross Platform Support
No
Debugger
No
Drag and Drop UI
No
Integrations and Plugins
No
Multi Language Support
No
Project Management
No
Text Editor / Code Editor
No