EPM - Accessing EPM via ODBC Overview

This document describes the general process of accessing EPM data via ODBC and contains links to instructions on specific aspects of the process.


One method used to access the EPM data warehouse is a direct database (ODBC) connection. Users must request EPM authorization using the instructions on the UW Service Center Website. Once a user is authorized, he or she will receive a series of emails containing:

  1. EPM credentials (username and password).
  2. Connection entries, to be pasted into Oracle configuration files.

The directions below explain how to use the information contained in an EPM authorization email, together with Oracle software, to create an ODBC connection to EPM. Each document is a step-by-step walkthrough of one aspect of the process. The directions are presented in sequential order.


  1. [Link for document 19305 is unavailable at this time.]
  2. EPM - Editing 'tnsnames.ora' and 'sqlnet.ora' Files
  3. EPM - Configuring Oracle 11g ODBC Driver


The following document describes common errors EPM users may encounter as they attempt to establish ODBC connections: EPM - Common ODBC Errors.

Also more information can be found on the

Keywordstnsnames, tnsnames.ora, names, epm, odbc, enterprise performance management, hrs, data warehouse, data, ora file, sqlnet, ms access, access, tsnnames, tns, oracle database, database, database connection, tnsping, ping, errors   Doc ID19669
OwnerMehrnaz A.GroupData KB
Created2011-08-09 19:00:00Updated2023-11-14 09:21:58
SitesData, Academic Planning & Institutional Research, DoIT Help Desk
Feedback  0   0