Working with a Server Database from Workstations

Working with a Server Database from Workstations

Contents Show

In the terminology of client-server computing, the proCube program that users run on workstations is the client of proCube server. The first step for a user wishing to work with a server-based database is to add the server to the server list.

Adding a server to the server list

A server is added from the proCube Management Studio's Server View. To add a server:

  1. Start a client version of proCube.

  2. From the Server View, highlight the Server node and click Services to display the server menu.

serverviewaddserver.png

Figure 1.    Server View - Adding a Server.

  1.  Select Add Server to open the Add Server dialog. The server name can either be specified by Host Name or TCP/IP address.

  1. Enter a <<Server Name>> in the Add Server text field.

There is no checking when you add a server to the list. Verify that you can communicate with the server via TCP/IP prior to attempting to open a database from the server. You can test the connection by using a TCP/IP ping utility. For more details, go to Networking Considerations.

addserverdialog.png

Figure 2.    Add Server Dialog

    1. Click Add.

    2. Click OK to add the server to the server list within the Server View.

serverviewaddedserver.png

Figure 3.    Server View - Added Server

Opening a server database

Once a server has been defined within the client, the server database can be opened from the client.

To open a database residing on a server from a client:

  1. From the Server View, highlight the newly added server, right-click and select Connect to Database to open the Open Database dialog.

serverviewconnectingtodatabase_.png

Figure 4.    Server View - Connecting to a Database

  1. From the Server drop-down, select a server that has been defined from the local client. Once the server is selected, its database displays in the Database Name list.

opendatabasedialogtest2.png

Figure 5.    Open Database Dialog - Selecting a Database

  1. Select a database and click OK to connect to the database.

proCube Management Studio's Status Bar (lower, right-hand corner) displays the current server and database.

statusbarserverdbase.png

Figure 6.    Status Bar - Current Server and Database

Deleting a server from the server list

A client user who “deletes” a server from the server list does nothing more than remove it from the list. The server will continue to execute and be available to other proCube clients. The user who deleted the server can add it back at a later time.

To remove a server from the list:

  1. From the Server View, highlight the server, right-click and select Remove Server (refer to Server View).

  2. A prompt opens. Click Yes to remove the server.

deleteserverprompt.png

Figure 7.    Delete Server Prompt

Comparing server and workstation functions

The following are further considerations for working with server databases from proCube, running on workstations (the proCube client):

  • A client connected to a server as a client cannot create a database on the Server—i.e., cannot create a Database that can be shared with other users via the server. The only way to create a shareable server-based database is by creating it from the server. Note, however, that you can create a database on a workstation and then make it available for the server to open and share.

  • You cannot cause a server database to be saved from the proCube program running on your workstation. A server-based database can be saved only from actual server.

  • A client can perform only certain Xchange functions on a server-based database. The remaining functions are reserved for the server. This table lists the functions for the proCube client versus a proCube server. For more information, go to Configuring the Server for Xchange.

 

proCube Client

Server

Create Cube

 

X

Modify Relational Dimension

 

X

Rebuild Cube

X

X

Update Cube

X

X

 


Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk