February 5, 2017
As I showed in a previous post SharePoint is different Interfaces you can use to access as a data source.
So I we know it can expose it’s List data using the REST or oData protocol.
Open PowerBI and go to GET DATA menu.
Choose OData Feed to connect to your SharePoint data source
Once logged you can choose from your lists
And play around to make your data visible using all the features from PowerBI
Once Finished you can publish your result
Once published you can reach out on the mobile apps.
February 5, 2017
Using PowerBI there are several out of the box Web Services available to connect to. One of them is Google Analytics.
This is how it goes :
Open PowerBI Online version.
Next in the left menu bar click Get Data.
Next select Services
Select Google Analytics and Get it NOW.
Select the authentication and fill in your credentials.
On the left menu bar you can see the Datasets, Reports and Dashboard, and reports that are available out of the box
Next you can Schedule a reload time … the Free edition you can only choose between daily or weekly.
This shows which are the nice capabilities of MS PowerBI platform
As you could see I also connected out of the box to SalesForce.com
February 3, 2016
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.
I built this proof of concept, and will be gradually ad more statistics.
See here for more info on Office365 Reporting web service
Happy Scripting !
March 3, 2015
Since QlikView can’t access certain data sources like MS Analysis Services (SSAS) or other exotic data sources (SAP NetWeaver BI, Hyperion, TERADATA) natively.
We can fall back on the perfect middleware for this being MS SQL Reporting services
The approach is a simple as can be. Setup an SSRS server (can even be the MS SQL Express (Free) Edition & SSRS add-on)
The SSRS report server has natively a web service interface, exposing a SOAP and URL Interface.
Next develop your SSRS reports (which can handle multi data sources in 1 report )
Like for example a SharePoint List combined with an Oracle database, or anything else.
Simular to PowerPivot that can access an SSRS Data Source. We can do the same with QlikView.
Use a Web File connection as Data Source
Fill in your report URL link and add the rs:Format=XML parameter to get an XML output from you report
If all goes well you will get the Report XML output and see the SSRS TABLIX and FIELDS
That’s it, now you are ready to build your QlikView GUI
Once you know this technique you can as well use this to access an SSRS in the MS Azure cloud.
December 3, 2014
When starting to automate the QlikView client you can use AutoIt or Powershell as a client application to run against local or remote server documents
This QlikView application is a guide to the QlikView 11 Automation Interface and the QlikViewOCX API.
The Automation Interface part is intended to serve as an interactive guide to the QlikView Automation API.
– The Object Model sheet provides a simplified model of the API that shows the Class hierarchy.
– The Members sheet contains information on all classes and members in the Automation interface.
– The Examples sheet offers VBscript code examples for a specified class and member.
– The Help sheet contains some explanations on some of the sheet objects in the main sheet and their contents.
The OCX API part is intended to serve as an interactive complement to the QlikViewOCX SDK documentation, which is available as PDF on the QlikViewOCX SDK CD.
– The sheet contains information on all QlikViewOCX specific API members with code examples in VB, C# and VC++.
But what you need is of course knowledge of the QV Object model
You can get this COM API documentation here : http://community.qlik.com/docs/DOC-2640
In this nice QVW file you can find lot’s in interesting information, Help AND +1800 Examples.
This is how they pulled it together
Here is an Example using AutoIT
October 6, 2014
There are numerous tools on the net which will help you to access a MS SQL CE database.
Even PowerShell can do the job, but it is not the same as have a full blown BI Reporting Tool under you fingertips.
So let’s look at QlikView to be able to access the .sdf database.
I used the Northwind.sdf example database
When creating a new report you need to select the data source for a Compact Ed. Database.
But as you can see it it not available in the list
Just type in the connection string yourself like this.
OLEDB CONNECT32 TO [Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=”C:\Northwind.sdf”];
and complete with the SQL statement
SQL SELECT * FROM Customers;
SQL SELECT [Order ID],LOWER(Freight) as Freight, [Customer ID] FROM Orders;
Refresh and you are done.
PS: If it does not work make sure you have installed the MS SQL CE framework in your PC.
October 6, 2014
There are several tools available on the next to query an SSAS OLAP instance using MDX queries.
But most of the time you have the OLEDB drivers on your machine.
But some tools lack the authentication mechanism to poke into an OLAP cube that is not in your domain.
Like this MDX Query generation for QlikView
It allows you to connect but you can’t send across any authentication to connect remotely.
runas.exe /user:YourDomain\User /netonly “C:\Program Files (x86)\MDX Query Generator for Qlikview\QlikviewMDX.exe”
And it will just do fine !