Connection
- This application is a report generation tool and, as such, it provides a means to extract technical information from the Analysis Service in the form of HTML based reports. Your Analysis Service will be installed on any supported CAST Storage Service, Microsoft or Oracle server (please refer to the Release Notes for more information on supported versions).
- You therefore need to connect to the server that contains your Analysis Service using a login name and password that have sufficient permissions to access it.
- Connections are defined in Connection Profiles, enabling you to create any number of different connection configurations (specifying servers, usernames and passwords) to a variety of different servers (if for example your organization uses several different Analysis Services). Connection is simply a matter of selecting and opening a valid profile.
- When a connection to a server has been established, you can begin generating reports from the information stored in the Analysis Service.
- Special considerations for Oracle users
When you are connecting to an Oracle server for whatever reason (connecting to the server for installation purposes or for analysis requirements etc), various messages will be displayed in the Log Window regarding the connection profile you are using for the given operation.These messages refer to the mechanisms CAST uses for accessing the PL/SQL objects required for the operation you are carrying out.
Depending on the credentials granted to the user name you are using to connect with (defined in your Connection Profile) one of the messages below will be displayed:- Using DBA views for connection profile 'x' > The user name defined in the connection profile you are are using to connect with has credentials enabling the required DBA views to be "seen". In this case, CAST uses the DBA_ views (see the online Help for Server Manager for more information) to display information about the PL/SQL objects that are required.
- Using ALL views for connection profile 'x' > The user name defined in the connection profile you are are using to connect with has credentials that do not enable the required DBA views to be "seen". In this case, CAST uses the ALL_ views (see the online Help for Server Manager for more information) to display information about the PL/SQL objects you require - if this is the case, you may not be able to access all the objects that are required. As such, results may be incomplete.
In addition, two further messages may also be displayed:
- Using optimized queries for connection profile 'x' > The credentials of your analysis connection profile (i.e.: the user name defined in the profile) allow the use of optimized queries for accessing some parts of the Oracle system catalogue for the purpose of running your analysis.
- Using unoptimized queries for connection profile 'x' > The credentials of your analysis connection profile (i.e.: the user name defined in the profile) disallow use of optimized queries for accessing some parts of the Oracle system catalogue for the purpose of running your analysis.
See Also
Connection Profiles | Launching
