This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 61%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, I need to copy the SSAS cubes data from our vendors server to our server through SQL server or Azure data factory.
Please suggest me the best way to do it.
Will there be any way to create the linked server for Azure Data Factory pipeline to use?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
There are some important points missing. What access do you have to the source cubes and the source server? What kinds and volumes of data do you need to get from there? Is it one-time or regular operation? What is the type of your server, how do you need the data stored there? And, since you ask for 'the best' way, what are your specific criteria for ranking the ways?
Hi AlexeiStoyanovsky, Thank you for the quick reply.
my answers are as below,
What access do you have to the source cubes and the source server? Read Access
What kinds and volumes of data do you need to get from there? Its a time series data with heaps of rows which are created per every 2 seconds but i believe we can summarise it before bringing.
**
Is it one-time or regular operation? **need to retrieve every hour
What is the type of your server, how do you need the data stored there? We have SQL server on Prem also on Azure where we can store data and in tables.
what are your specific criteria for ranking the ways? Priority is to be able to make some sort of connection to automate the data pull from their server and secondly if it can be done through Azure data factory using linked server ?
Hey,
the below blog:
https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/
explains how to copy data from SSAS.
Note : there is no direct connector for SSAS in ADF.
Hi NandanHegde-7720,
Thank you for your reply.
Can you please help me understand if your article is suggesting to create a linked server on SSAS databases and if yes is it possible to do that on the client server and still access that linked server from our server ?
Thank you
Hey,
You need a database server instance (On Prem or IaaS server) to create the linked server between the SSAS and Database instance because you would be querying the cube from the database via open row query.
Now it depends whether the client team creates the linked server in their database instance or you all create it in your instance.
Everything boils down to the network and security configuration of the servers
Note : The Linked service in ADF would be a SQL server database as there is no native connector to SSAS in ADF. So you are leveraging the database to query SSAS
TThank you NandanHegde,
I will check with the clients side if they create one for us.
At the moment we are just RDP into their server to access cubes from excel file. I am not sure if we would be able to create a connection from our side.
Thanks for your help.
Hi NandanHegde , If the client if offering to give us the domain login to their SQL on prem database views, would that still work to access it through ADF link service using those credentials ?
Hey,
IIn case if that is an On prem database server, you would need an Integration run time to access it via linked service.
And you can use windows Auth as long as the domian account has read access on the databse