Table of Contents

About

This article shows you how you can perform a remote connections with the OBIEE client tools Administration Tool and catalog manager to manage respectively :

You must replace all the variables below by your own environment values.

Variable Default Value
Repository_Name Star
Dns_name_obi_server local
Dns_name_presentation_server localhost

Oracle BI Server service

Administration Tools and BI Presentation Service use an analytics ODBC connection to be able to connect remotely to Oracle BI Server.

How to create a System DNS ODBC connexion

Connection with the Administration Tool

Now, when you want to open a online repository, you must have in the ODBC list, your new ODBC connexion. Choose it, fill the good credential and click the Open Button to connect to the remote repository.

Obiee Administration Tools Logon

Connection with the Oracle BI Presentation Service

Open the file instanceconfig.xml and update the node DSN (by default AnalyticsWeb).

 <DSN>OBIEE_Repository_Name</DSN>

Catalog Manager

In the logon screen, you must enter this url

http://Dns_name_presentation_server:9704/analytics/saw.dll

Obiee Catalog Manager Logon