Using the University of Montana Data Warehouse (UMDW)

Table of Contents

1. What is UMDW?

2. Who can use UMDW?

3. Where can I access UMDW?

4. Using UMDW

a. First time users

b. Returning users

c. Troubleshooting UMDW

d. Further Information

NOTE: Throughout this article, you can click on any pictures to expand them.

What Is UMDW?

The University of Montana Data Warehouse (UMDW) is a database application that allows users to see budget information for their departments or programs.

Who Can Use UMDW?

If you believe you need access to UMDW, download the UMDW application here: UMDW Application

You can also click the PDF on the right hand side of this article under "Attachments".

Once completed, email the form to bfinance_security@mso.umt.edu. Generally, this will be done by your supervisor.

Where Can I Access UMDW?

UMDW is accessed via a desktop application on your computer. If you do not see the UMDW icon on your computer's desktop, you will need to request the application to be installed on your computer by filling out a software installation request here: Service - Computer Support Issues or ... (teamdynamix.com)

Using UMDW for First Time Users

Upon launching UMDW for the first time, there are a few initial screens that you will need to go through.

1. Look for the UMDW icon on your desktop, shown below.

2. Upon opening the program, you will be presented with the following warning. You can accept the warning by clicking "Open".

3. Next, you will be presented with two screens: a license agreement and a privacy notice, both shown below. Both can be closed with the "Accept" and "Close" buttons, respectively.

4. Next, you will be presented with the UMDW login screen. However, before using the software, you must first dismiss the security warning across the top of the screen by clicking the "Enable Content" button, shown below.

5. Lastly, you will login using the UMDW login screen, shown below.

- Within the Data Source Name (DSN) box, enter "UMDW.WORLD".
- Your User Name is your University of Montana NetID. If you don't know your NetID, see the Troubleshooting UMDW section below.
- Your Password is not the same as your NetID password for accessing CyberBear. Your initial UMDW password should have been provided by UM. If you have forgotten your UMDW password, see the Troubleshooting UMDW section below.

After entering your login information, click "Login". After your first login, the DSN and your User Name will be auto-filled in the application when you launch the program in the future.

Using UMDW for Returning Users

1. Open UMDW using the icon on your desktop, shown below.

2. If you have accessed UMDW previously, the DSN and your User Name should be auto-filled.

3. Click "Login" or "Re-Link".

Troubleshooting UMDW

• Upon clicking "Login" or "Re-Link", you receive the error "ORA-12154: TNS:could not resolve the connect identifier specified"
  • Contact Computer Support here: Service - Computer Support Issues or ... (teamdynamix.com)
• Upon clicking "Login" or "Re-Link", you receive an error about an incorrect username or password
  • Look up your NetID here: NetID Lookup (umt.edu)
  • Submit a UMDW password reset ticket with UM here: UMDW Password Reset
• For any other issues with logging in to UMDW, contact Computer Support here: Service - Computer Support Issues or ... (teamdynamix.com)

Further Information

• The University of Montana provides training videos and a handbook for using UMDW.

1. General training: UMDW Training (umt.edu)

2. Reports training: UMDW Training (umt.edu)

3. Payroll training: UMDW Training (umt.edu)

4. Training videos: Training Videos (umt.edu)

5. UMDW Handbook: UMDW Handbook