Help Center > > Tool Guide> Overview

Overview

Updated at: Aug 09, 2019 GMT+08:00
This document describes the tools used in Data Warehouse Service (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.

DWS 1.0.x or later

Data Studio

6.5.1

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.

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.

DWS 1.1.x or later

Migration Tool

6.5.1

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

DWS 1.3.x or later

Schema Convertor Tool

1.0

Schema Convertor Tool is a command line tool running on the Linux or Windows OS and is used to migrate and transform the SQL scripts in MySQL databases to SQL scripts applicable to DWS to rebuild the databases on DWS. You can use it after decompressing the software package without installation.

DWS 1.3.x or later

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel