Monday, August 30, 2010

DSN Creation

After installing OBIEE on your local machine, a DSN has to be created which helps in creating connection pool in OBIEE Admin tool to connect to the database. Following are the steps to create System DSN.

Creating DSN

Go to Control Panel>administrative tools> ODBC

Go to System DSN(tab)>add>oracle xe(whichever database)

Enter name for your DSN, tns anything, User id (Schema) and test connections>ok

Note: If OBIEE is installed on 64 bit OS following link would be helpful

http://forums.oracle.com/forums/thread.jspa?threadID=869482

No comments:

Post a Comment