�ϻ��DW Manual Installation

closeup view of rows of ethernet wires plugged into equipment

�ϻ�� Data Warehouse

�ϻ��DW Manual Installation

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

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

Run �ϻ��DW Installer:

Download the �ϻ��DW 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 �ϻ�� 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 �ϻ�� 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 �ϻ��DW.WORLD in the list, if not:
Click the 'Add' button
Select 'Oracle in instantclient_18_5, click Finish
Enter '�ϻ��DW.WORLD' in the first three text boxes
Click 'OK'

Create Shortcut on users desktop:

Navigate to C:\Users\Public\�ϻ��DW
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\�ϻ��DW\umdw.ico
Rename the icon �ϻ��DW
Remove other �ϻ��DW icons from the users� desktop.

To Login:

Double Click on the desktop icon to open �ϻ��DW
- 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 �ϻ��DW account download the Account Request Form.

�ϻ�������

�ϻ������� Data Warehouse