OBIEE ODBC Client

One of the features you get when doing an OBIEE install on windows is the ODBC Client application.

I never had any use for it until I saw some entries by Nicolas and @lex on some ‘secret’ procedures.

http://gerardnico.com/wiki/dat/obiee/presentation_service/obiee_nqs_drill

http://siebel-essentials.blogspot.com/2009/08/oracle-bi-server-nqs-procedures.html

It appears to by a demo/check tool to test your sql when developing a application which uses a ODBC connection to the BI-server. I couldn’t find any documentation, so tips pointers are welcome.

After starting the application you have to click:

File > Open Database to make a connection:

The usage of the database field is unclear for me at the moment.

From the utility menu you can directly test your BI-server sql:

From the View Schema you get an very unusable info of the catalog:

I couldn’t get the query list to work….

It seems this is a R&D/Q&D tool for the development team which somehow made it’s way into the production release. I you have some more info or usage- for it please let me know.

Till Next Time

OBIEE Remote Admintool login problems

A colleague had a weird problem, he was trying to logon  with the admintool to a remote BI server over the ODBC connection.

 

 

The credentials were ok, so the problem must be something else.

Checking the ODBC manager revealed that he was using a ODBC with a space in the name “Server 01”

A close look a the connection selection screen of the admin tool revealed that OBIEE “translated” the space to an underscore:

Seems you can’t use space in the ODBC connection, use underscores instead.

Till Next Time

OBIEE Where is the ODBC Data Source Administrator?

Stumbled today over an OBIEE sandbox machine without an ODBC Data Source Administrator configured:


We had to dig deep in our collective brain where to find it: ..\windows\system32\odbcad32.exe
In the registry you have give to have full control over the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC


Till Next Time