Database server editor
This section provides a detailed description of the Database server editors. Each essentially provides a means for you to configure your database servers:
- in order to manage CAST Analysis/Dashboard/Measurement Services. You can configure as many as you require - i.e. you can manage multi-homed services from one place.
- in order to manage live access to databases that are required for analysis purposes (DB2 UDB and Business Objects technology only)
You can use this editor to display configuration details for Database Servers that have been created:
- automatically using the information defined during the installation process using CAST Server Manager - see the CAST Installation Guide for more information.
- manually using the Services view, this editor provides the means to configure the appropriate connection details (name, description, RDBMS type, version, host name, port, instance etc.): CAST Storage Service, Oracle and Microsoft SQL Server only
- automatically by the CAST Delivery Manager Tool (see the Current Version tab in the Application editor): DB2 UDB technology only
- During the process of connecting to the Management database/schema when launching the CAST Management Studio, the "server" listed in the Connection Profile automatically created by CAST Server Manager for the Management database/schema, 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.
- Please see CAST Management Studio - Rights for more information about how server access rights and permissions are handled in the CAST Management Studio.
There are various Database server editors - click the editor you want to know more about:
- CAST Storage Service
- Oracle Server
- MS SQL Server
- DB2/UDB database server (this editor cannot be created manually and is only used for analysis purposes - it will be created automatically by the CAST Delivery Manager Tool and is populated with the connection parameters defined in the CAST Delivery Manager Tool)
- Business Objects instance (this editor cannot be created manually and is only used for analysis purposes - it will be created automatically when a Business Obejcts package is delivered by the CAST Delivery Manager Tool)
Note that Sybase ASE servers are no longer created by the CAST Delivery Manager Tool: T-SQL analyses are now all run in offline mode and no connection from the CAST Management Studio to the server is required during an analysis.