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.
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