91´ÎÔª

closeup view of rows of ethernet wires plugged into equipment

UM Data Warehouse

UMDW Manual Installation

(If the UMDW installer does not work, you experience problems, or you would like to manually check or install UMDW; here at some things to check)

Log onto the machine using a account that has admin privileges on the computer

Run UMDW Installer:

Download the UMDW Installer and 'Run as Administrator'

(Be sure to reboot after running the installer)

Install ODBC Drivers:

Check whether Microsoft Access is 32-bit or 64-bit and navigate to either:

  • c:\instantclient_18_5\odbc_install.exe

  • c:\instantclient_18_5_64\odbc_install.exe (for 64-bit versions of Office)

Right click the odbc_install.exe and 'Run as Administrator'

Set Environment Variables:

(These should be set already from running the installer)

Navigate to Control Panel->System->Advanced System Settings->Environment Variables

Set PATH:

(Edit Path) Look in 'System Variables' for Path.

Use 'Edit', 'New', and add the proper variable below to the path, then move to the top or font of the list:

  • For 32 bit Access Users: c:\instantclient_18_5
  • For 64 bit Access Users: c:\instantclient_18_5_64

Set TNS_ADMIN:

Look in 'System Variables' for TNS_ADMIN

IF this is a computer joined to the UM domain, set TNS_ADMIN to: \\ummso1\banner\orant\network\admin

(Make sure the user has access to this path, this is the most common cause of the TNS error below) 

Note: If user logs into windows from non UM domain and cannot access the path above.

set TNS_ADMIN to: c:\instantclient_18_5 or set TNS_ADMIN to:  c:\instantclient_18_5_64

When all is set correclty, the Path and TNS_ADMIN System Variables should look like this:

  • Path = C:\instantclient_18_5_64\...
  • TNS_ADMIN = \\ummso1\banner\orant\network\admin

Set the System DSN:

  • Open either the 32-bit or 64-bit ODBC Data Source Administrator, depending on the version of Microsoft Access you have installed.
  • Select the System DSN Tab. You should see UMDW.WORLD in the list, if not:
  • Click the 'Add' button
  • Select 'Oracle in instantclient_18_5, click Finish
  • Enter 'UMDW.WORLD' in the first three text boxes
  • Click 'OK'

Create Shortcut on users desktop:

  • Navigate to C:\Users\Public\UMDW
  • Right click on a2bfinancials32.accdb for the 32 bit version
  • Or
  • Right click on a2bfinancials64.accdb for the 64 bit version
  • Create Shortcut and place this shortcut on users desktop
  • Change the shortcut icon to C:\Users\Public\UMDW\umdw.ico
  • Rename the icon UMDW
  • Remove other UMDW icons from the users� desktop.

To Login:

  • Double Click on the desktop icon to open UMDW
    • Click Open if you see a Microsoft Access security notice
    • If a yellow security warning bar is across the top of the application make sure you click 'Enable Content' before you continue.
  • Type umdw.world for the Data Source Name (DSN)
  • Log In with User Name and password.

Note: This is a separate account that you should have received, not linked to the NetID password.  To Request a UMDW account download the Account Request Form.