Interactive Reporting - How To's of Data Access

This is an attempt to explain access to data for the primary campus data bases. Contact information for the various data bases is also included.

The largest and most used data bases are InfoAccess (student data), WISDM (financial data), and EPM (HR and payroll data). In addition, the Query Library provides pre-written queries using data from the InfoAccess and EPM data bases.

The Interactive Reporting clients or other query tools such as MS Access may be used to write your own queries directly against a data base. The software for this is installed directly on to the PC. Oracle software and a TNSNames.ora file is also needed. Oracle is the connection software between the PC and the data base and the TNSNames.ora file provides the Oracle server's address for the connection. Interactive Reporting also uses an .oce (Open Catalog Extension) to connect to data bases, and other query tools such as MS Access and Filemaker Pro use ODBC (Open Data Base Connection) and the drivers provided in the Oracle installation.

The IR workspace may be accessed using IE. It provides access to pre-written queries in the Query Library folders as well as other folders established for use by colleges or specialized work areas such as CALS, L&S, SMPH, WiscIt, the Registrar, etc.

This IR workspace also provides access to oce (Open Catalog Extension) direct connections to the data bases mentioned above. These oce connections make it possible to write your own query against these data bases using a web based plug-in. For each of the data bases being accessed through the IR workspace you will find a blank data base document containing the .oce needed for that particular data base.


Data Access Request

Name Database or Query Description Website
EPM Database HR and Payroll https://uwservice.wisconsin.edu/administration/data-warehouse.php#request
InfoAccess Database Student Data https://apps.infoaccess.doit.wisc.edu/ida/home.asp
Query Library Query Pre-written queries https://querylibrary.wisc.edu/request/home.asp
WISDM Database Financial Data http://www.bussvc.wisc.edu/acct/sfs/data.html

To request access to other folders stored in the Interactive Reporting workspace, including those used by the Registrar's Office, L&S, SMPH, CALS, and various DoIT folders, contact the DoIT Help Desk.


Reset Database Passwords

DatabaseManually Reset PasswordReset Forgotten Password
EPM
  • Open Interactive Reporting
  • Right-click the blank query, then select Open As > Interactive Reporting Web Client
  • Click on Tools > Change Database Password
Send a password reset request to servicecenter@uwsa.edu. The UWSC Support Team is also available Monday-Friday, 6:00 a.m. - 7:00 p.m. via phone (855-4UW-SUPP or 608-890-1501).
InfoAccessSee InfoAccess - Password ResetSee InfoAccess - Password Reset
WISDM
  • Go to WISDM
  • Main Menu > My Profile > Change Password
Send a password reset request to sfsmsn@bussvc.wisc.edu .


TNSNames.ora file

If the TNSNAMES.ORA file does not contain the connection information for a particular database, contact the following groups for assistance:

Additional information about the TNSNames.ora file may be found at Interactive Reporting - Do You Have a TNSNAMES.ORA File.

SQLNet.ora file

This file need be edited only for the EPM data base.  Open the existing SQLNet.ora file on your computer and delete all file contents. Once the file is empty, add the following two lines:

SQLNET.ENCRYPTION_CLIENT = REQUESTEDSQLNET.CRYPTO_SEED = XXXXXXXX

Where XXXXXXX = users last name

If this is not changed the user will get an SQLNet error message.




Keywords:data EPM InfoAccess WISDM SFS password tnsnames.ora file sql requestnet.ora file data access   Doc ID:32707
Owner:Tim L.Group:Interactive Reporting Madison
Created:2013-08-12 18:46 CDTUpdated:2016-03-31 14:56 CDT
Sites:DoIT Help Desk, Interactive Reporting Madison
Feedback:  0   0