|
|
| |
While Discoverer is the primary tool being supported for use with the Integrated System, other tools can be used as well.
|
In order to use another tool, please follow the following instructions:
|
- If you have not already installed Discoverer, you should do so. Even if you do not plan to use Discoverer, it installs software that is necessary to access the ODS by any tool.
Before attempting to access the ODS throught another tool, please make sure you can log in successfully using Discoverer. If you cannot log in with Discoverer, it is not likely that other tools will work properly either.
|
- When you use Discoverer, you use your Integrated System id and password. However, other tools are not able to do this. In order to be able to log in to the ODS using another tool, you will need to have a database account on the ODS. To request a database account, you must have a valid Oracle account with one of the UVA ODS Specialist responsibilities. Then fill out an Integrated System Access Form; the same form you would use to request a new responsibility. In section XIII, check the Add box and write ODS Database Account. The form must be signed by your supervisor. You will be notified by email when you account has been created. Once you are notified of your new account and password, please change the password. See Changing your ODS Database Password.
|
- Because the ODS is behind the firewall, you will need to be logged in through VPN regardless of which tool you are using.
|
Please note that when you connect to the ODS using your database account, the names of the UVA views will differ slightly from what you see in Discoverer or the Help File. The principal difference is that all the UVA view will have _V at the end of their names. However, a few view names may be slightly different in additional ways.
One you have completed the above steps, click on the links below to learn more about connecting to the ODS using specific tools.
BrioQuery
SAS for Windows
ODBC Tools, such as Microsoft Excel and Access |
| |
| |
| |
| |
| |
| |
|
