Cong Li1. Comparison Between GSQL and GCCLI Clients
GSQL is a database connection tool provided by GaussDB 200 for running commands in the command line. This tool allows you to connect to the server and perform operations and maintenance. Its functionalities include: connecting to the database, executing SQL statements, executing meta-commands, and directly setting and using variables.
GBase 8a MPP’s GCCLI supports connecting to the database and executing SQL but does not support directly setting and using variables.
Variables set in GaussDB must be executed in stored procedures when using GBase 8a:
gsql -h 10.180.123.163 -d postgres -U jack -p 25308
\set foo 'HR.areaS'
select * from :foo;
area_id | area_name
---------+------------------------
4 | Middle East and Africa
3 | Asia
1 | Europe
2 | Americas
(4 rows)
2. Data Studio and GBase Studio
Data Studio is a GUI tool that allows you to connect to the database, execute, and debug SQL statements and stored procedures. Data Studio supports the basic features of GaussDB 200 and provides a graphical interface for database developers. The corresponding tool for GBase 8a MPP is GBase Studio.
3. Migration of Other Third-Party Tools and Application Interfaces
Similar to GaussDB, GBase 8a supports the use of standard database interface APIs such as JDBC, ODBC, Perl DBI, and Python DBI. For detailed information on the installation and configuration of specific interfaces, refer to the relevant API interface manuals provided by GBase 8a.
If third-party tools or programs that use the aforementioned API interfaces to access GaussDB are to be migrated to GBase 8a, this can be done by configuring the connection driver in a conventional manner.
Common third-party tools supported by GBase 8a include:
- ETL Tools: Kettle, Informatica
- BI Tools: Cognos, Tableau
- Analytical Tools: SAS, SPSS
For detailed information on integrating specific tools, refer to the integration manuals provided by GBase 8a.
