Objects 48 Connections 48 Queries 48 Models 48 Snippets 49 Charts Workspaces 49 Virtual Groups 50 Chapter 8 – Commands 51 On-Prem Server Commands 51 Chapter 9 - Troubleshooting Cloud account, and manage the objects (connections, queries, snippets, models, workspaces and virtual groups) that are synchronized to Navicat Cloud. Here are some highlights of Navicat Cloud Portal: environment for storing Navicat objects (connection settings, queries, snippets, models, workspaces, and virtual groups) internally at your location. Here are some highlights of Navicat On-Prem Server: •

Navigate to -> Administration page Server Configuration tab Ensure the option is activated. AI Service Navigate to -> AI Settings tab Choose an engine In the field, input your AI secret key. API Navigate to the and create a new AI service under the AI + Machine Learning section. Azure Portal Generate and copy the credentials for the newly created service. Insert these credentials into ClouBeaver's connections cannot explicitly be created or deleted by users. Their configuration is provided by a cloud service provider (e.g. thru AWS API). Once CB will find such connections (by using cloud configuration specified

SQL Generation Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions Properties Editor ER Diagrams Database Structure Diagrams Custom Diagrams Generation in DBeaver Logical structure Opens a submenu allowing you to write virtual column expressions. See the artice about Virtual column . expressions Open with Opens the data in external applications 146 of 859. Expression language Column values Standard functions math geo content Defining Virtual Keys You can use standard JavaScript-like expression language. DBeaver uses the Jexl engine to process

SQL Generation Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions Properties Editor ER Diagrams Database Structure Diagrams Custom Diagrams Generation in DBeaver Logical structure Opens a submenu allowing you to write virtual column expressions. See the artice about Virtual column . expressions Open with Opens the data in external applications or pressing pastes several cells. Advanced Paste Ctrl+Shift+V Copying/Pasting Cells Defining Virtual Keys DBeaver User Guide 23.2. Page 66 of 700. To be able to save column value changes, a table

with Spatial Geographic Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan your connection. See the for more details. Filters article Virtual Model Editor Reset virtual model settings, including: - All virtual constraints and foreign keys. - All column transformers. - All using only one login and password. This is possible if you use SSO - Single Sign-On authentication service. You do not need to manage, store, and transfer user credentials. When a user connects to the database

with Spatial Geographic Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan your connection. See the for more details. Filters article Virtual Model Editor Reset virtual model settings, including: - All virtual constraints and foreign keys. - All column transformers. - All using only one login and password. This is possible if you use SSO - Single Sign-On authentication service. You do not need to manage, store, and transfer user credentials. When a user connects to the database

with Spatial Geographic 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 your connection. See the for more details. Filters article Virtual Model Editor Reset virtual model settings, including: - All virtual constraints and foreign keys. - All column transformers. - All using only one login and password. This is possible if you use SSO - Single Sign-On authentication service. You do not need to manage, store, and transfer user credentials. When a user connects to the database

with Spatial Geographic 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 your connection. See the for more details. Filters article Virtual Model Editor Reset virtual model settings, including: - All virtual constraints and foreign keys. - All column transformers. - All using only one login and password. This is possible if you use SSO - Single Sign-On authentication service. You do not need to manage, store, and transfer user credentials. When a user connects to the database

with Spatial Geographic Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan your connection. See the for more details. Filters article Virtual Model Editor Reset virtual model settings, including: - All virtual constraints and foreign keys. - All column transformers. - All using only one login and password. This is possible if you use SSO - Single Sign-On authentication service. You do not need to manage, store, and transfer user credentials. When a user connects to the database

with Spatial Geographic Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan your connection. See the for more details. Filters article Virtual Model Editor Reset virtual model settings, including: - All virtual constraints and foreign keys. - All column transformers. - All using only one login and password. This is possible if you use SSO - Single Sign-On authentication service. You do not need to manage, store, and transfer user credentials. When a user connects to the database