How to: Edit Repository (RPD) Online OBIEE 10g/11g

For a fairly simple task, there is relatively little information on OTN and the OBIEE Admin guide on

How to enable online repository editing:

This how to assumes you're setting up online editing on a windows server that already has, at the minimum, AdminTool installed.  Online repository editing relies on the ODBC protocol to connect to your linux-hosted repository.

-----
 On your windows client, navigate to the Open Database Connectivity (ODBC) screen and select the 'System DSN' tab.

 Click Add and Select 'Oracle BI Server' as the data source

Type in the appropriate name and description. Under the 'server' drop down menu, type in your linux-hosted repository server

Specify the username, password and port #  on the screen below. OBIEE uses default port 9703. Consult your nqsconfig.ini file for details.

Hit Next, ODBC will automatically test your configuration settings. Once complete, click finish and then navigate to AdminTool.exe

Click 'open online' (the blue folder) as seen below:

You should now see the ODBC connection you created as a selectable repository option

keywords: meta data repository, rpd, edit rpd online, rpd online, obiee rpd, obiee rpd admin tool