kb52: Access the SAP database and look at the structure of the database

There is a web based interface to the SAP database. Before you can access the interface, you need to start SapWWW as follows:

On Windows, this process is started by starting the SAP DB WWW service.
On Linux, this process is started by executing:
/etc/rc.d/init.d/firenze_sapdbWebAdm start

Use the following URL to access the WebSQL interface (substituting the name of your Management Station for YourMgmtStation):

http://YourMgmtStation:7230/websql

Enter the server name, database name ("fzedb1" - with no quotes), and the username and password used when installing Longitude.

Enter "SELECT * FROM SYS.ALL_TABLES" (with no quotes) in the query box and click the Execute button to list all of the tables in the database.