The following figure shows how to use GaussDB(DWS).
Accessing a Cluster
GaussDB(DWS) provides a web-based management console and HTTPS-compliant APIs for you to manage data warehouse clusters.
Accessing the Database in a Cluster
- GaussDB(DWS) clients
Access the cluster database using GaussDB(DWS) clients. For details, see Connecting to Clusters" in the Data Warehouse Service (DWS) User Guide.
- Open-source PostgreSQL clientsThe following lists compatible open-source clients:
- PostgreSQL psql 9.2.4 or later
For more information, see https://www.postgresql.org/.
- pgadmin
For more information, see https://www.pgadmin.org/.
- dbeaver
For more information, see https://dbeaver.jkiss.org/download/.
- PostgreSQL psql 9.2.4 or later
- JDBC and ODBC API calling
You can call standard APIs, such as JDBC and ODBC, to access databases in clusters.
For details, see "Using the JDBC and ODBC Drivers to Connect to a Cluster" in the Data Warehouse Service (DWS) User Guide.
End-to-End Data Analysis Process
GaussDB(DWS) has been seamlessly integrated with other services on the cloud, helping you rapidly deploy end-to-end data analysis solutions.
The following figure shows the end-to-end data analysis process. Services in use during each process are also displayed.
