1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 6 Migration / Upgrade 7 End-User License Agreement 7 Chapter 2 - User Interface Version) 64 Import from Database 64 Chapter 11 - Forward Engineering (Available only in Non-Essentials Version) 65 Forward Engineer Physical Model 65 Synchronize to Database 65 Export SQL 69 71 Model Conversion 71 Auto Layout (Available only in Non-Essentials Version) 71 Print & Export Model 72 Virtual Grouping (Available only in Non-Essentials Edition) 72 Search Filter 73

1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 5 Migration / Upgrade 6 End-User License Agreement 7 Chapter 2 - User Interface Version) 63 Import from Database 63 Chapter 11 - Forward Engineering (Available only in Non-Essentials Version) 63 Forward Engineer Physical Model 63 Synchronize to Database 63 Export SQL 68 70 Model Conversion 70 Auto Layout (Available only in Non-Essentials Version) 70 Print & Export Model 71 Virtual Grouping (Available only in Non-Essentials Edition) 71 Search Filter 72

78 Maintain Objects 79 Redis 80 Databases 80 Data 80 Chapter 6 - Data Viewer 81 About Data Viewer 81 RDBMS 81 RDBMS Data Viewer 81 Use Navigation Bar 81 Edit Records 82 Replace Records 88 Filter Records 90 Manipulate Raw Data 90 Format Data View 91 View Field Comments 92 MongoDB 93 MongoDB Data Viewer 93 Use Navigation Bar 93 Grid View 94 Tree Tree View 100 JSON View 102 Sort / Find / Replace Documents 102 Redis 105 Redis Data Viewer 105 Use Navigation Bar 105 Edit Keys 106 Sort Keys 106 Search Keys 107 Assistant Editors

76 Maintain Objects 77 Redis 78 Databases 78 Data 78 Chapter 6 - Data Viewer 79 About Data Viewer 79 RDBMS 79 RDBMS Data Viewer 79 Use Navigation Bar 79 Edit Records 80 Replace Records 86 Filter Records 88 Manipulate Raw Data 89 Format Data View 89 View Field Comments 91 MongoDB 91 MongoDB Data Viewer 91 Use Navigation Bar 92 Grid View 93 Tree Tree View 98 JSON View 100 Sort / Find / Replace Documents 100 Redis 103 Redis Data Viewer 103 Use Navigation Bar 103 Edit Keys 104 Sort Keys 105 Search Keys 105 Assistant Editors

76 Maintain Objects 77 Redis 78 Databases 78 Data 78 Chapter 6 - Data Viewer 79 About Data Viewer 79 RDBMS 79 RDBMS Data Viewer 79 Use Navigation Bar 79 Edit Records 80 Replace Records 86 Filter Records 88 Manipulate Raw Data 89 Format Data View 89 View Field Comments 90 MongoDB 90 MongoDB Data Viewer 90 Use Navigation Bar 91 Grid View 92 Tree Tree View 97 JSON View 99 Sort / Find / Replace Documents 99 Redis 102 Redis Data Viewer 102 Use Navigation Bar 102 Edit Keys 103 Sort Keys 104 Search Keys 104 Assistant Editors

Workspace 25 About Workspace 25 Create Workspace 26 Chapter 5 - Data Source 27 About Data Source 27 Create Data Source 28 Database Connection 29 Connect to Database Server 29 General SSH Settings 34 HTTP Settings 35 Compatibility Settings 36 File/ODBC Connection 36 Import Data from File/ODBC 36 Choose File Format 37 Choose Source File 37 Choose Delimiter 38 Structures 40 Preview Data 40 Start Import 41 Add Query 41 Query Editor 41 Query Builder 45 Modify Data Source Connections 50 View Data 51 Filter / Sort / Project Data 52 Add Custom

Workspace 25 About Workspace 25 Create Workspace 26 Chapter 5 - Data Source 27 About Data Source 27 Create Data Source 28 Database Connection 29 Connect to Database Server 29 General SSH Settings 35 HTTP Settings 36 Compatibility Settings 36 File/ODBC Connection 37 Import Data from File/ODBC 37 Choose File Format 38 Choose Source File 38 Choose Record Format / File Structures 41 Preview Data 41 Start Import 42 Add Query 42 Query Editor 42 Query Builder 45 Modify Data Source Connections 51 View Data 52 Filter / Sort / Project Data 52 Add Custom

Workspace 26 About Workspace 26 Create Workspace 27 Chapter 5 - Data Source 28 About Data Source 28 Create Data Source 29 Database Connection 30 Connect to Database Server 30 General SSH Settings 36 HTTP Settings 37 Compatibility Settings 37 File/ODBC Connection 38 Import Data from File/ODBC 38 Choose File Format 38 Choose Source File 38 Choose Delimiter 40 Structures 42 Preview Data 42 Start Import 43 Add Query 43 Query Editor 43 Query Builder 46 Modify Data Source Connections 52 View Data 53 Filter / Sort / Project Data 54 Add Custom

Members 20 Chapter 4 - Workspace Handling 22 Open Workspace 22 Present Dashboard 23 Print & Export Dashboard 23 Chapter 5 - Other Advanced Tools 24 Useful Features 24 Search Filter 24 increases the flexibility and convenience for viewing workspace files. It also gives you the ability to export dashboards to PDF files and other image file formats. Navicat Charts Viewer is available on three run on the Programs; 6. comply fully with all relevant export laws and regulations of the United States and other applicable export and import laws to assure that neither the Oracle Instant Client, nor

run on the Programs; 6. comply fully with all relevant export laws and regulations of the United States and other applicable export and import laws to assure that neither the Oracle Instant Client, nor consequential damages (including, but not limited to, damages for the inability to use equipment or access data, loss of business, loss of profits, business interruption or the like), arising out of the use of to open the browser and go to http://: manually. If you want to import Navicat On-Prem Server configuration settings, see Backup / Migration for details. 17