# text

sentence:
The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools.


sentence:
Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy.


sentence:
It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server.


sentence:
With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way.


sentence:
The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily.


sentence:
If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane.


sentence:
After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections.


sentence:
A query is used to extract data from the database in a readable format according to the user's request.


sentence:
In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view.


sentence:
The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview.


sentence:
You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane.


sentence:
Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms.


sentence:
All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration.


sentence:
Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud.


sentence:
To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window.


sentence:
Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication.


sentence:
To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature.


sentence:
To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab.


sentence:
If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution.


sentence:
To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab.


sentence:
To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source.


sentence:
Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another.


sentence:
It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network.


sentence:
In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information.


sentence:
Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated.


sentence:
SSH serves to prevent such vulnerabilities and allows you to access a remote server's shell without compromising security.


sentence:
HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does.


sentence:
It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections.


sentence:
Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually.


sentence:
To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences.


sentence:
Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more.


sentence:
Export Wizard allows you to export data from tables, collections, views, or query results to any available formats.


sentence:
Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process.


sentence:
In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information.


sentence:
After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target.


sentence:
Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure.


sentence:
Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.


sentence:
Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.


sentence:
It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP.


sentence:
Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored.


sentence:
The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance.


sentence:
Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences.


sentence:
What you get by achieving your goals is not as important as what you become by achieving your goals.


sentence:
Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from.


