Navicat Premium Reviews

2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.5 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-2 of 2)

Maurice Samuels | TrustRadius Reviewer
January 29, 2020

Navicat Premium: Better than advertised, almost better than OEM

Score 7 out of 10
Vetted Review
Verified User
Review Source
The Navicat monitor sub-application is being used to monitor various cloud databases and MySQL. OEM required too much patching and another software alternative was needed to accomplish monitoring heterogenous databases. Ease of connectivity was a requirement also, and Navicat monitoring being accessible via standard html met that requirement. Most features were identical to OEM (alert notification, performance monitoring, etc).
  • Access via standard html
  • Alert notification
  • Remote deploy databases
  • Clone databases
Very complimentary features to Oracle Enterprise Manager make Navicat Premium very easy to use and navigate. Some very important features are missing, like online replication and disaster recovery deployment and configuration. Robust language support is available too without large i/o overheard for multibyte language sets. No SQL database support has been added and assists with HIVE and large data set management.
Read Maurice Samuels's full review
Benjamin Plotkin | TrustRadius Reviewer
June 28, 2019

Navicat Premium: The Cat's Pajamas for Erstwhile Database Admins

Score 8 out of 10
Vetted Review
Verified User
Review Source
Navicat Premium is the go-to database development tool used in my organization (Student Affairs IT). It is a cost-effective tool that enables staffers to query our on-premises and cloud-based databases (Oracle and MySQL as of this writing) for extraction and reporting purposes, as well as supporting database audits, schema modifications, and granular editing of table rows for maintenance, troubleshooting, and extension of our web applications.
  • Navicat Premium is a great tool for managing multiple different database connections, as it supports a wide variety of database systems, including MariaDB, MySQL, Oracle, PostgreSQL, SQL Server, and SQLite databases. Credentials and network information are easily configured and stored for multiple connections.
  • Navicat Premium allows users to define and store queries for reuse, and it supports advanced job scheduling options, allowing the construction and invocation of singular and batched jobs. I use these features to run periodic schema audits on data warehouse tables to ensure our department's data dictionary remains accurate.
  • Navicat Premium provides a robust data browser view that allows users who are not SQL experts to quickly and easily filter datasets, and directly add, update, and delete table rows.
  • Navicat Premium's documentation can be hit-or-miss, as there are several versions available, and it's not always clear which documentation is current for the version at hand.
  • Navicat Premium's query building interface is not as easy to use or feature-rich as standard IDE and text editor tools, and I've had some issues in the most recent release build with queries auto-running in the middle of making edits, causing a lack of responsiveness in the inbuilt editor -- however, Navicat offers users the ability to edit queries via an external editor, which mitigates these issues to some degree.
  • In the data browser view, paged data navigation sometimes behaves unexpectedly or fails to work whatsoever, requiring a session restart to correct.
  • The process of saving a data export file is cumbersome, requiring navigation through several windows, and I believe it could be significantly streamlined to improve user experience.
Navicat Premium is a very well-rounded tool with a reasonable licensing fee given its feature set. It is primarily suited for technical resources who must work with a variety of different database systems, but who may not be database or command line tool wizards. However, its query building and job batch scheduling feature support end-users as they build competency, and it continues to hold its value even as users outgrow their training wheels.
Navicat is probably not so appropriate for DBAs and others for whom database development and management is already a career path; these folks have their preferred toolsets, both vendor-supplied and homegrown, and they might consider the additional licensing cost to outweigh the value they'd personally get out of Navicat.
Read Benjamin Plotkin's full review

Feature Scorecard Summary

Version control tools (1)
7
Test data generation (1)
7
Performance optimization tools (1)
8
Schema maintenance (2)
8.5
Database change management (2)
7.4
User management (2)
8.5
Database security (2)
8.5
Database status reporting (1)
7
Change management (2)
7.5

About Navicat Premium

Navicat Premium is a multi-connection database development and administration tool which can simultaneously connect 7 databases (MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite) from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas and Huawei Cloud, developerws can quickly and easily build, manage and maintain databases.
Categories:  Database Management

Navicat Premium Technical Details

Operating Systems: Unspecified
Mobile Application:No