161 Choose Format Options 162 Map Tables / Collections 163 Map Fields 163 Choose Import Mode 164 Save and Start Import 165 Export Wizard 165 About Export Wizard 165 Choose File Format Data Transfer 169 Choose Connections & Advanced Options (Step 1) 169 Choose Objects & Transfer Mode (Step 2) 172 Confirm & Start Data Transfer (Step 3) 174 Data Synchronization (Available only 215 Filter / Sort / Project Data 217 Add Custom Fields 219 Chart 220 About Chart 220 Build Chart 221 Filter / Sort Data 223 Apply Aggregate Function 224 Add Range 225 Set Value

Choose Target Table / Collection 167 Adjust Field Structures and Map Fields 168 Choose Import Mode 169 Save and Start Import 170 Export Wizard 170 About Export Wizard 170 Choose File Format Data Transfer 174 Choose Connections & Advanced Options (Step 1) 174 Choose Objects & Transfer Mode (Step 2) 178 Confirm & Start Data Transfer (Step 3) 179 Data Synchronization (Available only 209 Filter / Sort / Project Data 211 Add Custom Fields 213 Chart 214 About Chart 214 Build Chart 215 Filter / Sort Data 217 Apply Aggregate Function 218 Add Range 219 Set Value

Choose Target Table / Collection 167 Adjust Field Structures and Map Fields 167 Choose Import Mode 168 Save and Start Import 169 Export Wizard 169 About Export Wizard 169 Choose File Format Data Transfer 173 Choose Connections & Advanced Options (Step 1) 173 Choose Objects & Transfer Mode (Step 2) 177 Confirm & Start Data Transfer (Step 3) 178 Data Synchronization (Available only 209 Filter / Sort / Project Data 211 Add Custom Fields 213 Chart 214 About Chart 214 Build Chart 215 Filter / Sort Data 217 Apply Aggregate Function 218 Add Range 219 Set Value

Filter / Sort / Project Data 54 Add Custom Fields 55 Chapter 6 - Chart 58 About Chart 58 Build Chart 59 Filter / Sort Data 60 Apply Aggregate Function 61 Add Range 62 Set Value Operation Table 92 Control 94 DateTime Formats 95 Chapter 7 - Dashboard 96 About Dashboard 96 Build Dashboard 96 Add Pages 97 3 Add Charts 98 Add Text Labels 98 Add Images 99 Add • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported Cloud Databases Amazon AWS • Amazon Redshift

Filter / Sort / Project Data 52 Add Custom Fields 54 Chapter 6 - Chart 56 About Chart 56 Build Chart 57 Filter / Sort Data 58 Apply Aggregate Function 59 Add Range 60 Set Value Operation Table 90 Control 92 DateTime Formats 93 Chapter 7 - Dashboard 94 About Dashboard 94 Build Dashboard 94 Add Pages 95 3 Add Charts 96 Add Text Labels 96 Add Images 97 Add • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported Cloud Databases Amazon AWS • Amazon Redshift

Filter / Sort / Project Data 52 Add Custom Fields 54 Chapter 6 - Chart 57 About Chart 57 Build Chart 58 Filter / Sort Data 59 Apply Aggregate Function 60 Add Range 61 Set Value Operation Table 91 Control 93 DateTime Formats 94 Chapter 7 - Dashboard 95 About Dashboard 95 Build Dashboard 95 Add Pages 96 3 Add Charts 97 Add Text Labels 97 Add Images 98 Add • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported Cloud Databases Amazon AWS • Amazon Redshift

Virtual Grouping (Available only in Non-Essentials Edition) 71 Search Filter 72 Full Screen Mode 73 Chapter 13 - Configurations 74 Preferences / Settings 74 General 74 Tabs 74 Editor 15.0 • SQLite 3 • Redshift 1.0 • OceanBase Community and Enterprise 3.2 (Enterprise Oracle Mode is not available in macOS Edition) Installation We strongly suggest that you shut down any opened Diagram from the menu bar. Hint: Navicat Data Modeler has added support for the system-wide dark mode. Toolbar The Toolbar is located near the top of the Main Window. The buttons display in the

(Available only in Non-Essentials Edition) 72 Search Filter 73 Dark Theme 74 Full Screen Mode 74 Chapter 13 - Configurations 76 Options Settings 76 General 76 Code Completion (Available • Redshift 1.0 • GaussDB 3.2 • OceanBase Community and Enterprise 3.2 (Enterprise Oracle Mode is not available in macOS Edition) Installation We strongly suggest that you shut down any opened Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view's Definition directly. Note: The tabs and

connection between Navicat On-Prem Server and your LDAP server. Authentication Mode Select the authentication mode to use for authenticating the user with your LDAP server. [Comparison Authentication] House Keeping in Advanced Configurations. You can control the build retention policy for logs by specifying both the Maximum Size of Each Build and the Maximum No. of Builds to Keep. Backup / Migration

your workspace file if the data sources are set to the archive mode. However, please bear in mind that all data sources in the archive mode will not contain the most up-to-date data. Open Local Workspace screen. The title bar, Dashboards pane, Pages pane and Properties pane will be hidden while in this mode. To open a dashboard in present view, click or Present in the Properties pane. If the dashboard key and the workspace window will be returned to its previous state. Sort Chart In the Present mode, you can organize your data in a chart with one click. You can sort data series by a value. 1. Hover