Essentials Standard Enterprise

Feature Matrix

  Essentials Standard Enterprise
Connection
Oracle 8.1 or above ( macOS Edition starts from Oracle 9i )
Amazon RDS, Oracle Cloud
Secure connection: SSH
Export/import connection settings
Navicat Cloud
Collaboration: create projects, add members
Synchronize connections and queries
Synchronize models
Synchronize virtual groups
Data Viewer and Editor
Grid view
Form view
Foreign key data selection
Text, Hex, Image, BFile and Web viewer/editor
Find and replace
Filter records
SQL Processing
PL/SQL Debugger
SQL Editor
Visual SQL Builder
Code Snippet and Completion
SQL Code Beautifier/Minifier
Find and replace
Create parameter queries
Open query files in an external editor (Windows and macOS Edition only)
SQL*Plus (Windows and macOS Edition only)
Data Modeling
Physical model
Reverse/forward engineering
Auto layout
Add vertices, layers, images, notes, labels and shapes
Print database diagrams to PDF and graphic files
Import/Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON
Import/export data from/to most popular formats: DBF etc
Import data from ODBC, MS Excel, MS Access
Export data to MS Excel
Export data to MS Access (Windows and macOS Edition only)
Export data to HTML (Windows and Linux Edition only)
Data Manipulation
Data Transfer
Data/Structure Synchronization
Backup/Restore
Oracle Data Pump
Dump/Execute SQL file
Automation
Set schedule on backup, query execution, import/export, data transfer and data synchronization
Schedule report printing - Printer, PDF, Excel, HTML, etc (Windows Edition only)
Run profiles from different servers in a single batch job
Include attachment for export file/report in notification email
Server Security
Manage user
Server Monitor
Other Useful Features
Report Builder (Windows Edition only)
ER Diagram view
Virtual grouping
Customize connection colorings
Database wide search
Favorites list
Print schema structure
Run profile from command line
Connection
Oracle 8.1 or above ( macOS Edition starts from Oracle 9i ) Enterprise
Standard
Essentials
Amazon RDS, Oracle Cloud Enterprise
Standard
Essentials
Secure connection: SSH Enterprise
Standard
Essentials
Export/import connection settings Enterprise
Standard
Essentials
Navicat Cloud
Collaboration: create projects, add members Enterprise
Standard
Essentials
Synchronize connections and queries Enterprise
Standard
Essentials
Synchronize models Enterprise
Synchronize virtual groups Enterprise
Standard
Data Viewer and Editor
Grid view Enterprise
Standard
Essentials
Form view Enterprise
Standard
Foreign key data selection Enterprise
Standard
Text, Hex, Image, BFile and Web viewer/editor Enterprise
Standard
Essentials
Find and replace Enterprise
Standard
Essentials
Filter records Enterprise
Standard
Essentials
SQL Processing
PL/SQL Debugger Enterprise
Standard
SQL Editor Enterprise
Standard
Essentials
Visual SQL Builder Enterprise
Standard
Code Snippet and Completion Enterprise
Standard
SQL Code Beautifier/Minifier Enterprise
Standard
Find and replace Enterprise
Standard
Essentials
Create parameter queries Enterprise
Standard
Essentials
Open query files in an external editor (Windows and macOS Edition only) Enterprise
Standard
Essentials
SQL*Plus (Windows and macOS Edition only) Enterprise
Standard
Essentials
Data Modeling
Physical model Enterprise
Reverse/forward engineering Enterprise
Auto layout Enterprise
Add vertices, layers, images, notes, labels and shapes Enterprise
Print database diagrams to PDF and graphic files Enterprise
Import/Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON Enterprise
Standard
Essentials
Import/export data from/to most popular formats: DBF etc Enterprise
Standard
Import data from ODBC, MS Excel, MS Access Enterprise
Standard
Export data to MS Excel Enterprise
Standard
Export data to MS Access (Windows and macOS Edition only) Enterprise
Standard
Export data to HTML (Windows and Linux Edition only) Enterprise
Standard
Data Manipulation
Data Transfer Enterprise
Standard
Data/Structure Synchronization Enterprise
Standard
Backup/Restore
Oracle Data Pump Enterprise
Standard
Dump/Execute SQL file Enterprise
Standard
Essentials
Automation
Set schedule on backup, query execution, import/export, data transfer and data synchronization Enterprise
Standard
Schedule report printing - Printer, PDF, Excel, HTML, etc (Windows Edition only) Enterprise
Run profiles from different servers in a single batch job Enterprise
Standard
Include attachment for export file/report in notification email Enterprise
Standard
Server Security
Manage user Enterprise
Standard
Essentials
Server Monitor Enterprise
Standard
Other Useful Features
Report Builder (Windows Edition only) Enterprise
ER Diagram view Enterprise
Standard
Virtual grouping Enterprise
Standard
Customize connection colorings Enterprise
Standard
Essentials
Database wide search Enterprise
Standard
Favorites list Enterprise
Standard
Print schema structure Enterprise
Standard
Run profile from command line Enterprise
Standard