locked
Processing on premise SSAS tabular cube using ADF pipeline RRS feed

  • Question

  • Hi , 

    I want to create an activity which will process an on premise tabular database.

    Do we have any option to do the same ? Any hint would be much appreciated. 

    -Thanks,

    Pasupathy Devaraj


    Friday, June 16, 2017 8:44 AM

Answers

  • We have a custom activity to send TMSL scripts at https://github.com/Azure/Azure-DataFactory/tree/master/Samples/AzureAnalysisServicesProcessSample. You could put your Azure Batch nodes in a VNET and connect that with your on-prem network via VPN.

    It might be easier instead to just write out a flag file or database entry as part of your data factory activity, and schedule a task on-prem to check for that flag and trigger the job...

    Friday, June 16, 2017 3:39 PM
  • In fact this will not work unless your on-prem SSAS is also exposed to the internet (otherwise you cannot send any XMLA/JSON requests to it from an Azure Batch service)

    what you could do is to set up an on-prem Gateway
    create a stored procedure on a local SQL Server which then triggers the refresh of the SSAS database (via sp_startjob, execute an SSIS package directly or using a linked server to SSAS)

    hth,
    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Friday, June 23, 2017 11:33 AM

All replies

  • We have a custom activity to send TMSL scripts at https://github.com/Azure/Azure-DataFactory/tree/master/Samples/AzureAnalysisServicesProcessSample. You could put your Azure Batch nodes in a VNET and connect that with your on-prem network via VPN.

    It might be easier instead to just write out a flag file or database entry as part of your data factory activity, and schedule a task on-prem to check for that flag and trigger the job...

    Friday, June 16, 2017 3:39 PM
  • In fact this will not work unless your on-prem SSAS is also exposed to the internet (otherwise you cannot send any XMLA/JSON requests to it from an Azure Batch service)

    what you could do is to set up an on-prem Gateway
    create a stored procedure on a local SQL Server which then triggers the refresh of the SSAS database (via sp_startjob, execute an SSIS package directly or using a linked server to SSAS)

    hth,
    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Friday, June 23, 2017 11:33 AM