Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Can I query OBIEE 12.2.1.4 BI Server open sessions

Hello!
Is it possible to access current status of OBIEE 12.2.1.4 BI Server sessions via some kind of API?
I need to be able to monitor the number of currently open sessions (like in AdminTool Session Manager).
Thanks,
Alex
Answers
-
Hi Alex,
Honestly I'm not aware of an API / webservice giving you the same as the Admin Tool.
And because the Admin Tool goes via ODBC it's encrypted with a custom protocol and never managed to "look" inside to see what it's calling to get the info
0 -
Alex,
That's one of the few calls which can't be pulled out and reproduced manually
0 -
You could do this using the Oracle Enterprise Manager BI Management pack (licensed separately)
https://docs.oracle.com/cd/E73210_01/OEMLI/GUID-B18CF291-36C3-43A5-A900-F17CD99F65EB.htm#OEMLI130
You'll need to install a Management agent on the OBIEE server plus some configuration to point your OBIEE server to the EM instance.
https://docs.oracle.com/cd/E73210_01/GSSOA/GUID-17159CD4-1997-486C-8F9B-2BB68B9E6E37.htm#GSSOA9960
0 -
Yeah because exposing that ONE nqs call would be soooooo hard for them :-P
0