Help Center> Data Warehouse Service> Tool Guide> Overview
View PDF

Overview

This document describes the tools used in Data Warehouse Service GaussDB(DWS). Table 1 lists the tools and their supported versions.
Table 1 Tools

Tool

Version

Description

Supported Cluster Version

gsql

V300R002C00

A command line SQL client tool running on the Linux OS. It is used to connect to the database in a data warehouse cluster and operate and maintain the database.

GaussDB(DWS) 1.0.x or later

Data Studio

8.0.0

A client tool used to connect to a database. It provides a GUI for managing databases and objects; editing, running, and debugging SQL scripts; and viewing execution plans. Data Studio can run on a 32-bit or 64-bit Windows OS. You can use it after decompression without installation.

GaussDB(DWS) 1.2.x or later

GDS

V300R002C00

A command line tool running on the Linux OS. It works with the foreign table mechanism to quickly import and export data. The GDS tool package needs to be installed on the server where the data source file is located. This server is called the data server or the GDS server.

GaussDB(DWS) 1.0.x or later

DSC

8.0.1

A command line tool used for migrating SQL scripts from Teradata or Oracle to GaussDB(DWS) to rebuild a database on GaussDB(DWS). DSC runs on the Linux OS. You can use it after decompression without installation.

GaussDB(DWS) 1.3.x or later