Microstrategy reporting

Jamsta1912
Tera Guru

‎05-22-2018 03:11 PM

Hello all,

I have a requirement for data to be pulled from our ServiceNow instance to Microstrategy, for reporting / visualisation. Our reporting team would like to use ODBC rather than web services. My assumption is that they would need to install the ODBC driver, and then Miscrostategy can make use of this as would any other application (eg Excel, Access). My question is - can anyone offer advice / guidance on using ODBC with Microstrategy in particular? Any pointers / things to look out for would be much appreciated.

Regards

Jamie

Labels:
  • 1,664 Views
2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo Patron

‎08-20-2018 11:36 AM

Hi.

 

Better approach is to consume REST API provided by  MicroStrategy to push data from service now to microstategey.

https://lw.microstrategy.com/msdz/MSDL/GARelease_Current/docs/projects/RESTSDK/Content/topics/REST_API/REST_API.htm

Please check below for more resources on  MicroStrategy integration with service now

 

https://tray.io/connectors/microstrategy-servicenow-integrations

 

https://www.cdata.com/kb/tech/servicenow-odbc-microstrategy.rst

 

Regards,

Sachin

Jamsta1912
Tera Guru

‎08-20-2018 12:40 PM

Thank you Sachin for this advice.

0 Helpfuls