Step by Step to Connect Remote RPD from Local Machine

Step by Step to Connect Remote RPD from Local Machine So often I use to access remote RPD's (Dev,QA,Prod etc) to access them I use to use Remote Desk Top.

Recently I have discovered other method to do this, by make using ODBC Data Source Administrator (odbcad32.exe)

Create System DSN with all required information in following way.

Step1 Start-----Run—“odbcad32.exe” Enter. Step2 Go to System DSN,

Click on ADD Choose Oracle Bi Server as Driver.

Step3 Give a generic Name as you wants. Exp Dev-Server-RPD

Description: not a mandatory field

Server: Specify which server repository you want to connect either Machine Name or IP Address ,Click Next.

Step4 Specify login details of RPD /BI Server, Click Next.

Step5 If you wish to change any default behaviors you can change here other wise Click Finish.

Step6 Open Administration (Start—Oracle Business Intelligence –Administration)

Click on “Open Online”

Choose required RPD from list of available BI Servers.

Provide proper credentials, Click Open.

Now you have connected remote server from local machine, what ever the changes you want change them and save they will be reflected on remote server.