Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Analysis Services and SQL Azure Expand / Collapse
Author
Message
Posted Wednesday, March 27, 2013 9:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:19 AM
Points: 161, Visits: 506
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
Post #1436253
Posted Thursday, March 28, 2013 4:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:02 PM
Points: 13,638, Visits: 10,530
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1436361
Posted Thursday, March 28, 2013 5:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:43 PM
Points: 15,663, Visits: 28,061
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1436391
Posted Thursday, May 2, 2013 3:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 2, 2013 3:39 AM
Points: 1, Visits: 0
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: www.saasabi.com
Post #1448739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse