Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Microsoft OLE DB Provider for Analysis Services

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?

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator
Creator

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.

View solution in original post

5 Replies
Highlighted
Creator
Creator

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.

View solution in original post

Highlighted
Contributor
Contributor

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.

Highlighted
Partner
Partner

Hi Andrew, 

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

Take a look at Qlik Market:

https://market.qlik.com/solutions/Cube_Connector_for_Multidimensional_&_Tabular_SSAS_Models

 

Hope this helps

Highlighted
Contributor
Contributor

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

Highlighted
Creator II
Creator II

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