The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.
OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository.
Example of use of the ODBC BI Server
When you have create an Analytics ODBC Data Source, you can use it:
- perform a connection with admintool: OBIEE - How to connect remotely to the servers (BI, Presentation) ?
- to retrieve data with an ODBC client: OBIEE - How to retrieve data from BI Server in Excel ?