OBIEE 10G/11G - How to create an Analytics ODBC Data Source (System DSN ODBC connexion)

Bi Server Architecture With Client


How to create an odbc DSN to be able to connect to the OBIEE BI Server ?

Operating System


On Windows XP (ODBC - How to create a DSN connection in Windows), go to Control Panel / Administration Tools and open “Data Sources ODBC”. Go to the “System DNS” Tab and click the “Add…” button. Choose “Oracle BI server”, click the “Finish” button and enter the configuration as the pictures below :

  • OBIEE_Repository_Name = A Description of your DSN connection
  • DNS_Name_Obi_Server = The name of your machine in the DNS or the IP

Obiee Dsn Configuration 1

Obiee Dsn Configuration 2


On Linux and UNIX machines, the odbc.ini file is located in the directory:

  • for 10g: OracleBI_HOME/setup.
  • for 11g: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup but you can change it in the opmn.xml configuration file.
Driver = /u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/
Description = Oracle BI Server
ServerMachine = myOBIServer.gerardnico.local
Repository = 
Catalog = 
UID = 
PWD = 
ForwardOnlyCursor = 
SelectPhysical = 
IsClusteredDSN = Yes
Regional = Yes
PrimaryCCSPort = 9706
SSL = No
PrimaryCCS = myOBIServer.gerardnico.local

See Configuring an Analytics ODBC Data Source Under UNIX

Documentation / Reference

Discover More
Card Puncher Data Processing
Exalytics - Timesten Configuration

Timesten on Exalytics To set the resource limits for TimesTen: Make the following changes and additions to the /etc/security/limits.conf file: Make the following shared memory kernel settings in...
Card Puncher Data Processing
Fusion Middelware - OPMN.xml configuration file

OPMN.xml is the main configuration file for OPMN that is used to launch each system component (such as Oracle Business Intelligence). It specifies environment variable (path, ...) PATH LD_LIBRARY_PATH...
Obiee Administration Tools Logon
OBIEE - How to connect remotely to the servers (BI, Presentation) ?

This article shows you how you can perform a remote connections with the OBIEE client tools Administration Tool and catalog manager to manage respectively : the BI Server and the web catalog Variable...
Bi Server Architecture With Client
OBIEE 10G/11G - Oracle BI ODBC driver

The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection. The BI Presentation Service and the Administration Tool use this connection method to connect...

Share this page:
Follow us:
Task Runner