March 27, 2013 at 9:56 pm
Hi,
Does anyone know why Azure does not include Analysis Services? Aside from available Reporting services, what are the alternatives to creating a DW if the source data is in Azure?
Thanks
March 28, 2013 at 4:07 am
Lexa (3/27/2013)
Hi,Does anyone know why Azure does not include Analysis Services? Aside from available Reporting services, what are the alternatives to creating a DW if the source data is in Azure?
Thanks
You can creat a local DW (with SSAS) with the source being SQL Azure, but I doubt this is very cost effective regarding transfer costs.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 28, 2013 at 5:04 am
Your choices are very limited at present. Until SSAS is included in the Azure stack and until they get the Azure VMs out of beta, your only choice is as outlined, local.
But, you could at least experiment with the Azure VM to see if it can do what you need.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 2, 2013 at 3:41 am
If you're looking for Analysis Services on Azure without maintaining a VM then check out Saasabi. We offer a native SQL Azure OLAP engine as a pay-by-the-month service and you'd be welcome to a free trial: http://www.saasabi.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply