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 Trace Logs 84 Log Files 84 4 Chapter 1 - Introduction About Navicat Data Modeler Navicat Data Modeler is a powerful and easy-to-use GUI tool for creating and manipulating database models print models to files, etc. Navicat Data Modeler is available on three platforms - Microsoft Windows, macOS and Linux. Here are some highlights of Navicat Data Modeler: • Create and manipulate c

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 Trace Logs 82 Log Files 82 4 Chapter 1 - Introduction About Navicat Data Modeler Navicat Data Modeler is a powerful and easy-to-use GUI tool for creating and manipulating database models print models to files, etc. Navicat Data Modeler is available on three platforms - Microsoft Windows, macOS and Linux. Here are some highlights of Navicat Data Modeler: • Create and manipulate c

3 of 252. DB Navigator folders Simple and Advanced View Data editor Data Filters Data Ordering Value Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan parameters Administration Authentication Theming Localization Database Navigator Data Editor SQL Editor Log Viewer Data Export ERD Connections Command line parameters CloudBeaver EE for AWS Overview remote database Navigate database structure View properties of database object View and edit table data Execute SQL query Select in a main menu Connection > Manual > Custom Select database Set connection

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 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 2 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 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 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 2 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

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 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

Settings menu DB Navigator folders Simple and Advanced View Data editor Data Filters Data Ordering Value Panel JSON and Document View Data export Entity Diagrams Document viewer SQL Editor Query Localization Database Navigator Data Editor SQL Editor Log Viewer CloudBeaver user guide 23.0 2/111 CloudBeaver EE for AWS CloudBeaver Enterprise Edition Team Edition Data Export ERD Connections Command structure: schemas, tables, views indexes, etc View properties of database objects View and edit table data Execute SQL queries 1. Select Connection > Manual > Custom in a main menu 2. Select database 3

Settings menu DB Navigator folders Simple and Advanced View Data editor Data Filters Data Ordering Value Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan parameters Administration Authentication Theming Localization Database Navigator Data Editor SQL Editor Log Viewer Data Export ERD Connections Command line parameters CloudBeaver EE for AWS Overview structure: schemas, tables, views indexes, etc View properties of database objects View and edit table data Execute SQL queries Select in a main menu Connection > Manual > Custom Select database Set connection

User Guide 23.2. Page 3 of 182. Simple and Advanced View Data editor Data Filters Data Ordering Value Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan parameters Administration Authentication Theming Localization Database Navigator Data Editor SQL Editor Log Viewer Data Export ERD Connections Command line parameters CloudBeaver EE for AWS Overview structure: schemas, tables, views indexes, etc View properties of database objects View and edit table data Execute SQL queries Select in a main menu Connection > Manual > Custom Select database Set connection

Guide 24.2.ea. Page 7 of 1010. Data Editor overview Data View and Format Data Filters Data viewing and editing Data refresh Navigation Managing Panels Managing Data formats Managing Charts Working Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions SQL Editor overview Data Editor tools Viewing and editing data Data operations Advanced data types SQL Editor Pending Transactions Auto and manual commit modes Query Manager Data transfer Data import and replace Search overview Data Search Database full text Search Database metadata Search File Search