Menu
This question might not be well researched but I need to find out proper way to implement this solution before starting design.
Question is, Can we consume SSAS MDX query as datasource in Azure Data Factory Linked Service source?
565
To create a new linked service in Azure Data Factory Studio, select the Manage tab and then linked services, where you can see any existing linked services you defined. Select New to create a new linked service.
MDX (Multi – Dimensional eXpressions) is a query language used to retrieve data from multidimensional databases. More specifically, MDX is used for querying multidimensional data from Analysis Services and supports two distinct modes. The Intellipaat SSAS online training is all you need to get ahead in your career.
Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes. It is also a calculation language, with syntax similar to spreadsheet formulas.
Data factory cannot query SSAS with MDX or DAX, but maybe you can query the source of the SSAS, in a traditional BI architecture it would be a Data Warehouse or a SQL server. This is because SSAS models are meant to be consumed by reporting tools (Power BI, reporting services, etc) and not data integration tools, which serve very different processes.
Cheers!
96
The supported list of connectors for the Copy activity available as at today is available here:
https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-data-stores-and-formats
It looks like SSAS MDX queries are not included at this point.
ADF v2 supports the running of SSIS packages within ADF pipelines so it may be possible via that route (untested).
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
