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.

Background:

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.

Directions:

  1. EPM - Downloading and Installing Oracle 11g Client and ODBC Driver for Windows
  2. EPM - Editing 'tnsnames.ora' and 'sqlnet.ora' Files
  3. EPM - Configuring Oracle 11g ODBC Driver

Errors:

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




Keywords:tnsnames, 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 ID:19669
Owner:Leah S.Group:DoIT Help Desk
Created:2011-08-09 19:00 CDTUpdated:2012-05-10 14:41 CDT
Sites:DoIT Help Desk
Feedback:  1   0