Connecting to a Database

Client tools for connecting to a database include DAS, gsql, and APIs (such as ODBC and JDBC).

DAS enables you to manage databases on a web-based console and supports SQL execution, advanced database management, and intelligent O&M, simplifying database management and improving working efficiency and data security. The permissions required for connecting to a GaussDB instance through DAS are enabled by default. Using DAS to connect to your DB instance is recommended, which is more secure and convenient. For details about how to connect to GaussDB, see Data Admin Service User Guide.
gsql is a client tool provided by GaussDB. You can use gsql to connect to the database and then enter, edit, and execute SQL statements in an interactive manner. For details about the connection mode, see Using gsql to Connect to an Instance.
You can use standard database APIs, such as ODBC and JDBC, to develop GaussDB-based applications.

For distributed instances, you can use a client tool to connect to a database through any CN. Before connection, you must obtain the IP address and port number of the server where the CN is deployed. The client tool can access the database by connecting to any CN. Do not connect to a database through a DN when services are running properly.

Parent topic: Working with Databases

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.