User Guide

SAP AG November 2002
Database Tools
The SAP DB database system offers a series of tools for working with the database
instances.
• Architecture of the SAP DB Tools [Page
53]
• The following SAP DB tools are described in more detail:
Database Manager [Page
133]
SAP DB Loader [Page 148]
SQL Studio [Page 65]
Architecture of the SAP DB Tools
The SAP DB tools Database Manager [Page 133] and SAP DB Loader [Page 148] each
consist of a server part and a client part. The server part is responsible for the functions, and
the user uses the client to access the tool.
The SAP DB tool SQL Studio [Page
65] has a graphical user interface and accesses the
database instance [Page 132] through ODBC.
Client/Server for the SAP DB Tools
Client Server
Database Manager DBMGUI, DBMCLI
Web DBM
Script interface (for example to Perl or
Python) available
DBM Server [Page
58]
SAP DB Loader LOADERCLI
Script interface (for example to Perl or
Python) available
Loader [Page
59]
SQL Studio SQL Studio
Web SQL
Database Instance
Prerequisites
Client Windows NT/Windows 2000 UNIX
DBMCLI
LOADERCLI
The X server [Page 156] must be
active as a service on the database
server.
The X server must be running as a
background process on the database
server.
DBMGUI The X server must be active as a
service on the database server.
The X server must be running as a
background process on the database
server.
The Database Manager GUI is installed
on a Windows server. The database
instance on the UNIX server is
administered remotely.
Web DBM
Web SQL
The Web services must be installed
together with the Web Server [Page
156] on one computer.
The Web services must be installed
together with the Web Server on one
computer.
User Manual: SAP DB 53