EPM - Configuring Oracle 11g ODBC Driver
Once the ODBC driver is installed and tnsnames.ora and sqlnet.ora files are configured, users must specify connection settings for the ODBC driver in the 'Data Sources' administrative tool.
Click on Start > Control Panel > Administrative Tools
Double-click Data Sources (ODBC) and select the System DSN tab.
Click Add... and select the 'Oracle 11g' driver. If this driver does not appear in the list, Oracle 11g software may not have been installed correctly.
Fill out the following fields:
- Data Source Name: Name used to identify data source.
- Description: A description of the data source.
- TNS Service Name: The name of the connection entry in tnsnames.ora (should auto-populate based on the contents of the file).
- User ID: The username assigned to you in one of the initial EPM authorization emails.
Uncheck the box labeled Enable Query Timeout to prevent timeout errors on long queries. Click Test Connection. If you receive an error message, please refer to EPM - Common ODBC Errors for recommendations. Otherwise, click OK to save the connection.