SSC statistcs reporting in BI?

EgilsB

Currently reporting license usage and user statistics manually from downloaded reports to XLS. Using Power Query to REST API in PowerBI is familiar approach, but suspect this wouldn’t work with SSC?

Any tips / trick to improve on the process would be much appreciated.

lasse.lindqvist

Hi. SSC does not provide any open API for reading those currently, so it is not possible to get the data in an automated way.

EgilsB

@lasse-lindqvist , but an access still would be possible for someone who knows what they are doing (from what I understand - Java)? Another application can think of is user management e.g. user leaving organization would trigger their account deactivation or removal from license pool. Coming from Civil Engineering background api is unchartered territory for me.

lasse.lindqvist

You would have to Selenium (https://en.wikipedia.org/wiki/Selenium_(software)) or similar to automate the browser interaction with the website currently.
You could do account management that way, but it is more cumbersome than direct API usage, which is not possible for SSC.

EgilsB

@lasse-lindqvist , thanks for that, will do some reading and tinkering