Microsoft OLE DB Provider for Analysis Services

[samyurchuk]

Using Qlik Sense September 2018.  I have a crazy requirement to load data from an OLAP Cube.  When creating the OLE DB Connection I do not see Microsoft OLE DB Provider for Analysis Services as a provider.  Is this provider limited to older (or newer) Qlik Sense releases?  or maybe there is another provider that can be used in its place?

[shaun_lombard · Accepted solution]

There isn't a connector to Analysis Services but you can go to the Fact and Dimension tables that build the cubes on SQL Server.

[Andrew_D20]

Was  there previously a connector for Analysis Services?

I've seen numerous links showing an OLE DB Connector for SSAS as a Data Source and even watched a video of data being loaded from SSAS to Qlik

https://youtu.be/b_yeraBHJHw

This is something I need to do.

[jonathanhvid]

Hi Andrew, 

Qlik does not have one at current. However there is one developed by a partner specializing in connectivity:

Take a look at:

The Cube Connector for Microsoft SSAS & AAS | Stretch Qonnect

Hope this helps

[Andrew_D20]

Hi It used to have one?  When was it withdrawn?

[luizcdepaula]

Andrew,

I just had the same issue, and I was able to resolve this issue, by installing Client libraries for connecting to Analysis Services and OLE DB Drivers for OLE DB Driver for SQL Server, because the OLE DB Provider for SQL Server was not working for my connection. Find the links to both drivers below:

Client Libraries for Connecting to Analysis Services (Connect to SQL Cubes)

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers 

OLE DB Driver for SQL Server (Connect to SQL Database)

https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-ser... 

I hope it helps other people. 

Luiz DP

[jonathanhvid]

Hi Andrew,

Sorry, I missed this message. Qlik Market is sadly no more, but you can find the product here:

The Cube Connector for Microsoft SSAS & AAS | Stretch Qonnect

[luizcdepaula]

I just would like to say that we started using Stretch Cube connector and it is making our lives much easier, as cube connections can make a hell out of your life if you can't define which measures and dimensions are coming from what cube, if they have the same names.

Great product.

[jonathanhvid]

Thank you for the kind words, Luiz. I am very happy to hear that you are enjoying the connector 🙂