Office365 has a nice feature that gives you BI reports that you can use to Analyze in QlikView.
More information can found here Office 365 Reporting web service
I quickly build a proof of concept see here How to use QlikView to get MS Azure – Office365 BI Reports | audministrator
This was build based on a macro Library that I wrote to access the MS Azure.
Can't publish the QVW unfortunately because it contains a lot of personal data from our Azure account.
More Integration related articles here QlikView | audministrator
Thanks for the links, the web pages seem to have been moved to a new web address,I am unable to open them. Could you please post the latest URL's ?
Appreciate if you can help , on the POC you have built " How to use QlikView to get MS Azure – Office365 BI Reports | audministrator "
Thanks Patrick, Had a few issues with my browser setting from my work location. Could you please mask your data in the POC that you have built, and share it with me. ?
I have a requirement to study the feasibility of integrating Qlikview with Office 365. Not sure what all data to anlyse using Qlikview.
Appreciate if you advice me
Hi again, sure.
This is the content of the Blog Post.
QlikView Desktop is one of the leading BI In Memory Visualization Tools.
As I have shown in previous posts, this contains a VBScript host engine. And as well the Desktop Client is fully COM Compatible.
Giving these 2 nice bonus points for us scripters
Let see how to use QlikView to provide BI Insights in your MS Azure and Office365 environment.
In the Office365 Admin portal, you can get nice statistics to analyze issues and performance if needed.
But QlikView can serve you better ! Because it is all centralized in your dashboard that is fully customizable
Since it is all in memory, it is lightning fast to do your analysis. If you schedule the QVW you have it all ready each morning.
Happy Scripting !
Thanks for the blog above. Could you please provide me, the QVW file, that you have displayed with screen shots.
Just want to understand, what kind of Connector you have used ? to get the data from the office 365 cloud. and from AZURE, what sort of data are you pulling through.
Appreciate if you could help me with the same.
Raja Sekhar Dumpa
Did someone find a solution for this issue? I have tried many alternatives (Sharepoint List, make a WebDav for the Sharepoint as a Network Drive, qvsource beta connectors doesnt exist anymore) but still havent found a solution that actually work.
Any help its welcome.