Querying azure analysis services with azure sql database

1
votes

Before we moved to Azure we could query SSAS directly from T-SQL:

SELECT * FROM OPENQUERY(LINKEDSERVER, SELECT {} ...

Is it possible to access and query Azure Analysis Services directly from Azure SQL Database ? The solution doesn't have to be as flexible as openquery. All I want to do is skip middle tier (cache Analysis Services results in C# etc) and allow azure sql and analysis services to talk to each other directly.

1
azuressasazure-sql-databaseazure-analysis-services

1 Answers

3
votes

This isn't currently available in Azure SQL DB but feel free to request it on UserVoice.

As a side note the Azure SQL DB team appears to be using CREATE EXTERNAL DATA SOURCE with TYPE=RDBMS option instead of linked servers. But the list of sources supported in that are very limited so far. Regardless you might keep an eye on that statement in case it is extended in the future.