To create a DSN using the BI Server ODBC driver:
Launch the ODBC Data Source Administrator and select System DSN.
Select Add to add a new data source.
In Create New Data Source, select Oracle BI Server.
In Oracle BI Server DSN Configuration, do the following:
Enter a name for the DSN.
Enter a login ID and password.
Select a database.
(Optional) Select a default catalog.
Click Finish.
Click OK to exit the ODBC Data Source Administrator.