CMS - Oracle Server database server editor

Oracle Server database server editor

Note

• Note that Oracle database servers support Analysis or Dashboard Services for use with the CAST Management Studio.

• Measurement Services are not supported on host Oracle servers.

• During the process of connecting to the Management Service when launching the CAST Management Studio, the "server" listed in the Connection Profile automatically created by CAST Server Manager for the Management Service, will be added by default to the Services view. The same login credentials will be used. Please see CAST Management Studio - Rights for more information about how server access rights and permissions are handled in the CAST Management Studio.

The Oracle server database server editor contains various tabs and sections. Each is explained below.

Connection tab

Host	Displays the host name of your database server. You can also enter an IP address if required. You can edit the field by selecting it and then modifying or replacing as appropriate.
Port	Displays the port number for accessing your database. You can edit the field by selecting it and then modifying or replacing as appropriate. Default RDBMS port settings are as follows: Oracle > 1521
Access	Displays the database server access mode type (SID or Service). Select the mode that is appropriate for your environment.
SID or Service	Displays the SID or Service name for accessing your database. You can edit the field by selecting it and then modifying or replacing as appropriate.
User	Displays the user login that has sufficient privileges to access the required CAST and/or other databases on the selected database server. You can edit the field by selecting it and then modifying or replacing as appropriate. Please see CAST Management Studio - Rights for more information about how server access rights and permissions are handled in the CAST Management Studio.
Password	Displays the password (in encrypted format) that corresponds to your User login. You can edit the field by selecting it and then modifying or replacing as appropriate.
Test Connection	See Test connection for more information.

Services tab

This section displays all Services currently available on the target database server (these are non-editable fields):

Type	Indicates whether the service is a Dashboard or Analysis Service.
Name	This field displays the corresponding server database/schema name for the service.
Version	Displays the version of your service as installed in CAST Server Manager.
Corporate Name	Displays the name of the "Corporate" item, as defined in the Dashboard Service editor.
Assessment Model	Displays the name of the Assessment Model assigned to the selected service, as defined in the Dashboard Service editor.
Background Facts file	Displays the name of the Background Facts file assigned to the selected service, as defined in the Dashboard Service editor. For more information about this, please see: Configuring the Background Facts upload file.
Active for the current Management Service	No information will be displayed here - Measurement Services cannot be installed on host Oracle servers.
Discover	See Discover for more information.

Notes

• Double clicking an item in the list will open the corresponding editor
• Right clicking an item in the list and then selecting Edit will open the corresponding editor (the right click menu also contains other options - these options are explained in the Services view).
• Selecting an item in the list and then clicking the button will open the corresponding editor

Notes tab

The Notes tab is simply an area that you can use to make notes or remarks about the selected item.

Editor buttons

The following buttons are available in the view:

	Minimize > Minimize the entire window
	Maximize > Maximize the entire window