Azure Question posted in
The official documentation to get you started can be found here.

Connecting Azure data factory Integration with On-Premises SSAS Cubes

I’ve been struggling to find a straightforward solution for connecting Azure data factory or Fabric to an on-premises SSAS cube. I’ve searched extensively,

but all I come across are guides on connecting to SQL Server or discussions stating that connecting to SSAS from Fabric isn’t currently available. I’m unsure if I’m pursuing the right approach. Any guidance would be greatly appreciated. Would it be sufficient to install a linked server on the machine and utilize SQL Server as the connector?

Tags:

2

Answers


  1. 0

    To connect to an on-premises SSAS cube using ADF, you will need to install the Self hosted Integration Runtime (SHIR) on a machine that has access to the SSAS cube. You can then configure the IR to register it with your ADF. Once the IR is configured, you can create a SQL server linked service in ADF that uses the IR to connect to the SSAS cube. Below are the steps:

    1. Install the Self hosted Integration runtime on a machine that has access to the SSAS cube.
    2. Configure the installed Integration Runtime. Refer the Microsoft document.
    3. Create a SQL server linked service in ADF that uses the Self hosted Integration Runtime to connect to the SSAS cube.
    Login or Signup to reply.
  2. 0

    Unfortunately Fabric dataflow gen2 and data pipelines do not support SSAS as connector :

    https://community.fabric.microsoft.com/t5/Service/SQL-Server-Analysis-Services-as-a-Dataflow/m-p/827053

    So as a work around, you would have to create a linked server between the SQL server instance and SSAS instance and leverage the SQL connector and then query via Openquery. My below blog explains the same for reference:

    https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search