topic Re: Microsoft OLE DB Provider for Analysis Services in Connectivity & Data Prep

Microsoft OLE DB Provider for Analysis Services

samyurchuk — Mon, 13 Dec 2021 21:47:19 GMT

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?

Re: Microsoft OLE DB Provider for Analysis Services

shaun_lombard — Wed, 09 Oct 2019 03:21:42 GMT

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.

Re: Microsoft OLE DB Provider for Analysis Services

Andrew_D20 — Fri, 21 Feb 2020 12:51:21 GMT

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.

Re: Microsoft OLE DB Provider for Analysis Services

jonathanhvid — Thu, 06 May 2021 13:08:56 GMT

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

Re: Microsoft OLE DB Provider for Analysis Services

Andrew_D20 — Fri, 21 Feb 2020 14:01:22 GMT

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

Re: Microsoft OLE DB Provider for Analysis Services

luizcdepaula — Wed, 24 Jun 2020 00:21:42 GMT

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-server-2017

I hope it helps other people.

Luiz DP

Re: Microsoft OLE DB Provider for Analysis Services

jonathanhvid — Thu, 06 May 2021 13:09:40 GMT

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

Re: Microsoft OLE DB Provider for Analysis Services

luizcdepaula — Thu, 06 May 2021 14:20:19 GMT

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.

Re: Microsoft OLE DB Provider for Analysis Services

jonathanhvid — Thu, 06 May 2021 14:29:37 GMT

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