Tuesday, June 28, 2016

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

On 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

  • Repository_Name represent the logical name set up in the configuration file.
     
     





Login ID: Weblogic username (BI server username)
Password: Weblogic password (BI server password)
Port: BI server port (usually 9703)

If you want to know the port number configured for your BI server while installing follow below link

http://interestingoracle.blogspot.com/2016/06/obiee11g-find-port-numbers-of-em.html

No comments:

Post a Comment