Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Manage CAST Management Studio Connections


Connection profiles are used to record a set of connection parameters - they are used when launching the CAST Management Studio and enable you to choose the Management Service (<prefix>_MNGT) you would like to connect to.

Please see CAST Management Studio - Rights for more information about how server access rights and permissions are handled in the CAST Management Studio.

During the installation process (if using a Combined Install option), CAST Server Manager will automatically create a connection profile to the CAST Management Studio database/schema (<prefix>_MNGT) you have installed. This connection profile is stored in a proprietary XML file on your hard drive. When you first launch the CAST Management Studio, you will be prompted to check that the connection profile is correct (see Launching the CAST Management Studio).

Once connected, you can create new connection profiles, and view/modify existing connection profiles. Use the sections below to find out more.

Managing connections

All connection profiles are managed in the Edit Connection Profiles dialog box:

This can be accessed as follows:

  • Click the Window > Manage CAST-MS Connections option located on the toolbar

Each profile is displayed in this dialog box. Column headings and buttons are explained below:

Icon Indicates the host server type:
  • > Microsoft SQL Server
  • > Oracle Server
  • > CAST Storage Service
Server details Indicates the host server name and connection port
Name Displays the name of the connection profile
Container Displays the name of the CAST Management Studio database/schema (<prefix>_MNGT) that will be used to connect to
Use this button to add a new connection profile. See section below.
Use this button to edit an existing connection profile
Use this button to remove a profile
Use this button to export ALL the displayed connection profiles to file. You will be prompted to choose a location and name for the file. The resulting file will be named <name>.pmx.
Use this button to import a connection profile or profiles. You will be prompted to choose the location of your .pmx file for import. Once imported the connection profile(s) will be displayed in the list.

Right click menu

You can also use the right click menu on a connection profile. Options are identical, except for the Verify option, which will test the connection to server defined in the connection profile (identical to the Test connection option).

Add a new connection profile

To add a new connection profile:

  • Click the Window > Manage CAST-MS Connections option
  • The Connection Profile dialog box will be displayed - if this is the first time you have accessed this dialog box, then only one connection profile will be visible (the profile created during the installation process):

  • Click the button. A floating dialog box will be displayed enabling you to choose the type of connection profile you require:

  • A new dialog box will then be displayed enabling you to define the connection details. The fields differ slight depending on the connection type you have chosen. Each is explained below.
  • Once the connection parameters have been filled in, you can use the Verify option to check that the connection to the target server is successful (a message box will indicate the success or otherwise).
  • Click OK to save the connection profile in the Edit Connection Profiles dialog box
  • Next time you launch the CAST Management Studio, the new profile will be visible in the Edit Connection Profiles dialog box.

Notes

  • A connection profile is distinct from a connection defined in the Services view. In the Services view, the connections do not specify a CAST Management Studio database and are thus only to connect to Analysis, Dashboard and Measurement Services.
CAST Storage Service

Name Displays the name of your connection profile.

Note that this name does not need to correspond to the host name of your server. However, for ease of recognition, CAST recommends using a naming convention which can be easily understood.

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 port settings are as follows:

  • CAST Storage Service 2 > 2280

Password Displays the password (in encrypted format) that corresponds to your Operator login.

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.

Schema Displays the name of the target Management Service (<prefix>_mngt). You can edit the field by selecting it and then modifying or replacing as appropriate - or you can use the Browse button to select the Management Service you require.

Note that the schema name MUST be entered using lowercase.

Oracle Server

Name Displays the name of your connection profile.

Note that this name does not need to correspond to the host name of your server. However, for ease of recognition, CAST recommends using a naming convention which can be easily understood.

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). Choose the appropriate option for your environment - the below option will then differ according to your choice.
Service Displays the Service name for accessing your database. This field will only be displayed if you selected Service from the above Access option.

You can edit the field by selecting it and then modifying or replacing as appropriate.

SID Displays the SID for accessing your database. This field will only be displayed if you selected SID from the above Access option.

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 Management Service on the selected database server. In the case of Oracle servers this is the schema name.

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.

Schema Displays the name of the target Management Service (<prefix>_MNGT). You can edit the field by selecting it and then modifying or replacing as appropriate - or you can use the Browse button to select the Management Service you require.
Microsoft SQL Server

Name Displays the name of your connection profile.

Note that this name does not need to correspond to the host name of your server. However, for ease of recognition, CAST recommends using a naming convention which can be easily understood.

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.

Access Displays the database server access mode type (Port or Instance). Choose the appropriate option for your environment - the below option will then differ according to your choice.
Port Displays the port number for accessing your database. This field will only be displayed if you selected Port from the above Access option.

You can edit the field by selecting it and then modifying or replacing as appropriate.

Default RDBMS port settings are as follows:

  • Microsoft SQL Server > 1433

Instance Displays the instance name for accessing your database server. This field will only be displayed if you selected Instance from the above Access option.

You can edit the field by selecting it and then modifying or replacing as appropriate.

Trusted If selected, this flags the connection as trusted using your current Windows login credentials - there is then no need to enter a user or password (these fields will be disabled).
User Displays the user login that has sufficient privileges to access the required Management Server 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.

Database Displays the name of the target Management Service (<prefix>_MNGT). You can edit the field by selecting it and then modifying or replacing as appropriate - or you can use the Browse button to select the Management Service you require.
See Also

Services view | Preferences | CAST Management Studio - Rights


CAST Website

  • No labels