OLE DB SSAS provider add to the list

Mr_Pearl — Wed, 11 Jan 2023 05:59:20 GMT

I was wondering if there is anyway we can add more providers to this list here below.

Right now i have installed the Microsft SQL Server Analysis Service (https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions) instaled in our Qlik Server and wondering what needs to be done for Qlik to show it in its OLE DB list?

If we cannot add it to above list. Is there any other way we can can connect to SSAS cube data?

We have Qlik Sense May 2022 version - Qlik sense Enterprise on windows

Re: OLE DB SSAS provider add to the list

Jay_Brown — Tue, 17 Jan 2023 16:44:00 GMT

Hello @Mr_Pearl ,

OLE DB drivers need to be installed at the OS level based on need if they don't ship with your version of Windows. If you install the OLE DB Driver in Windows, it should show up within Qlik Sense.

Note: that for multi-node environments the OLE DB driver must be installed on all rim nodes, so if you are multi-node check this first.

Let me know if this helps!

Best,
Jay

topic Re: OLE DB SSAS provider add to the list in Connectivity & Data Prep

OLE DB SSAS provider add to the list

Re: OLE DB SSAS provider add to the list